Query Builder question

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
snorkel
Posts: 384
Joined: Tue 08 Aug 2006 15:10
Location: Milwaukee WI USA

Query Builder question

Post by snorkel » Mon 14 Aug 2006 16:06

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

Antaeus
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Wed 16 Aug 2006 10:51

If you work with some databases simultaneously use the following naming notation: .. If such prefix is not used, table from current database is assumed.

Post Reply