Subject Re: [IBO] SqlWhereItems -
Author Jason Wharton
> in a TIB_Query where select statement is initialy select * from table for
> 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
> 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
Something else is in you app to make it not behave I think.
Jason Wharton
CPS - Mesa AZ