tclientdataset

Where should the TClientDataset component be located?

Some background: I want to develop a desktop application, with a SQL database as storage. There is only one user at one time connected to the database. To make maintainance easier, I would like to seperate GUI from Busniss Logic. Thus, I thought using a DataModule (where the BL is implemented), for each Dialog. My question: Where is th...

sending files with TClientDataSets

Hi all How do i send files using TClientDataSet? i am using Delphi2010 thanks vladimir. My appologies for the confusion, my intention is to send/tranfer pdf files from one TCLientDataSet to Onother... we are using MIDAS... thanks ...

DataSetProvider - DataSet to ClientDataSet

EDIT: It seems as if the DataSetProvider doesn't have the functionality I need for this project, so I'll be implementing a custom class for loading the data into the ClientDataSet. I am trying to take data from a TMSQuery which is connected to my DB and populate a ClientDataSet with some of that data using a DataSetProvider. My problem...

Handling update errors in multiple records in the TClientDataset's ReconcileError method

I'm trying to use the ReconcileError event to allow the user to correct the data after an update error which occurred in a specific record among others. Example: I have a dataset with one field and 3 records, this field have a unique constraint on the database, then I change one value to conflict when it reaches the database, then I ca...

Trapping errors in TClientDataSet.CommandText

I have a TClientDataSet connected to a TDataSetProvider, which in turn is connected to a TAdsQuery. I set the SQL command and then open the ClientDataset something like this: try CDS.CommandText := 'SELECT * FROM tablename WHERE fieldname = 1'; CDS.Open except // trap exception here - this never gets executed! end; If the SQL st...

Delphi Clientdataset Lookup/Aggregate

Hi, I need a little help with ClientDatasets in Delphi. What I want to achieve is a grid showing customers, where one of the columns shows the number of orders for each customer. I put a ClientDataset on a form and load Customers.xml from Delphi demo-data. Another ClienDataset is loaded with orders.xml. Relatively simple, I can define ...

tclientdataset's delta property

Hi, do any one know the how to clear the data in the delta of the TclientDataSet explicitly? without using applyupdates thanks in advance, Vijay. ...

to track the modified rows and manually update from the TClientDataSet's Delta

hi, Is there any way to manually track the changes done to a clientdataset's delta and update the changes manually on to then db. i have dynamically created a clientdataset and with out a provider i am able to load it with a tquery, now user will do some insert update and delete operations on the data available in the cds, and at final...

Display message on query completion

I am querying a firebird database with a relatively complicated query that takes a while to execute and thought that it would be helpful if the user could get some form of feedback regarding the progress of the query. I intend to display a suitable 'please wait' message on a status bar when the query is started and clear the status bar w...

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 data using the TClientDataSet.Data property but I still would need to clear the link and ...

Delphi - TClientDataSet: Second call to applyupdates() does not apply the updates

Again I have a problem with the TClientDataSet. I guess it's something really simple but I struggle on it for a while now. Here's some code what shows what I want to do: procedure TForm1.Button1Click(Sender: TObject); begin ClientDataSet1.Insert; ClientDataSet1.FieldByName('anruf_von').AsDateTime := time; ClientDataSet1.Post; C...

How can I 'freeze' a dataset in a Datasnap server?

For a dataset which takes a very long time to open (it is a stored procedure), I would like to implement some kind of caching on the Datasnap server. So if this dataset is loaded the first time and transferred to the client (TClientDataSet), it should not be closed and reopened for the following requests unless the server restarts or a ...

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 accessible but now contains no valid information. This makes things a bit difficult since whe...

Using Delphi7 TClientDataSet: is it possible to have it save it's XML contents in an indented format

I am using Delphi7 ClientDataSet to read and write xml files for some of my data. Howerver, when I want to browse this outside the program (double clicking the xml in Windows Explorer) I get the 'An invalid character was found in text content. Error processing resource' - even although the data reads and writes fine from within Delphi. ...

Reading and writing into the XML file

Hi, I need to work on XML files using Delphi. I want to present the xml data in a DBGrid to the user and save the changes done by user in the XML file. For example in the below xml (which was presented to the user), if user changed City of ABC under client and added a new customer with NickName as "AAA" those changes should be reflec...