Subject | Re: [IBO] Re: TIBOqueries parameter problem |
---|---|
Author | Costas Droussiotis |
Post date | 2001-01-26T15:13:24Z |
> > > WIth IBX I use IBQuery with SQL:Ok, after some fiddling around with it here is the solution:
> > > 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.
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.