BorlandTalk.com

Frank Demuynck · Guest

Hi,

I created a Soapdatamodule (WebService) with an ADOQuery and DatasetProvider
on it. The option poAllowCommandText of the DatasetProvider is set to true.
The client application uses a Soapconnection and a ClientDataset. The
RemoteServer is set to the Soapconnection and the Providername is set to the
Datasetprovider of the soapserver.
On the client side I want to Execute dynamically created SQL statement with
params. The following code (client side) with without params is working
fine.

clds_Table := TClientDataSet.Create(Self);
clds_Table.RemoteServer := soapc_;
clds_Table.ProviderName := 'dsp_Table';
clds_Table.CommandText := 'SELECT tes_id, tes_description FROM test';
clds_Table.Open;

The following code with params isn't working. The result of the select
statement gives me always an empty result back.

clds_Table := TClientDataSet.Create(Self);
clds_Table.RemoteServer := soapc_;
clds_Table.ProviderName := 'dsp_Table';
clds_Table.CommandText := 'SELECT tes_id, tes_description FROM test WHERE
tes_description = :tes_description';
clds_Table.Params.ParamByName('tes_description').DataType := ftString;
clds_Table.Params.ParamByName('tes_description').ParamType := ptInput;
clds_Table.Params.ParamByName('tes_description').Value := 'Frank'
clds_Table.Open;

With the web debugger I see that the SQL statement en param are passed to
the webservice (Incapuslated in a SOAP-XML message).
On the server I see that I have received the SQL statement and the param BUT
NO PARAM VALUE. (It look like the PARM VALUE = NULL)

Is there anyone that can help me?

(I'm using Delphi 6 with updatepack 2)

Frank