It's great that SQL explorer offers autocomplete of
standard SQL terms.
I think it would be even more useful to also offer
autcompletion of table and field names. I know the
standard SQL pretty well but I always have to have the
DB reference open to remember table and field names.
So if I typed SELECT FROM/DELETE FROM/INSERT
INTO/UPDATE it could popup the autocomplete selector
containing the tables of the currently selected
database, and then when I got to INSERT INTO blah (...
it could popup the field names, and maybe even have one
which was a concatenated list of all the fields, in
case I wanted to just add the lot. Ditto for the
relevant points within select/update/deletes.
What do you reckon?
Logged In: YES
user_id=1008644
yes, this is something that needs to go in the next release
Logged In: YES
user_id=1008644
Sorry, no time currently to continue on this issue.