I am refering to values that you can give to IBOQueries parameters at
runtime. The sample is quite simple:

Drop this on a form:

clientdataset
IBConnection
IBTransaction
IBOQuery
Provider
and link all of them
plus:
datasource and dbgrid to visualize the clientdataset

now pick one stored procedure that has 2 params and returns something
and select from that in your query:
SELECT * FROM SPROC(:MinValue,:MaxValue)
now you add parameters (MINVALUE,MAXVALUE) and put some default
values in of which you know that they return something.
activate your cds and it will NOT return records.

now put some values into your iboQuery's parameters. Any value will
work. Then reactivate your cds and the records should appear now.

I will put an example together on Monday and mail it over.

Patrick




-- In IBObjects@y..., "Jason Wharton" <jwharton@i...> wrote:

> What do your mean by default values?
>
> Can you help me isolate this in a sample?
>
> Thanks,
> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com
>
>
> ----- Original Message -----
> From: "Patrick Z Lenz" <patrick_lenz@y...>
> To: <IBObjects@y...>
> Sent: Friday, January 26, 2001 12:49 PM
> Subject: [IBO] Re: TIBOqueries parameter problem
>
>
> > Hi Jason,
> > I did some more testing with clientdatasets and iboqueries with
> > SELECT * FROM SPROC(:MinValue,:MaxValue)
> > You should find that the clientdataset will not show any records

for

> > stored procedures with 2 or more parameters.
> > That's different from Tquery or IBX's IBQuery and that's why i

got

> > stuck.
> > My workaround is to specify some default values for the params

within

> > iboquery. They will be overridden by the clientdataset anyway but

it

> > won't work if you don't have them.
> > Regards
> > Patrick
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >