dbExpress: "Sql Information Exception"

dbExpress: "Sql Information Exception"

Postby 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
rafaelvg
 
Posts: 3
Joined: Sat 05 Jul 2008 16:24

Postby 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.
Plash
Devart Team
 
Posts: 2844
Joined: Wed 10 May 2006 07:09

Postby 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
rafaelvg
 
Posts: 3
Joined: Sat 05 Jul 2008 16:24

Postby Plash » Wed 09 Jul 2008 12:27

We'll add the support for COMMIT and ROLLBACK statements in the next build of the driver.
Plash
Devart Team
 
Posts: 2844
Joined: Wed 10 May 2006 07:09


Return to dbExpress driver for InterBase & Firebird