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

Alternate color of groups of rows on a DBGrid

I want to alternate the colours of my grid by groups. My first try is doing this adding a GroupNumber to the ClientDataset (using the DENSE_RANK() function of SQL Server). select dense_rank() over (order by Viatge) as GroupNumber, …
Marc Guillot
  • 6,090
  • 1
  • 15
  • 42
0
votes
1 answer

Revisited: TClientDataset "Missing data provider or data packet"

With a dynamically created TFDQuery,TClientDataSet, and TDataSetProvider I bump into the "Missing data provider or data packet" with this code: procedure ResetSavedPasswords(ADataModuleDataBaseAdmin : TDataModuleDataBaseAdmin); var lQuery :…
Jan Doggen
  • 8,799
  • 13
  • 70
  • 144
0
votes
0 answers

DBGridEh Field LookupParams property does not post data to database

I am using the DBGridEh (ascendant of DBGrid) Field LookupParams property and surprise that this is not posting the data to database. It is shown in the grid but not posting. I am really not sure if this is the behavior of the LookupParams property…
Juke
  • 135
  • 2
  • 9
0
votes
2 answers

Verifying if data exists in my Table using TClientDataSet in Delphi

I am trying to verify if [specific] data exists in my table using TClientDataSet. I Is there a way that I can do this in TClientDataSet? I am avoiding to use query for some reason here.
Juke
  • 135
  • 2
  • 9
0
votes
2 answers

Inserting after the last record (bottom) shown in DBGrid

What should be the code for inserting after the last record using the ClientDataSet? I tried the following: cdsSomething.Last; cdsSomething.Insert: But it appears it replaces the last record instead. I am sure there must be a quick code for this.
Juke
  • 135
  • 2
  • 9
0
votes
4 answers

How to use TClientDataSet to locate containing string

I'm using Delphi 2007. I know I can use the .locate method of a TClientDataSet to locate a record, like this: myClient.locate('name','John',[loPartialKey,loCaseInsensitive]); But let's say I want to locate any record with 'John' containing on its…
delphirules
  • 6,443
  • 17
  • 59
  • 108
0
votes
1 answer

Does TClientDataSet.ApplyUpdates(0) require to execute CheckBrowseMode/Post before?

I have TIBQuery-TDataSetProvider-TClientDataSet chain in Delphi 2009 (Firebird 3.0) and I execute MyClientDataSet.ApplyUpdates(0). Am I required to call CheckBrowseMode or Post on this CDS before calling ApplyUpdates(0). I am almost sure that I am…
TomR
  • 2,696
  • 6
  • 34
  • 87
0
votes
1 answer

Ignore InProcServer32 registry entry for Midas.dll

Recently we installed our program which uses Midas.dll for a new customer. Unfortunately this customer's laptop has an invalid registry entry for the Midas.dll location…
Uli Gerhardt
  • 13,748
  • 1
  • 45
  • 83
0
votes
1 answer

How to catch SQL generated by Delphi TDataSetProvider?

I have TClientDataSet, TDataSetProvider and TIBQuery chain and there is 'unprepared statement' error while executing CDS.Post, apparently, the update satement generated by TDataSetProvider is wrong. How to catch this update SQL? SQL Montioring is…
TomR
  • 2,696
  • 6
  • 34
  • 87
0
votes
1 answer

Create relationship between two query delphi

I have two table Country and City (country_id is PK in Country table and country_id is FK in City table). Which component use to create relation between two query for fast report. Which structure should be: Query 2. Client Data set .... 3. ? 4.?…
Pointer
  • 2,123
  • 3
  • 32
  • 59
0
votes
1 answer

What to do in Delphi TDataSetProvider.OnUpdateError if I just want to stop execution and report error?

I have Delphi application with TIBQUery-TDataSetProvider-TClientDataSet that more or less emulates CachedUpdates pattern (that was in previouse BDE components). Currently there is no error handling code, so, there is no error messages at all. I just…
TomR
  • 2,696
  • 6
  • 34
  • 87
0
votes
0 answers

Special case: wrong order of updates for fly-away

How can I track down the location of the "Special case: wrong order of updates for fly-away!" error? This error message is defined in Datasnap.DSIntf as const ... ERRCODE_FLYAWAY_WRONGORDER = 13; { Special case: wrong order of updates for…
Jan Doggen
  • 8,799
  • 13
  • 70
  • 144
0
votes
1 answer

Delphi with Intraweb 8 - TIWDBLookupComboBox - master detail

I'm building an application using IW 8 and Delphi 7. Application is 3-tier. 1) on the app's datamodule I have several TClientDatasets and TDataSources associated(set on master-detail relationship) 2) on an IW form I have several…
RBA
  • 12,337
  • 16
  • 79
  • 126
0
votes
0 answers

many-to-many relationship with TClientDataSet

I have two database tables: students table classes table There is a many-to-many relationship between the two tables: a student can go to several classes and a class can have several students. I would like to implement the tables in Delphi with…
user3384674
  • 759
  • 8
  • 28
0
votes
1 answer

How to save and read records in a Delphi tClientDataset

Good day I am a Delphi newb. I am trying to programmatically save a record to a tClientDataset and then read the record from the dataset. I think I seem to have managed to successfully save the record in the dataset, because after I appended data to…
Johan van der Merwe
  • 13
  • 5
1 2 3
…
19 20