I tried using IBX components but they are not as complete as BDE components. TTable doesn't have FindKey, FindNearest, GotoKey, there is no TBatchMove, etc.

Now I just make only one question so I can try a new idea. I want to start a transaction directly with an SQL instruction executing the following code:

with TQuery.Create(nil) do
begin
DataBaseName:=DataBaseGeneral.DataBaseName;
SQL.Clear;
{ SQL.Add('SET TRANSACTION NO WAIT ISOLATION LEVEL READ COMMITTED NO RECORD_VERSION');}
SQL.Add('SET TRANSACTION');
ExecSQL;
Free;
end;

But at the instruction "ExecSQL" I get an error message "General SQL Error. invalid transaction handle (expecting explicit transaction start)".

I tried with the instruction "SQL.Add('SET TRANSACTION');" or with the other one that is commented.

Can anybody tell me what´s wrong in what I´m doing?

Gustavo
----- Mensaje original -----
De: Fernando Buitrago
Para: firebird-support@yahoogroups.com
Enviado: Miércoles, 17 de Noviembre de 2004 16:58
Asunto: Re: [firebird-support] Re: InterBase, Dephi, BDE and Transactions


Wel, I do not why you-r using the BDE.......don't you want to use the
direct connection using IBX?

In this case, all is so easy.

Regards

Fernando


[Non-text portions of this message have been removed]