TAstaClientSocket.SQLTransactionStart

Applies to
TAstaClientSocket

Declaration
property SQLTransactionStart: string;

Description
Some databases allow transactions to be started and ended using SQL commands. Under ODBC, you can use Begin Transaction and COMMIT. If your database has these types of commands and you call AstaClientDataSet. ApplyUpdates(usmUseSQL) then the SQLTransactionStart and SQLTransactionEnd string properties will be used.

The preferred way of using transactions is to call AstaClientDataSet.ApplyUpdates(usmServerTransaction) which calls the AstaServerSocket.OnTransactionBegin event of the server to start a transaction and OnTransactionEnd to end a transaction.