I am using IBO V4.2Hi. In my application I started getting "Error in
Binding Cursor" errors. I am using "OnPrepareSQL" to make changes to the
where clause with "SQLWhereItems.Add". This is all triggered with a check
box that when clicked will do

InvalidateSQL;
Refresh;

on the dataset. This works quickly and most of the time but occasionally I
get an error "Problem with Binding Cursor". The program cannot continue.
If instead I use

UnPrepare;
Prepare;
Open;

I do not get the error but this is much slower. It seems that the failure
comes about when the refresh takes a while to find and bring back all the
rows and I am able to change the check box starting the "InvalidateSQL" and
"Refresh" before the last refresh is completed. Apparently I cannot "step
on myself" when I use the "UnPrepare", "Prepare", and "Open" .

Is there any way to be sure nothing is pending before calling
"InvalidateSQL"?

Jerry Sands