I have added new TClientDataset
in my project, to client. Also I have an Oracle stored procedure that takes clientid
as input & returns cursor.
The code below executes on button click
with dmMain.cdsGetV do //cdsGetV is name of Clientdataset
begin
if Active then Close;
Params.Clear;
FetchParams;
Params.ParamByName('PCLIENTID').AsString := '0022995544';
Open;
end;
On click I have error: `
cdsGetV: parameter 'pclientid' not found.
There are many other clientdatasets like this and they work good. I copied exactly the same code of those cds', but it's still not working. Any idea what's problem?
I recreated the clientdataset and datasetprovider on server ,and now it works.