Autocomplete on : DbVis Software

a

anonymous

started a topic almost 15 years ago

[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

Roger Bjärevall

said almost 15 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

a

anonymous

said almost 15 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.

Regards,
Ivan

How can we help you today?

Autocomplete on

anonymous

Roger Bjärevall

anonymous