ASTA SQL Generation


 

ASTA can generate SQL either on the client or on an ASTA server. You may configure ASTA to generate SQL according to your database requirements.There are several properties and events that can be changed to customize your SQL syntax. The following properties and events are available on the client using a TAstaClientSocket and on the server using an TAstaSQLGenerator.

 

Properties

SQLOptions

UpdateSQLSyntax

SQLDialect

DateMaskForSQL

DateTimeMaskForSQL

 

Events

OnCustomParamSyntax

OnCustomSQLSyntax

 

When SQL is used on the client, SQL for inserts, updates and deletes is generated by ASTA and posted to the server. When there is NO SQL on the client, inserts, updates and deletes are accomplished by sending an OldValueDataSet and a CurrentValueDataSet to TAstaProviders which generate SQL on the server and provide events that you can code to get "in between" this SQL generation.

 

See also More on SQL Generation.

 



ASTA Overview Server Side vs. Client Side SQL Suitcase Model