[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.
Tested on:
DBVisualizer 7.0 and 6.5.11
Windows XP
Informix 10
Regards,
Ivan
[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.
Regards,
Ivan
Roger Bjärevall
said
about 14 years ago
[This reply is migrated from our old forums.]
Re: Autocomplete on
Ivan,
Thanks for your post!
I have registered this as an issue. The current workaround is to enclose the order table in double quotes, "order".
Best Regards
Roger
anonymous