SQL Error: request synchronization error

[amonteiro]

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?

[marsupilami]

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

[amonteiro]

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