Start a new topic

Code assist does not work for Informix cross-db queries

[This topic is migrated from our old forums. The original author name has been removed]

This is more a feature request than a bug, but it would be very useful to have. To recreate, you need an instance of Informix with two databases, e.g. db1 and db2. Create a table in the first database (db1), e.g.: CREATE TABLE test (id_col INTEGER); In SQL commander, select the second database (db2), and it is possible to query the above table by writing: SELECT * FROM db1:test; In this query, code assist (ctrl+space) does not offer a list of columns when the cursor is positioned just before "*" , as it does with tables within the same database. Also, code assist should show a list of tables in db1 database when positioned just after the ":" in the statement. Both these features work in MySQL, which uses a dot to separate database and table name in the query (e.g. SELECT * FROM db1.test) instead of the colon which is used in the Informix query.

[This reply is migrated from our old forums.]

Re: Code assist does not work for Informix cross-db queries
Hi Ivan, I have opened as ticket for this, but I can't promise it will be fixed during the EA period before the next feature release. Best Regards, Hans
[This reply is migrated from our old forums. The original author name has been removed]

Re: Code assist does not work for Informix cross-db queries
That's OK. Just so that you have it on record and fix it when you have the time. Regards, Ivan
[This reply is migrated from our old forums.]

Re: Code assist does not work for Informix cross-db queries
Hi Ivan, Just wanted to tell you that this is now fixed in the just released 9.0 version: http://www.dbvis.com/doc/relnotes/?version=9.0 Best Regards, Hans