Is it possible to put the results from more than one query on more than one table into a TClientDataset? Just something like SELECT * from t1; SELECT * from t2; SELECT * from t3; I can't seem to figure out a way to get a data provider (SetProvider) to pull in results from more than one table at a time. ...
I want to migrate from Embarcadero Delphi to Visual Studio, but without a TClientDataset class it is very difficult. This class represents an in-memory dataset. I can't find any class like TClientDataset. Can anyone help me find something like this please? ...
Hi I use nested database stuctures with TClientDataSets. I'm new to programming so my lingo is ten-to-one wrong. My problem is as follows: I defined my database stucture and all the fields of the nested stuctures and then I called the CreatDataSet method of the master clientDataSet and it worked. I then wanted to add another data fiel...
I know that you cannot fully describe the XML that the TClientDataSet with an XSD schema, as the ROW elements have attributes that have names that vary with the contents. However, the METADATA section of such an XML should be. So: is there anyone having a (partial) XSD that describes the METADATA portion of the XML that can be saved wi...
What is the reason for getting an 'invalid parameter error' when calling the CreateDataSet method in a TClientDataSet component. What causes this error. Kind Regards Riaan de Villiers ...
Is it possible to create and use a TClientDataSet inside an Object at runtime? I like to make several changes in my Table and have those all Applied at the same time in cache like way, and TClientDataSet lets me do that. Know when I want to do this I have to build a TForm. Is it Possible? UPDATE Can it be used, and How, without TData...
Hi 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 into IDX EVENT BRANCH_ID BRANCH 1 E1 7 B7 2 E2 5 B5 4 E4 1 B1 5 E5 2 B2 The only fields of...
Hi I have a TClientDataset that is managed in Thread 1. In a different thread I have a cloned Image of the TClientDataset. Will I run into threading problems? Edit The cloned image is used in a read only mode. ...
I have code like below in a project I'm working. procedure TForm.EditBtnClick(Sender:TObject); begin // Mark is form variable. It's private Mark = cdsMain.GetBookmark; // blabalbal . . . end; procedure TForm.OkBtnClick(Sender:TObject); var mistakes: Integer; begin //Validation stuff and transaction control //remo...
I have one TClientDataSet with several Fields and I'm getting this exception, I'm sure that I forgot to set one field value, but the question is, which Field? Is there some way to find out quickly which field is raising this exception? EDIT I solved the problem, I was connecting the TClientDataSet to the wrong provider, which had a re...
In the AfterPost event handler for a ClientDataSet, I need the information if the ApplyUpdates function for the current record will do an update or an insert. The AfterPost event will be executed for new and updated records, and I do not want to declare a new Flag variable to indicate if a 'update' or ' insert' operation is in progress....
So I'm having this code that processes what the client sends on a pattern. If he sends 'getBENUds', the server sends the DataSet for this table back using the SaveToString method. Then, this is sent to the client. (I'm using Synapse). procedure TTCPSocketThrd.Execute; var s: String; strm: TMemoryStream; ADO_CON: TADOConnection;...
Hi! From the client I am sending a string to the server what he should send me back. This time its a stream created by a ClientDataSet. Unfortunately receiving (or sending??) does not work at the moment. Note: I am using Synapse with blocking sockets. The server is multithreaded. The Server: procedure TTCPSocketThrd.Execute; ...
In my application I use TADOQuery with select (MSSQL) and linked with it TClientDataSet. I have to insert about million records and ApplyUpdates. So what I see in the SQL Server Profiler? I see that for each inserted row we have 3 queries: sp_prepare of insert script, sp_execute it with some values and sp_unprepare. I want just to prep...
Hi I would like to know if it is possible to nest a dataset within a dataset and then nest this data set with in another dataset. Therfore 3 levels of nesting. Currently I only manage to nest one dataset with in the other. When attemting to nest the third level the database manages to run successfully the first time I compile my program...
I'm trying to write a component that inherits from TClientDataset. On the create of the component in design time I want to instantiate a list of common fields that are used within my framework. The code below will execute without errors and the field will appear at run time but not design time. Can anyone help me? I'm sure its something ...
I have written an application that allows a user to define a query, run it using a TADOQuery component, and save the report to their PC as an XML document (SaveAsFile passing in pfXML as the Format parameter) for offline viewing. This works fine. What I now need to do is concatenate the results. What I mean by this is that I need to get...
My question is very simple. I have a TClientDataSet that is linked to a TADOQuery via a TDataSetProvider. I can put data into the TClientDataSet from the TADOQuery, but how do I get data from the TClientDataSet back into the TADOQuery? Data is automatically transferred from the TADOQuery to the TClientDataSet when I run a query and then...
Hello, I am getting this error while resolving delete operation from ClientDatset to TAdoDataset (which bound to access table). I am using Delphi 2010. My DatasetProvider between TClientDataset and TAdoDataset : object dspTarifeler: TDataSetProvider DataSet = DM.qryTarifeler ResolveToDataSet = True Options = [poPropogateChan...
I observed something last week that I did not expect, and will describe below. I am curious as to why this happens. Is it something internal to the TDataSet class, an artifact of the TDBGrid, or something else? The order of the fields in an open ClientDataSet changed. Specifically, I created a ClientDataSet in code by calling CreateData...