Watch, Follow, &
Connect with Us
Public Report
Report From: EDN/Discussion Forums    [ Add a report in this area ]  
Report #:  71065   Status: Reported
ClientDataSet.DataRequest not working
Project:  EDN Build #:  2600
Version:    2 Submitted By:   Lawrence Ong
Report Type:  Basic functionality failure Date Reported:  2/2/2009 11:30:47 AM
Severity:    Serious / Highly visible problem Last Updated: 2/3/2009 4:34:28 AM
Platform:    All versions Internal Tracking #:  
Resolution: Need More Info (Resolution Comments) Resolved in Build: : None
Duplicate of:  None
Voting and Rating
Overall Rating: No Ratings Yet
0.00 out of 5
Total Votes: None
Description
I've built a DataSnap Server using the 3 new DataSnap components(TDSServer, TDSServerClass,TDSTCPServerTransport). In the ServerModule, an object of TClientDataSet and a TDataSetProvider each was instantiated. The DataSetProvider is set to associate with the ClientDataSet. The ClientDataSet is associated with an existing XML file, and loaded into the ClientDataSet was the server starts up. Everything seems to work fine with the server.
On the Client side, I have the following: DBGrid -> DataSource ->ClientDataSet -> {DSProviderConnection,DataSetProvider} -> SQLConnection. So everything seems to work fine here. The dataset are displayed in the DBGrid as expected.

Now, on the Client-side, I added a Button which when clicked, will invoke the ClientDataSet.DataRequest method. When the Button is clicked, the Client-side reported an error:

"... TDBXError with message 'Remote error: Invalid variant operation'.

On the Server-side, the OnDataRequest event handler was properly configured.

Any help or insight will be appreciated.
Steps to Reproduce:
See detail in Full Description.

Attached is the whole projects.
Workarounds
None
Attachment
None
Comments

Tomohiro Takahashi at 2/3/2009 4:34:34 AM -
In your report, Project field, Version field, Area field and Build No field are not filled properly...
Which product are you using, Delphi 2009, 2007 etc...?

Server Response from: ETNACODE01