> Call SQLWhereItems.Clear at the beginning of the event.

Don't anyone at anytime call SQLWhereItems.Clear.
It is cleared for your each time the prepare cycle is started.

> And before calling Refresh, call InvalidateSQL.

Only do this if you need your SQL impacted.

Regards,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com