🚀 go-pugleaf

Use Open instead of Execute when the query returns data

Alain Christis

"Gargoyle" <Gargoyle@NOSPAMpandora.be> schreef in bericht
news:ewEY7.5124$mE6.1447467056@hestia.telenet-ops.be...
> Hi,
>
> I am using as server a remote data module which holds a TIBStoredProc
> connected to a TDataSetProvider.On the clients side I am using a
> TClientDataSet conected to the TDataSetProvider on the server (so far so
> good, i think). There is also a TDatasource connected to the
TClientDataset.
> Now for my problem:
>
> On a simple form I am using a 2 TDBLoookupComboBoxes to get some info. I
> want to sent 2 different parameters(KL_ID and KLAD_ID) to the
TIBStoredProc
> and get other data back. But I get nothing back.
>
> With DMClient do
>     begin
>     With CDSOphalenKlAd do
>         begin
>         Params.ParamByName('KLAD_ID').Value := KL_ID;
>         Params.ParamByName('Kl_ID').Value := KLAD_ID;
>         Execute;
>     end;
>     With CDSOphalenBest do
>         begin
>         Params.ParamByName('KL_ID').Value := DBLookupKlant.KeyValue;
>         Params.ParamByName('KLAD_ID').Value := DBLookupKLAD.KeyValue;
>         execute;
>     end;
> end;
>
> What do I have to do to get the corresponding data back from my server?
> I want to fill this data into a dbGrid.
> What do I do?
>
> regards,
> F.
>
>
>
>