The ExecSQLStatementSource function executes an aSQL query against the database, and returns either True or False depending on the success of the query.
The SQL query is executed against a DB Connection on the Source of the Map.
This is commonly used with SQL statements that do not return a dataset e.g. Insert or Update.
aDBIndex indicates which of the DB Connections is used based on its zero based index.
Declaration: function ExecSQLStatementSource(const aSQL: string; aDBIndex : integer): boolean;
An example of the use.
procedure OnMapEvent(var Value:Variant);
begin
Value := ExecSQLStatementSource('update dr_accs set name='cam' where accno=1',0);