Zeoslib Portal

Posted: **25.03.2024, 15:00**

Hi,
I am trying to execute in a clientdataset the follow command text:

SELECT VENDABUSCADESC FROM GETPERMISSAO(27400001)

But i receive ths error:

Remote error: SQL Error: request synchronization error; GDS Code: 335544364; Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements
Code: -901 Message: isc_dsql_free_statement

I am using Firebird 2.5.9.27139. Is this some configuration in the datasetprovider?

Posted: **26.03.2024, 15:32**

Hello amonteiro,

I found a simi98lar problem (TClientDataset, Firebird, request synchronization error) in the german Delphi Praxis:
https://www.delphipraxis.net/177886-fir ... error.html

The solution there was to only call Open onm the client datasets but not on the datasets that were used for data retrival.

With best regards,

Jan

Posted: **27.08.2024, 13:52**

Hi marsupilami,

I set in my source code the follow commands:

Code: Select all

   with cdsAutorizar do 
   begin
      try
         Active := False;
         CommandText := 'SELECT VENDABUSCADESC FROM GETPERMISSAO(27400001)';
         Open;
      except
         on E:Exception do
         begin
            ShowErrMsg(E.Message);
         end;
      end;
   end;

But i already receive the same error: SQL Error: request synchronization error

Zeoslib Portal

SQL Error: request synchronization error

SQL Error: request synchronization error

Re: SQL Error: request synchronization error

Re: SQL Error: request synchronization error