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
1 answer

In Delphi, use SaveToStream to save ClientDataSets plus other material to a file?

I would like to use SaveToStream to save a ClientDataSet ALONG WITH OTHER MATERIAL. Here is a short sample: filename := ChangeFileExt(Application.ExeName, '.dat'); FS := TFileStream.Create(filename,…
Kevin Killion
  • 123
  • 2
  • 9
0
votes
1 answer

FireMonkey TClientDataSet Setting a Filter causes "Error Creating cfString" in OSX works fine in Windows

I am having a problem setting a filter on a TClientDataSet when running on Mac OSX. It works fine on Windows. I get the error: Error Creating cfString This is really easy for me to duplicate: Create a new project. Go to the Project -> Deployment…
jaridmo
  • 26
  • 2
0
votes
1 answer

Copy and return FDDataSet from function in Delphi

I have function that should return FDDataset from FDQuery, but I can't copy dataset to Result, or to another FDDataset. This is my main Code: procedure TForm1.Button1Click(Sender: TObject); var: Fix: TFDDataSet; begin Fix.CreateDataSet; …
Gem
  • 516
  • 1
  • 8
  • 19
0
votes
0 answers

Builder C++ DBExpress clientdataset : insufficient memory for this operation

i have a problem when i try to fill my DBGrid from datasource: my code void MyClass::initializeGridView() { String sqlFilter = SrcQryStringList->Text + QueryStringList->Text; FilterSQLQuery->Close(); FilterSQLQuery->SQL->Clear(); …
user4054093
0
votes
2 answers

How to refresh modified records to CloneSource before ApplyUpdates?

So I have a ClientDataset (cdsM1) with a Nested Detail (cdsD1). I need to print it before do ApplyUpdates, so I clone them (cdsMclone and cdsDclone) and filter the master clone just to show only one master record. After printing, I need to update…
EMBarbosa
  • 1,473
  • 1
  • 22
  • 76
0
votes
1 answer

Delphi clientdataset does not navigate when disablecontrols is called

I have a datamodule with 3 clientdatasets, all coupled through datasetproviders to a adoquery. PacketRecords is set to -1 on each clientdataset. cds2 has a masterdetail with cds1 cds3 has a masterdetail with cds2 So on my form, when I move to…
GuidoG
  • 11,359
  • 6
  • 44
  • 79
0
votes
1 answer

Error loading image from clientdataset using datasnap [Delphi XE7, firemonkey mobile]

I am using Delphi XE7, Firemonkey Mobile. Tried both on W32 as well as my Nexus4 (Android 4.4.4). Problem: when loading an image from the clientdataset I get the following errors 1. Remote error: [FireDAC]{Phys][fB]-306. Command text must not be…
Jro
  • 135
  • 9
0
votes
1 answer

Cannot assign data to client dataset

I'm using TClientDataSet assigned with local data in my Delphi application to compare data between 2 tables located in 2 different databases. Things I'm using: SpPlansQuery: TADOQuery – original data query PPUQuery: TADOQuery – changed data query…
Danatela
  • 349
  • 8
  • 28
0
votes
1 answer

How can I use Unicode (or just Cyrillic) chars on TStringField.FieldName property on Delphi?

How can I use Unicode (or just Cyrillic) chars on TStringField.FieldName property of TClientDataSet on Delphi? I've tried this and it doesn't work on the last line: aStringField := TStringField.Create(aClientDataSet); aStringField.FieldName :=…
Dmitry
  • 14,306
  • 23
  • 105
  • 189
0
votes
1 answer

How to delete the record from cds file after performing delete operation on TClietDataSet

I have a TClientDataset and a file with .cds extension. I am loading the TClientDatSet by calling LoadFromFile('file_name.cds') then perform deletion operation on it. Then I save the file by calling SaveToFile method. On loading the TClientDataSet…
Akash_Kumar
  • 73
  • 7
0
votes
2 answers

ClientDataSet TBCDField rounding

I'm using Delphi 5 + BDE + Oracle. I have the following function: class function TClientDataSetFactory.GetClientDataSet( const qryGen: TDataSet): TClientDataSet; var dspDados: TDataSetProvider; begin Result := nil; …
Passella
  • 640
  • 1
  • 8
  • 23
0
votes
0 answers

Type mismatch WideMemo and LargeInt Delphi clientdataset

I'm trying to create an ios app with Delphi xe4 and sqlite. Reopening ClienDataSet after loading some data I have the message: Type mismatch for field 'ct_id', expecting: WideMemo actual:LargeInt. Database: SQLITE: .... 'CREATE TABLE Contacts…
user3160470
  • 1
  • 2
0
votes
1 answer

Mystery Parametric SQL Query with joins + TClientDataSet blank fields

Some times even obvious things seem to go wrong. There's a lot of obvious and a lot that can go definitely wrong when dealing with SQL components and even more when they are just a ring of a whole SQLQuery => Provider => ClientDataSet => DataSource…
Dario Fumagalli
  • 1,064
  • 1
  • 16
  • 23
0
votes
0 answers

Clone clientdataset params

I clone master dataset that's have parameters list date1 and date2 to limits the records fetched from the db cds_CVentes.CloneCursor(DMT.cds_Ventes, True); i have Form1 DB-Aware attached to the master ClientDataSet at run time i create form1…
S.FATEH
  • 451
  • 8
  • 16
0
votes
0 answers

How to add field to a cloned TClientDataset

I have ClientDataSet1 > DataSetProvider1 > SqlDataSet1> sql = select * from customer i add all fields at design time than i copy the ClientDataSet1 rename it to ClientDataSet2 On DataModule create event i clone the…
S.FATEH
  • 451
  • 8
  • 16
1 2 3
…
19 20