Start a new topic

Autocomplete on

[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.]

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
[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