?
Solved

How to post clientdataset's delta via difference provider?

Posted on 2003-03-05
5
Medium Priority
?
1,088 Views
Last Modified: 2008-02-07
I want to get data from one provider while post the changed with another. How to do that?

Thanks advance.
0
Comment
Question by:qlwuu
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 6

Expert Comment

by:swift99
ID: 8074578
The Delta can be assigned to a variant, and then that variant assigned to the Data property of another clientdataset (Call it DeltaDataset).

At that point in time you can traverse the DeltaDataset and perform the operations from each row based on its status on the detination dataset.

I think that this is what you areasking for.  If not, please clarify your problem somewhat.
0
 

Author Comment

by:qlwuu
ID: 8076466
Thanks. :-)

I want to get and post data using "common" provider.In server site there are two provider with two adoDataSet connected.Client site get data with such interace:

function GetData(QueryID: String; Params: OleVariant): OleVariant;

Server lookup sql script corresponding the QueryID and set the commandtext of "Select" adoDataSet and return data like this:
 
SelectDataSet.Close;
SelectDataSet.CommandText := GetSQLScript(QueryID);
SelectDataSet.Open;
Result := SelectProvider.Data;

The code work fine.So let's go on, below is the code post delta(ResolveToDataSet=False):

UpdateDataSet.Close;
UpdateDataSet.CommandText := GetSQLScript(QueryID);

//here raise the exception
//"missing data provider or data packet"
UpdateProvider.ApplyUpdates(vDelta, 0, iErrCount);

I also try to :
evaluate tablename in provider's OnGetTableName event, nothing change...
set ResolveToDataSet=True and open UpdateDataSet before post data, it dosen't work...





0
 

Expert Comment

by:CleanupPing
ID: 9316930
qlwuu:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.
0
 
LVL 5

Expert Comment

by:snehanshu
ID: 10037278
Hi!
No comment has been added lately and this question is therefore classified abandoned.

If asker wishes to close the question, then refer to
http://www.experts-exchange.com/help/closing.jsp

Otherwise, I will leave a recommendation in the Cleanup topic area that this question is:

PAQ'd and pts refunded

Please leave any comments here within the next seven days. It is assumed that any participant not responding to this request is no longer interested in its final disposition.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

...Snehanshu
EE Cleanup Volunteer
0
 

Accepted Solution

by:
modulo earned 0 total points
ID: 10113801
PAQed, with points refunded (50)

modulo
Community Support Moderator
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever had your Delphi form/application just hanging while waiting for data to load? This is the article to read if you want to learn some things about adding threads for data loading in the background. First, I'll setup a general applica…
Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question