Page 1 of 1

Query Builder question

Posted: Mon 14 Aug 2006 16:06
by snorkel
Is there a way to tell the query builder to show all tables before the show or show modal command is given?

The problem is I load the sql that was previously built with all tables it raises a error saying it can't find the tables from another database.

It would be nice to have a property like showalltables:=true;

Thanks,

Snorkel

Posted: Wed 16 Aug 2006 10:51
by Antaeus
If you work with some databases simultaneously use the following naming notation: .. If such prefix is not used, table from current database is assumed.