TAstaClientDataSet.SQL

Applies to
TAstaClientDataSet

Declaration
property SQL: TStrings;

Description
The SQL property allows you to enter SQL Queries. It operates just like the TQuery.SQL property. When used at design time, it will set the active property to False. To populate at design-time just set the Active property to True. If your SQL is valid, and you have an ASTAServer running, the AstaClientDataSet will populate. Once the dataset populates at design time ASTA will not attempt to refetch FieldDef information or data unless you change the SQL or you use the SQLWorkbench Property and click on the Design Populate button. This is to minimize unnecessary communication between to the server.