UpdateSQLSyntax

Applies to
TAstaClientSocket

TAstaSQLGenerator

Declaration
property UpdateSQLSyntax: TAstaUpdateSQL;

Description
There is no SQL standard for date and time syntax. UpdateSQLSyntax allows you to set set the way dates and datetime fields are represented in the SQL statments generated by ASTA.

usAccess            Handles date and time data according to Access syntax rules.

usBDE            Uses the BDE syntax for data and time data.

usODBC            For use with the ODBC demo server.

usODBCold            For use with versions of ODBCExpress prior to 5.02 when double colons where required when sending time values to a server

usOracle            For use with Oracle

See SQLGeneration for a full discussion on the SQL that ASTA can generate.