Doubt using Firedac with Tclientedatset

Asked

Viewed 2,121 times

-1

I am using these components but am having the following error while trying to open Clientdataset.

Generates the error:

Access Violation at address 50FCDC6F in module 'dsnap230.bpl'. Read of address 00000000.

Tdfconnection for connection to the bank

Tdfquery with sql query of a table for testing

Tdatasetprovider with the Dataset property connected to Tdfquery, enabling poAllowCommandText properties is poPropogateChanges

Tclientedatset connected to Tdatasetprovider in the Providername property

inserir a descrição da imagem aqui

  • 2

    Give more details on your question, Delphi which version? xe2 3 4 5 6 7 8 9 10 ... Which database? ... Is the database external or internal?? The error is giving before compiled,during or after?? What android, windows or Ios structure? You tested the manual connection by the component to verify that the connection to the bank is functional??

2 answers

0

Try using the Fdmemtable component instead of the Clientdataset and instead of using the Datasetprovider use the . Data from Fdquery and . Memtable date to pass content. After I started doing this I no longer had a headache with Clientdataset. Example:

  if (FDQuery.Active) then
    FDQuery.Close;
  FDQuery.SQL.Clear;
  FDQuery.SQL.Add('SELECT CAMPO FROM TABELA');
  FDQuery.Open;
  FDMemTable.Data := FDQuery.Data;

0

add 'MidasLib' to use where you have yours ClientDataset to make the remote connection with the dataSetProvider.

  • That I had already done, is not solves the problem

  • The information is incomplete: Can you open Fdconnection? Can you open Fdquery without Datasetprovider+Clientdataset? Test by component. 1) Fdconnection, 2) Fdconnection + Fdquery, 3) Fdconnection + Fdquery + (Datasetprovider, Clientdataset). Then you’ll know where the mistake is. I use Firedac and this error never occurred, and I cannot help you because you have not put the connection properties you are using, nor the SQL content of the inserted in the query. This way, the problem can be from Fdconnection to Clientdataset properties.

Browser other questions tagged

You are not signed in. Login or sign up in order to post.