Hi Kamal ---

Yes I do :-) Ooooops. Thanks for catching it.



>
>You mean REQUERY('ViewName') instead of REFRESH('ViewName'), isn't it?
>
>>Hi Don---
>>
>>Use a parameterized view for the grid, change the parameter and then REFRESH('viewname').
>>
>>So, for example, if you had lineitems for an order in a grid, the view would be created as:
>>

>>CREATE SQL VIEW vueLineItems AS ;
>>   SELECT * from lineitem WHERE order_no = ?order.order_no
>>

>>
>>Your "Next Order" button might contain code like this:
>>

>>SELECT order
>>SKIP           && Changes to next order
>>=REFRESH('vueLineItems')
>>THISFORM.Refresh
>>

>>
>>
>>>I have a bound grid but I would like to filter what is being viewed. I could use a query of view, but I need to be able to change the WHERE clause then refresh the control. What is the best way to accomplish this?