Subject Re: [IBO] Re: TIBOqueries parameter problem
Author Jason Wharton
Did you happen to test my fix for this yet?

Thanks,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com


----- Original Message -----
From: "Costas Droussiotis" <link-systems@...>
To: <IBObjects@yahoogroups.com>
Sent: Friday, January 26, 2001 8:13 AM
Subject: Re: [IBO] Re: TIBOqueries parameter problem


>
> > > > 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.
>
>
>