Subject Re: [IBO] Re: TIBOqueries parameter problem
Author Costas Droussiotis
> > > WIth IBX I use IBQuery with SQL:
> > > SELECT * FROM MYSTOREDPROCEDURE(:PARAM1)
> > > On my client I have a clientdataset where I change params at
> runtime
> > > and close/reopen.
> > > This will pass the parameters over to the server and get back the
> > > result. This also works with TQuery.

Ok, after some fiddling around with it here is the solution:

First close your clientdataset.
Assign the parameter(s)
Then Open the clientdataset.

It doesn't work the other way round, ie. set parameter-close/open.

HTH,

Costas Droussiotis.