HomeActive Query BuilderDisable SQL execution when adding tables.

Disable SQL execution when adding tables.


When we drag and drop a table into the query builder, the SQL "SELECT * FROM xxx" is automatically executed, returning all data from that table.

How can we disable that? The problem in our case is that a table has a lot of data and we don't want it to be executed automatically. We want to let the user choose the fields and the criterias and then hit a button to execute it.

Thank you

Martin | email
April 28 2009, 07:54 AM
Dear Martin,

This query is executed to retrieve list of fields for a table. To disable execution of these queries, you should turn Active Query Builder in offline mode (see the OfflineMode or WorkOffline properties depending on the component's edition you have).

To work in this mode, you should provide the information about fields of your tables by yourself.

See this forum topic (http://www.activedbsoft.com/helpdesk/index.php?pg=forums.posts&id=6&pc=2) and use the Load Metadata demo to learn more about loading metadata in offline mode.
Sergey Smagin | email
17 hours, 10 mins since original post
This topic is closed