At 04/23/2002 01:27 PM, you wrote:

> > 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.

Thanks Jason, I didn't know that, it's not in the documentation. Force of
habit when working with TStrings, I guess.

> > And before calling Refresh, call InvalidateSQL.
>
>Only do this if you need your SQL impacted.

That's what I meant, but should have specified it to make it
clearer. Anyway, thanks for pointing it out, it's going to stick in my
head now.

Have a nice day.


Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)