StartTransaction

[JOSE ALCANTARA]

 

Greetings guys, When I use the StartTransaction and an error occurs, the message is given to me on the server side Example:

  uniMainModule.FDCon.StartTransaction;
  Try
     qClientes.SQL.Clear;
     qClientes.SQL.Add('Select * from Cliente '
     +' where inactivo = 0 '
     +' Order by Nombre');
     qClientes.Open;

    uniMainModule.FDCon.Commit

  except
     on E:Exception do
     begin
        UniMainModule.FDCon.Rollback;
        Application.MessageBox( PChar( E.Message ), 'Error', MB_ICONSTOP );
     end;
  end;

 

In this example cause an error the table is called Clientes, the error is displayed on the server side.

 

what am I doing wrong?

 

[Sherzod]

Hello, 

First of all please specify which edition and build of uniGUI are you using? And see the documentation.

[JOSE ALCANTARA]

Sorry,

Edicion 1.90
comp. 1555
Delphi 10.4

[Sherzod]

Are you using trial version? If not, please adjust your forum email address. 

[JOSE ALCANTARA]

 

Yes, I am in the process of unigui testing

[Sherzod]

36 minutes ago, JOSE ALCANTARA said:

Yes, I am in the process of unigui testing

http://unigui.com/resources/online-documentation/developer-manual

[Isabelle]

you don't need to call "StartTransaction" because there is no transaction to do, it's just a query with "Select".

Only use:
 

qClients.Close;

qClients.SQL.Clear;

qClients.SQL.Add('Select * from Client ' +' where inactive = 0 ' +'Order by Number');

qClients.Open;

 

[JOSE ALCANTARA]

Thank you Isabelle,

 

I know, it was just an example

 

 

[JOSE ALCANTARA]

El 17/09/2022 a las 10:11, Sherzod dijo:

http://unigui.com/resources/online-documentation/developer-manual

Greetings Sherzod,

It's not that the code I have doesn't work, it does the Rollback and commit perfectly, the only problem is that when an exception arises the message is given on the server side, if that happens to a user, it simply hangs app and you won't know what's going on