> in a TIB_Query where select statement is initialy select * from table for

update,

> I sometimes need to to change the where clause by code. I´m doing this by
> InvalidateSQL; Refresh;onPrepare > Sql.WhereItems.Add(..). The result is

ok,

> but if I now change the orderingItems, the select statement is rebuild to

select * from table;

> What I would need is the behaviour, as when I had assigned the search

criteria via

> searchmode.

If you change the OrderingItems it still should trigger the OnPrepareSQL
event.
Something else is in you app to make it not behave I think.
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com