ExecSQLStatementSource

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);
end;