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

Delphi: ResolveToDataset issue

I am using a TClientDataset with the following options for the provider: ResolveToDataSet = True Options = [poPropogateChanges, poUseQuoteChar] UpdateMode = upWhereKeyOnly AfterUpdateRecord = DataSetProvider1AfterUpdateRecord The provider is…
Pascal D
  • 258
  • 2
  • 9
3
votes
0 answers

Unable to update the value in database using TDBCheckbox

I am using Delphi XE6 IDE and sql server database.I have placed a TDBCheckbox component on a TPanel. The datasource to TDBCheckbox is set at runtime. The datafield value is assigned to the component. In clientdataset this field is added. When the…
Tanavi
  • 105
  • 6
3
votes
2 answers

Run-time Equivalent to Assign Local Data... for TClientDataSet and TSQLQuery

The TSQLQuery class is unidirectional, so for it to be used as a source for a data-bound TDBGrid, a TClientDataSet needs to be linked between the TSQLQuery and the TDataSource that the TDBGrid is bound to. I can connect the TSQLConnection and make…
SiBrit
  • 1,460
  • 12
  • 39
3
votes
3 answers

Quick method to determine ClientDataSet has changes

Using Delphi Berlin. I have a nested Clientdataset in a datamodule ("dmCore"). There are about 5000 records in the detail table for any given master item (testing with 2 master records). I have a "Post" button connected to an action in…
edbored
  • 274
  • 4
  • 11
3
votes
1 answer

Insufficient memory when opening TClientDataSet with a REPLACE in the underlying query

My Delphi code opens a TFDQuery (FireDAC), then opens the TClientDataSet connected to it via a TDataSetProvider: ClientDataSetData.Close; with QueryData do begin Close; SQL.Clear; SQL.Add(ASelectSQL); Open; end; …
Jan Doggen
  • 8,799
  • 13
  • 70
  • 144
3
votes
1 answer

How can I avoid losing precision with ftFmtBcd?

The documentation says: TFMTBCDField encapsulates the fundamental behavior common to binary-coded decimal (BCD) fields. BCD values provide greater precision and accuracy than floating-point numbers. BCD fields are often used for storing and…
ventiseis
  • 3,029
  • 11
  • 32
  • 49
3
votes
1 answer

Read-only TClientDataSet Refresh fails with key violation

I get a key violation on the Refresh in the below code. EmployeeContracts is a TClientDataSet coupled through a TDataSetProvider to a TFDQuery with SQL: select ec.* from tt_emp e, tt_emp_contract ec where (coalesce(e.tt_nonactive,0)=0) and…
Jan Doggen
  • 8,799
  • 13
  • 70
  • 144
3
votes
1 answer

Filtering A TClientDataSet On A NestedDataSet Field

I have a small application I am working on that is almost finished thanks to those who have assisted me here. I have one last task however. I need to be able to Filter a TClientDataSet on a NestedDataSet field. ClientDataset1 Field0: Name (Lake…
Bill
3
votes
1 answer

How to read a .cds database (TClientDataSet) with .Net

I have an old databasefile from an application written in Delphi. My task is to extract the data, and move it to an SQL-Database. I know it is in .cds format which uses the TClientDataSet-Class from Delphi. The problem is: I have no Delphi, no…
crono
  • 3,603
  • 3
  • 27
  • 24
3
votes
0 answers

Delphi - ClientDataSet SQL calculated field causing "Invalid field type" error at runtime

I have a ClientDataSet which loads its data from a table in a SQLite database using a TFDQuery. The SQL query selects fields from a table of bank accounts: the AccountID, Name, StartBalance and CurrentBalance. CurrentBalance is a calculated…
Scott Hallauer
  • 389
  • 2
  • 8
  • 16
3
votes
2 answers

Restructure a TClientdataset

Can a TClientDataSet XML file be restructured without losing data? Are there any demo applications or source code that shows how to do such a restructure?
Bill
3
votes
1 answer

Delphi ClientDataSet - Delete Operation - Why is it so slow?

I'm using TClientDataSet in an application for managing a load of data imported from multiple CSV files. This can be a million or more entries in total. I want to be able to delete all the dataset entries associated with a particular CSV file but…
Phil B
  • 387
  • 5
  • 15
3
votes
3 answers

Object Pascal: TClientDataset Deletions

I'm creating an in-memory dataset using a TClientDataset to use as a receive buffer. Adding data is great, but once I go to process it I want to be able to remove the row from the dataset. Calling delete works - sort of - the row/index is still…
Diego
  • 31
  • 2
3
votes
1 answer

How to find the "foreign key" field name on a nested TClientDataSet?

Given a nested TClientDataSet, how could I find the link field name on the detail TClientDataSet? I'm copying data from one TClientDataSet to another (record by record) and I would like to automatically ignore the link field. I could also copy the…
Valdir
  • 31
  • 1
  • 4
3
votes
1 answer

unknown isc error 0 on Delphi XE TClientDataSet.Next

I have a DBXpress data structure connected to a Firebird database. I'm adding data pagination over a ClientDataSet, DataSetProvider and SQLQuery combination. It was working well but recently it started to raise unknown isc error 0 exception after…
Jean Jung
  • 1,200
  • 12
  • 29
1 2 3
…
19 20