Hi,

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.

Any hints ?

Thanks
Harald