Generally we like the product and will most likely buy it for the $50 price. Here's a few things we've found so far in testing...
SELECT * FROM table WHERE.....
If you select the table name from the drop down list with TAB or ENTER then after the WHERE you get a list of column names which is great. But if you actually type the table name in then after the WHERE statement you only get a list of functions - not column names. I quite often type in table names then would look to the drop down list for the column names
I'd like some way of choosing column names when I'm writing a select statement such as
SELECT col1, col2, col3, etc.. FROM table
UPDATE table SET col1 = x, col2 = y...
With the UPDATE statement only the first column after the SET statement gives you a drop down list.
I've added a snippet of the form select count(*) from
When you use this it misses out the brackets and gives you select count* from
cheers
Gordon
After reading some other posts here I realise that my first point is actually a case-sensitive issue - if I type the table name in the correct case I do get the column names in the drop down list. It would be good if this was case insensitive.
SELECT * FROM table WHERE.....
If you select the table name from the drop down list with TAB or ENTER then after the WHERE you get a list of column names which is great. But if you actually type the table name in then after the WHERE statement you only get a list of functions - not column names. I quite often type in table names then would look to the drop down list for the column names
I'd like some way of choosing column names when I'm writing a select statement such as
SELECT col1, col2, col3, etc.. FROM table
UPDATE table SET col1 = x, col2 = y...
With the UPDATE statement only the first column after the SET statement gives you a drop down list.
I've added a snippet of the form select count(*) from
When you use this it misses out the brackets and gives you select count* from
cheers
Gordon