Stack Overflow
Stack Overflow

Questions tagged [tdatasetprovider]

TDataSetProvider provides data from a dataset and resolves updates to that dataset or its database server

Use TDataSetProvider to provide data from a dataset to a client dataset or XML broker and to resolve updates from that client dataset or XML broker back to the dataset or to its underlying database server

15 questions
12
votes
4 answers

Faster way to move data from a dataset structure to another (in TDatasetProvider)

I have an custom TDatasetProvider that allows to create new fields to whatever data it provides. So, let's say you got the folowing fields on the original dataset: CustomerId Name Age And you need to select it on DBGrid using showing an Bitmap.…
Fabricio Araujo
  • 3,810
  • 3
  • 28
  • 43
2
votes
0 answers

Provider not exported in Delphi SOAP Server + Client

I'm using Delphi XE7 + Employee Interbase DB. I'm tryin to build a SOAP server with Datasnap. I have 3 SOAP Server Data Modules in one server, each one with a table: Customer, Employee, Country, each one made the same way (File, new, other, SOAP…
Giorgio Forti
  • 131
  • 2
  • 14
1
vote
0 answers

Has anyone converted IBX (Interbase Express) TClientDataSet -> TDatasetProvider -> TIBQuery to FireDAC?

I have been investigating what might need to be done to convert my Delphi 10.3.3 app from using TDataSource -> TClientDataSet -> TDataSetProvider -> TIBQuery to using FireDAC. From all I read it is not a good idea to simply replace TIBQuery with…
STWizard
  • 31
  • 4
1
vote
1 answer

Delphi DataSetProvider BeforeUpdateRecord WideMemoField OldValue missing

Writing a little change log for our DB application, and I'm facing the following problem: in the BeforeUpdateRecord event of my DataSetProvider, the OldValue of any (modified) WideMemo field is missing. It is present in the ClientDataSet before I…
Nicolas Bourgogne
  • 53
  • 6
1
vote
1 answer

Delphi Datasnap: How to manually build dataset when using a TDatasetProvider

I would like to manually build the dataset used by a TDatasetProvider to return the data to the client. The SQL request is taking a long time to run as a query and I am trying to speed up things by splitting the logic in code and using a kbmMemtable…
Pascal D
  • 258
  • 2
  • 9
1
vote
1 answer

TClientDataSet error "Trying to modify read-only field"

I use the next chain TADOQuerry->TDataSetProvider->TClientDataSet to got data for Items and ItemType table and work with it offline. Item TADOQuery's SQL property contains a simple query select i.ID,i.Name, i.TypeID, i.Qnty, i.Price, it.TypeName…
DreadAngel
  • 772
  • 11
  • 30
0
votes
1 answer

What properties of TClientDataSet / TDataSetProvider determine, that TIBDataSet should generate SQL automatically and should neglect SQL?

I am programming in Delphi 6 (but I guess the situation is the same with Delphi 11.1 22 years later as well) and I am using the standard chain of components: TIBDataSet (from Delphi IBX - Interbase-Express) with custom (written by myself)…
TomR
  • 2,696
  • 6
  • 34
  • 87
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

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

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

Exception caused by TDataSetProvider poUseQuoteChar and lowercase table names does not surface

The default TDataSetProvider.Options.poUseQuoteChar is true. I was (again) bitten by this when my SQL statement used a lower case table name and my TClientDataSet.ApplyUpdates(0) did not do any updates without raising an exception. In…
Jan Doggen
  • 8,799
  • 13
  • 70
  • 144
0
votes
1 answer

Assign, memcpy or other method required for TClientDataset or TDataSetProvider (dbexpress)

I'm usign the dbExpress components within the Embarcadero C++Builder XE environment. I have a relatively large table with something between 20k and 100k records, which I display in a DBGrid. I am using a DataSetProvider, which is connected to a…
Bodo
  • 15
  • 5
0
votes
2 answers

The last table to update on the applyupdates

I have a CRUD that contains 5 tables and I need to do some processing on the server side alter the last table has been updated, the events on the datasetprovider happens after each individual table. Like, I have 3 tables, person, car, personcar. I…
Lucas Steffen
  • 1,244
  • 2
  • 10
  • 22
0
votes
1 answer

How to apply updates of Delphi TClientDataset in specified order?

I need apply updates (ClientDataSet.ApplyUpdates) to be applied in specified order: - Delete as first - Modify as second - Insert as third They are applied in order in which they were done.
Vlada
  • 559
  • 2
  • 11
  • 27
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…
Matt Allwood
  • 1,448
  • 12
  • 25