At 11:39 PM 28-03-01 +0000, you wrote:

>Hi,
>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:
>Before Refresh: DUMMY = PRIMARYKEYID
>
>When I now run the procedure I will only get one record back for the
>KeyId.
>
>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?

Helen

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________