TAstaClientDataSet.SQLGenerateLocation

Applies to
TAstaClientDataSet

Declaration
type TGenerateSQLLocation = (gsClient, gsServer);

property SQLGenerateLocation: TGenerateSQLLocation;

Description
An AstaClientDataSet can generate SQL on either the client or on the server. If you want complete control over the SQL generated by ASTA you can move the SQL generation to the ASTA server and get “between” each row of SQL that ASTA generates. To make an TAstaClientDataSet updatable that is connected to a TAstaProvider set the SQLGenerateLocation to gsServer and the EditMode will be set to Cached. The EditMode property editor is only used when using ClientSide SQL and not with TAstaProviders. TAstaProviders only support Cached Edit mode and to simulate AfterPost edit Mode behavior you can call ApplyUpdates from withing the AfterPost event.