HomeFlySpeed SQL Query2.6 Release - Sweet!!

2.6 Release - Sweet!!

Outstanding! There are a handful of features (Clipboard capability, especially) that I am thrilled to see added! Nice work!
DJGray | email
May 27 2009, 02:23 PM
I dunno. Can't get the new filter feature to work at all. Always get "Exception EOException in Module Flyspeed SQL Query.exe at 005B376D." And depending on the field, I also get something like "Syntax Error in WHERE Clause" or something more specific like "Syntax Error (missing operator) in Query expression 'Product Name= 'Northwind Traders Almonds". I've only tried out this new tool in a sample Access 2007 database, but I don't like it well enough to bother even if it did work. For one thing, the filters are too simplistic. You can't select multiple filters for a field (AND, OR), or a range (BETWEEN), or LIKE. Also, I'd prefer if there was a filter arrow per column. Please see filter implementation in Access 2007 or Excel 2007 (one important date filter missing in those applications is last x months or last x years).

Furthermore, it would be great if these filter options (of course with the option to create your own expression) could be added to the criteria column in the query grid pane.
Colin Banfield | email
3 days, 23 hours since original post
This topic is closed