Subject Re: [IBO] Difference 'tween Open & First (IB_Cursor)
Author Geoff Worboys
> Before my main import routine, I prepare this query.
> What I was doing was to close the query, set the new param value,
> then call open.
> Could it be that the cursor was 'remembering' it's last position,
> even though I was closing then re-opening it?

Yes it does remember the parameter at the time it was closed.

You dont need to close a query to change the parameter (indeed,
as you have discovered you should not close the query just to
change a parameter). Just change the parameter and call First
to get the altered selection.

Geoff Worboys
Telesis Computing