Hi!

I'm sorry that i my expression is not correct....

My wanted is, change the SQL of a view .

I want to accept condition/order input of user, then change the view
then simplely requery.

Max.


>Hi!
>
>I guess yes. Did you tried it on a simple test before implementing something really big? I know for sure that sorting order by index is maintained after requery(). Probably filters are maintained too. However, WHY you want to filter the view, when you can define it as part of the SQL Select statement for view, and just use requery()?
>
>>Is it prossible do this before launch requery() again ?