This ExecSQLStatementDest function executes an aSQL query against the database, and returns either a True or False, depending on the success of the query. This is commonly used with SQL statements that do not return a dataset eg Insert or Update.
The SQL query is executed against a DB Connection on the Destination of the Map, and will become part of the default SQL Transaction that is open against the Destination database.
In terms of process management, this means that any queries will be rolled back if the Action fails.
aDBIndex indicates which of the DB Connections is used based on its zero based index.
Declaration: function ExecSQLStatementDest(const aSQL: string; aDBIndex : integer): boolean;
Example
procedure OnMapEvent(var Value:Variant);
begin
Value := ExecSQLStatementDest('update dr_accs set name='cam' where accno=1',0);