Devart Forums

Hello,

if i use the Interbase (CoreLab) driver in my SQLConnection (Delphi application), when i try to execute the following command, i see the exception "Sql Information Exception"

Query := TSQLQuery.Create(nil);
try
Query.SQLConnection := SQLConnection;
Query.SQL.Text := 'COMMIT WORK';
Result := Query.ExecSQL(True);
finally
Query.Free;
end;

if i use the Interbase driver, i don't see that exception.

what does this exception means?

thanks

Core Lab driver for InterBase does not support COMMIT statement in the SQL property.
You should use the StartTransaction and Commit methods of TSQLConnection component.

We'll consider the possibility of adding support for COMMIT in the SQL property.

I'd like to buy the dbexpress driver for Interbase and I need the support for sql COMMIT statement.

So, what's the possibility of adding support for COMMIT?

thanks,
Rafael

We'll add the support for COMMIT and ROLLBACK statements in the next build of the driver.