Direct SQL access

BIZ TMS Aurelius
1

Wagner,


Is there a standard way on Aurelius that I could send a complete SQL sentence to be executed on the database?

The fact is that I could be using SQLite or Elevatedb or RemoteDB. I want to pass a specific SQL sentence independent of each driver in use. Sure I need to be careful about the cross compatibility of SQL syntax.
2

Yes, using IDBConnection:

var
  MyConn: IDBConnection;
  Stmt: IDBstatement;
begin
   ...
  Stmt := MyConn.CreateStatement;
  Stmt.SetSQLCommand('INSERT INTO BLA...');
  Stmt.Execute;