[This topic is migrated from our old forums. The original author name has been removed]
I have a database table called "order". Autocomplete feature does not work properly for this table. I presume this is because "order" is a reserved SQL word. For example:
select * from order where
In this scenario, when cursor is at , CTRL+Space does not offer any autocomplete options.
DBVisualizer 7.0 and 6.5.11
Thanks for your post!
I have registered this as an issue. The current workaround is to enclose the order table in double quotes, "order".
about 8 years ago
[This reply is migrated from our old forums. The original author name has been removed]
Re: Autocomplete on
Unfortunately, using double quotes around the table name yields a syntax error on Informix. The workaround I'm using at present is to use the fully qualified table name (informix.order). This way, both the query and autocomplete work.