Questions tagged [tclientdataset]

TClientDataset represents an in-memory dataset implementing a database-independent dataset. It is defined in the DBClient.pas unit.

TClientDataset represents an in-memory dataset implementing a database-independent dataset. It is also known as MyBase. It is defined in the DBClient.pas unit.

299 questions
0
votes
1 answer

Fetching multiple nested datasets in Delphi DataSnap

I have Delphi client-server application that uses DataSnap. On client side I have a chain of nested client datasets (cdsMaster -> cds1 -> cds2 -> cds3). TDM = class(TDataModule) cdsMaster: TClientDataSet; cdsMaster_cds1: TDataSetField; cds1:…
Sergey40a
  • 3
  • 2
0
votes
0 answers

Data Refresh From Database when using TADOQuery, TClientDataSet, TDataSetProvider in Delphi

I have a TADOQuery connected to a database, and sql set to fetch data. TDataSetProvider to the above query TClientDataSet connected to the provider TDataSource connected to the Data set Data source connected to a TcxGrid The Client Data Set is also…
0
votes
2 answers

TClientDataset.ApplyUpdates fails with 'SQL not supported' when using SQLDirect components

After updating from DelphiXE2 to Delphi Seattle 10 Update 1 we have issues executing TClientDataSet ApplyUpdates calls when using the SQLDirect components version 6.4.5 I made a small test app. Components: TDBGrid -> TDataSource -> TClientDataSet ->…
Jan Doggen
  • 8,799
  • 13
  • 70
  • 144
0
votes
1 answer

Clientdataset Append/Post fails intermittently

I have an external message coming in every second. The message payload is saved in a ClientDataSet and displayed in a dbGrid. No data base is involved. RAM storage only. This works fine, BUT, I have intermittent problems when the dataset is empty…
AndersJ
  • 411
  • 1
  • 3
  • 15
0
votes
1 answer

TClientDataSet error executing with TParam of blob type (ftBlob)

We are using MSSQL 2012. Trying to update Client photo with Stored Procedure spui_SetClientPhoto int ClientID VarBinary(Max) Photo Program runs fine with pure…
user3715238
0
votes
0 answers

Has disabling TDataset.ObjectView side-effects?

Today I stumbled over the adt field types in Delphi Datasets. We use custom client datasets to bind objects to datasets in our views. With that dataset and our custom derivation of TDbGrid and enabled FastMM4 full debug mode we get an access…
ventiseis
  • 3,029
  • 11
  • 32
  • 49
0
votes
1 answer

FastReport Master-Detail ClientDataSet Show Master Records with Empty Detail

I have 2 ClientDataSet Master and Detail and I use FastReport to print the report the problem is FatReport print only Records with details I have some Master record doesn't have details and I still want to show them in report So how can I print…
0
votes
1 answer

Show Aggregate from another ClientDataSet

I work on a project contain 2 ClientDataSet the first ClientDataSet1 contain a field with type DataSet set to ClientDataSet2 I want show sum of field (Value) in ClientDataSet2 in field (Sum) in ClientDataSet1 Now I use aggregate to get the sum but I…
Delphi Lover
  • 85
  • 1
  • 11
0
votes
1 answer

Delphi, ClientDataSet and threads

I have a TClientDataSet that holds information and is not linked to any GUI component. In a thread I locate the relevant record, go into edit mode and change the values. Because it happens inside a thread, I use TCriticalSection before locating…
Amos
  • 1,321
  • 2
  • 23
  • 44
0
votes
1 answer

Delphi Datasnap send ClientDataSet to Server using tcp/ip

I have a simple DataSnap TCP/IP based client server application. I created a ClientDataSet on Client Application and filled it some data. Now how can I send my ClientDataSet records to Server so that I can process it and eventually save some data…
ary
  • 939
  • 2
  • 13
  • 32
0
votes
1 answer

Delphi - TClientDataSet: Second call to applyupdates() does not apply the updates

Again I have a problem with the TClientDataSet. I guess it's something really simple but I struggle on it for a while now. Here's some code what shows what I want to do: procedure TForm1.Button1Click(Sender: TObject); begin ClientDataSet1.Insert; …
doubleu
  • 119
  • 3
  • 10
0
votes
3 answers

Display message on query completion

I am querying a firebird database with a relatively complicated query that takes a while to execute and thought that it would be helpful if the user could get some form of feedback regarding the progress of the query. I intend to display a suitable…
No'am Newman
  • 6,395
  • 5
  • 38
  • 50
0
votes
0 answers

How to Modified or permanently delete Field in the DBGrid with Delphi?

how so that I can remove / modify fields in the DB Grid permanently? I use this code: NB : CDS = ClientDataSet DBG = DBGrid Database I use is *.xml uses Windows, SysUtils, Forms, ExtCtrls, Buttons, DB, DBClient, DBGrids, Grids,…
X-88
  • 117
  • 1
  • 2
  • 10
0
votes
0 answers

Firedac migration from BDE

My name is Stefano Fanti,I am a developer in Plexa.We are actually using your component ( FireDAC ) and I am contacting you in order to solve some problems we have not been able to fix ourself. In our company we decided to port a legacy 3-Tier…
0
votes
1 answer

tclientdataset's delta property

do any one know the how to clear the data in the delta of the TclientDataSet explicitly? without using applyupdates thanks in advance, Vijay.
Vijay Bobba
  • 313
  • 4
  • 15