> For how long does the reference to
> IB_DSQL1.ParamByName('P1') hold? I recall
> reading somewhere something about it lasting
> long enough for something to be
> done. Poor ol' memory.

The reference remains valid until the dataset has been unprepared.

This allows you to setup useful column references even at the
form/component level and initialise/clear the references using either
the statechanged or preparedchanged event handlers.

If you are into writing your own components, IBOs datalink even
receives setParamRefsChanged and setFieldRefsChanged events. So you
can derive your own datalink to interesting things with column
references.


HTH

Geoff Worboys
Telesis Computing