Subject Re: [IBO] IBOquery refresh
Author Helen Borrie
At 11:39 PM 28-03-01 +0000, you wrote:
>My iboquery looks like SELECT * FROM SPROC(:ADATE,:DUMMY).
>BeforeOpen: DUMMY = NULL.
>In IBX I would use the same query as refresh query but this time:
>When I now run the procedure I will only get one record back for the
>Since I don't see a refreshSQL in IBO, can I still do something like
>this ?

Look at SQLWhereItems and the OnPrepareSQL event, which encapsulate "something like this". It shouldn't be necessary if you are just applying new parameter values to the SELECT, though. Changing params on a selectable stored proc doesn't require a fresh Prepare...

Is there any reason why you can't fetch the selected output using ParamByName?


All for Open and Open for All
InterBase Developer Initiative ยท