Stack Overflow
Stack Overflow

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
0 answers

Open more ClientDataSets at same time with TTHread

I'm a beginner with threads in delphi. I wrote this code and it works very well. It starts with opening ClientDataSet1 until it is completed and then opening ClientDataSet2 and so on. My question is: how to start opening them at the same…
Ferrero
  • 21
  • 2
0
votes
1 answer

Delphi: Sort ClientDataSet by datetime asc, nulls last

I need to sort a ClientDataSet by a DateTime field, e.g. next_due_date, in ascending order and with null values last. I will be adding new records at runtime and I am not allowed to execute the SQL query again. Can you use an index on a…
Michael Skrzypietz
  • 3
  • 3
0
votes
1 answer

Delphi DBGrid set column width and scolling effect

I have my DBgrid connected via TDataSource and Firedac TFDQuery. Data is populated from query. Headers are the fields returned by the query. I want to make 1st and 5th column non resizable and other fields as resizable. How Do I fix column width…
poonam
  • 748
  • 4
  • 19
  • 40
0
votes
0 answers

What is the proper method for loading and saving nested clientdataset data below the top level?

I am designing a program using a three level clientdataset, top level: cdsMaster with two nested levels: cdsTables & cdsNotes. In use the program should create the structure and post one record in cdsmaster at runtime. My intent is that the user…
Ashlar
  • 636
  • 1
  • 10
  • 25
0
votes
1 answer

Assign, memcpy or other method required for TClientDataset or TDataSetProvider (dbexpress)

I'm usign the dbExpress components within the Embarcadero C++Builder XE environment. I have a relatively large table with something between 20k and 100k records, which I display in a DBGrid. I am using a DataSetProvider, which is connected to a…
Bodo
  • 15
  • 5
0
votes
1 answer

In A TPacketDataSet->Data usModified record, How can I determine which fields carry NULL value because they were deliberately changed to NULL?

I copy the TClientDataSet->Delta to TPacketDataSet->Data. Then I am using TPacketDataSet->Data to write cached updates to Faircom Server ISAM database record. When using the Modified Record pair, The second copy of the record marked "usModified"…
Alan Taylor
  • 11
  • 3
0
votes
0 answers

Locate not find on no loPartialKey

I'm using Delphi XE2 and I'm having problems with TClientDataset.Locate method. It will only locate if loPartialKey is passed as param. In other case, it will not find the record, even though the record definitely exists. Here is a code…
lucas
  • 47
  • 6
0
votes
0 answers

Delphi TClientDataset refreshing memory table

I have a memory ClientDataset (provider is not specified) with the connected DBGrid. I need to change some records without DBGrid scrolling: with ClientDataset do begin DisableControls; try // changing some records // and getting back …
Molochnik
  • 704
  • 5
  • 23
0
votes
0 answers

Does Delphi TClientDataSet.IndexFieldNames really remove records from the dataset (make them invisible)?

I execute the following code in Delphi: MyClientDataSet.IndexFieldNames:='FIELD1;FIELD2;FIELD3' And I can see that MyClientDataSet.RecordCount shows reduced number of records while this temporary index is active. If I make the while loop: while…
TomR
  • 2,696
  • 6
  • 34
  • 87
0
votes
0 answers

How to catch a TDBXException when using DBExpress

Using a TClientDataSet and a connection to a remote MySQL server, using DBExpress and C++ Builder XE3. A TDBGrid shows data from a particular table, navigated with a TDBNavigator. When deleting a record in the grid, the deletion is first only…
Totte Karlsson
  • 1,261
  • 1
  • 20
  • 55
0
votes
1 answer

Delphi TClientDataset SQL Server RowVersion

Does anyone have any experience using SQL Server 's RowVersion column with TClientDataset? Specifically, I need to get the RowVersion value back on insert. It seems to get the RowVersion value back on updates but a newly inserted row it does not.
avidgoffer
  • 193
  • 1
  • 2
  • 18
0
votes
0 answers

delphi TClientDataSet utf-8

everybody! I try to load data into oIntermediateStream in way like that: oIntermediateStream : TStringStream; oClient := TClientDataSet.Create(MainOpScr); oClient.LoadFromStream(oIntermediateStream); The problem is I want to see one…
Eugener
  • 1
  • 1
0
votes
2 answers

FMX.TGrid how to allow user to move columns without messing up the data

I made a very simple testproject in Delphi 10.2 using FMX. The setup is simple : TGrid that is binded to a TClientDataSet (done in the designer). button that allows the user to open an XML file This all works fine and the TGrid is populated…
GuidoG
  • 11,359
  • 6
  • 44
  • 79
0
votes
0 answers

Delphi TClientdataset vs Marshmallow ORM populated from REST Performance comparison

I am looking at using a node REST (json) service consumed by a Marshmallow ORM on client side to act as a persistence layer. I was wondering if anyone has experience / views of speed of such a persistence approach compared to straight tclientdataset…
Del
  • 61
  • 1
  • 9
0
votes
1 answer

How to use the Filter functions of TClientdatasets for dates?

I have a TClientDataSet in Delphi 7 and I'd like to apply a filter which I type into a simple TEdit, so it looks like this: CDS.Filter:=Edit1.Text; CDS.Filtered:=True; Now I looked at the Helpfile for filtering records and according to it I should…
Viktor Pagels
  • 271
  • 4
  • 15
1 2 3
…
19 20