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

ClientDataSet only partially transferring data from TADOQuery

I have two databases and I need to ensure that all records in one database have a matching record in the other. I will call these DB-SQL and DB-Legacy This would be easy enough if both had an SQL interface, but unfortunately I only have this type of…
0
votes
2 answers

Refreshing values in a TClientDataset after update

I got a TClientDataset that contains data from several tables. When I apply updates on this dataset it might get out of sync. I'll give you one example: In the table to update i got an id called "Client_id". The clientdataset also contains a value…
Øystein
  • 1,163
  • 1
  • 12
  • 23
0
votes
1 answer

Missing Field Errors In TClientDataSet when external dll called from Delphi 7

I have a DLL created in Delphi XE2 that is using DB Express and TClientDataSet to display the results of a join in a DB Grid. There is a simple function to launch/show the form that is exported for use in other applications. The query is executed,…
ConBran
  • 369
  • 2
  • 15
0
votes
2 answers

Can Delphi ClientDataSets be used in iOS Applications?

I read the Components Not Used in iOS Apps post in the Embarcadero DocWiki and was unable to tell if ClientDataSets and DataSources can be used in iOS applications. Can anyone confim or deny whether these components will work in iOS applications.
0
votes
1 answer

Export TStringGrid to doc, xls and pdf

I have a kind of report that I`ve created with the help of TZColorStringGrid (it is a descendant of the Delphi's TStringGrid) and I want to be able to export to doc, xls, pdf and also to be able to print this report. So I am thinking for the last…
0
votes
1 answer

DELPHI: Put calculated value into a master detail where details are in a grid

I have created a master-detail relation using ClientDataSets (Service & Addons). The Services are displayed in a DBLookupComboBox (cboServices) and once a service is selected the Addons are displayed in DBGrid (grdMain). The Addons has a checkbox…
BrianKE
  • 4,035
  • 13
  • 65
  • 115
-1
votes
3 answers

DELPHI - help need with a ClientDataSet

I have a ClientDataSet with the following data IDX EVENT BRANCH_ID BRANCH 1 E1 7 B7 2 E2 5 B5 3 E3 7 B7 4 E4 1 B1 5 E5 2 B2 6 E6 7 B7 7 E7 1 B1 I need to transform this data…
Charles Faiga
  • 11,665
  • 25
  • 102
  • 139
-1
votes
1 answer

How to dump Delphi OleVariant content to the file?

I have multi-tiered application that use OleVariant variables to send and receive data accross the line using custom communication framework. Usually the content of this OleVariant variable comes from TClientDataSet.Data (which, of course, is of…
TomR
  • 2,696
  • 6
  • 34
  • 87
-1
votes
1 answer

Copying Clientdataset records to Database table

What I'm trying to achieve to to insert/copy records from a tClientDataSet to a database table(Database is Sybase ASA). I also have a form with a cxgrid on it which I can see the records from the cds, so I know there are records in it. At the click…
Sharpie
  • 373
  • 2
  • 15
  • 34
-1
votes
1 answer

ClientDataSet to Database Table

I have a ClientDataSet which contains multiple fields. My question is, does anyone know of a way to copy the fields from the ClientDataSet to a database table? ClientDataSet is connected to a cxgrid, which displays all fields. All the fields with…
Sharpie
  • 373
  • 2
  • 15
  • 34
-1
votes
2 answers

Whats wrong with TStatusBar?

I have two forms called fmMain and fmEmpl. Both have each TStatusBar called sbMain and sbEmpl. I have a TDataModule called dmData to store the database components. I need to update the sbEmpl panels so it can displays actual values from the database…
Jessie M
  • 498
  • 1
  • 9
  • 23
-2
votes
2 answers

Can TStringField be created with dynamic Size?

I have Insufficient memory error with TClientDataset with TStringField fields. I need to use length of strings from 0 to 8000 - but don't know what length will be until I fill the TClientDataset. So, can TStringField be created with dynamic…
Dmitry
  • 14,306
  • 23
  • 105
  • 189
-3
votes
2 answers

How to insert blank data in tclientdataset?

This is a simple database. CREATE TABLE A(FIELD1 INT PRIMARY KEY, FIELD2 VARCHAR(10)); INSERT INTO A (FIELD1, FIELD2) VALUES (1, 'A'); tbl1 is opened and it contains the data in table A. I want to insert blank data, 6 records with blank data,…
-3
votes
1 answer

Accessing TClientDataSet in a DLL

unit dll_dmunit; interface uses System.SysUtils, System.Classes, Data.DB, Datasnap.DBClient, Vcl.Dialogs,Vcl.DBGrids; type TStudentModule = class(TDataModule) StudentSet: TClientDataSet; StudentSource: TDataSource; StudentSetNAME:…
1 2 3
19
20