i have problem retrieving data with Delphi TClientDataSet Code with ADO: ADOQuery1.SQL.Text:='SELECT * FROM Table1 WITH (NoLock)'; DataSource1.DataSet:=ADOQuery1; DataSource1.DataSet.Open; DataSo...

I have a master TClientDataSet, which is also a detail dataset. This dataset is named MasterDetail1. Another dataset, DetailSet1, is a detailset of the MasterDetail1. The query for DetailSet1 is SE...

I was triggered to ask this question when trying to support this question with an MCVE. I recently started noticing that TClientDataSet quickly runs out of memory. I had an issue in production whe...

Under FireDAC, I have a TFDConnection -> TFDQuery -> TDataSetProvider in a server app and a TClientDataSet in a client app. They are connected through the RemObjects Remoting SDK. (The TClien...

Say that I temporarily want to disable the OnCalcFields event (eg. by setting cdsCalcFields := nil) during a time-consuming operation on a TClientDataSet. How can I tell the TClientDataSet to perfo...

I have a ClientDatSet with a few fkInternalCalc fields. The CDS is not linked to any provider; instead it's filled on the fly. How can I force CDS to recalculate all the "calculable" fields? I can ...

I'm wanting to reverse the order of an index in a TClientDataSet, the following code looks like it should do the trick but does nothing. Is there a nice way to reverse the order of an index? proce...

I´m declaring MidasLib to avoid dll hell caused by Midas.dll in some clients. The code below runs in about 2350ms. If I remove the MidaLib declaration in uses it starts to run in just 45ms!! The ...

I have a TClientDataset with n fields and I have to loop through them to count how many have changed but doing: if (Cds.fields1.Value <> Cds.fields1.OldValue) and (Cds.fields2.Value <>...

My Delphi project has a TAdoQuery accesssing data on an MS Sql Server 2014 server, and TClientDataSet that receives the AdoQuery data via a TDataSetProvider. This is created from a Project Template...

I have a TClientDataSet, which is provided by a TTable’s dataset. The dataset has two fields: postalcode (string, 5) and street (string, 20) At runtime I want to display a third field (string, 20)...

I'm trying to sort a ClientDataSet on a calculated boolean field, but for some reason the data is not sorted. I have a boolean field named Highlight with FieldKind set to fkInternalCalc, and an ind...

Is there a way to refresh only the Detail DataSet without reloading all master dataset? this is what I've tried so far: DM.ClientDataSet2.Refresh; DM.ClientDataSet2.RefreshRecord; I have also ...

I've nearly finished some code to solve the problem in this unanswered q from last year: Refresh Nested DataSet with poFetchDetailsOnDemand Received wisdom is that it's not possible to refresh th...

Hello code enthusiasts! I have a question, which is no doubt due to some inexperience of my Delphi XE2 knowledge. I'll try to explain it here. Introduction: I have an Interbase database with dat...

Is it possible to change the way indexes are used in TClientDataSet to sort records? After reading this question, I thought it would be nice to be able to sort string fields logically in a client d...

Precis: My code is attempting to update non-physical fields in a Delphi XE TClientDataset, (connected to a TSQLQuery with its SQL property set) that were created as result of a runtime Open command...

Is it possible to add an aggregate field over a calculated field? Suppose there is a cds with following fields: ID(autoincrement) Name(string) Price(float) Quantity(integer) Total(integer) - cal...

I'm here again to ask for a help to you. This time I believe that few will respond given the great particularity of the problem which I will relate. I'm starting in the world of DataSnap, and still...

I'm using a TClientDataSet as a local dataset without the provider concept. After working with it a method is called that should generate the corresponding SQL statements using the StatusFilter to ...

What is the reason for getting an 'invalid parameter error' when calling the CreateDataSet method in a TClientDataSet component. What causes this error.

I need to make some aggregates using TClientdataset. In SQL these aggregates can be done with script like this : Select Sum(column1) from table1 where Date_Column < Date_Value Because I need ...

TClientDataset.RefreshRecord no longer generates the table join part of SQL when trying to refresh a record on a ClientDataset connected to a dataset with a joined table in the SQL statement. As a...

I have a TClientDataSet with several records, and I want o load all the records, but load the blob field on Demand, one at a time. I noticed that calling FetchBlobs twice fetches the blob twice an...

Is possible delete all the records from a TClientDataset at once?