Soapdatamodule Parameter problem
- From: "Frank Demuynck" <frank.demuynck@xxxxxxxxxx>
- Date: Tue, 21 Jun 2005 15:32:52 +0200
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
.
- Prev by Date: Re: TADO vs. TQuery
- Next by Date: Re: TADOTable Error without persistent fields
- Previous by thread: TADO vs. TQuery
- Next by thread: I GET error message.........
- Index(es):
Relevant Pages
|
