dbExpress: "Sql Information Exception"

rafaelvg · Post by **rafaelvg** » Sat 05 Jul 2008 21:15

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

Plash · Post by **Plash** » Mon 07 Jul 2008 07:59

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.

rafaelvg · Post by **rafaelvg** » Mon 07 Jul 2008 23:21

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

Plash · Post by **Plash** » Wed 09 Jul 2008 12:27

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