Sergey - Greetings.

Just tried your suggestion (below) in answer to my own question (just posted)
When I try that, I get "syntax error" (using vfp 8 sp1)

suggestions?

Harry

>Try

>cWhere = "invoice.amount > 100.00"
>CREATE SQL VIEW invoice_view ;
>    AS SELECT invoice.* FROM invoice ;
>    WHERE &?cWhere
>

>
>>Hi All,
>>
>> I've included a View as the RecordSource for a Grid in one of my Forms. My question is can I change the WHERE in the View at runtime and then REQUERY the view to reflect the WHERE clause? I know how to create parameterised views.
>>
>>

>>nAmount = 100.00
>>CREATE SQL VIEW invoice_view ;
>>    AS SELECT invoice.* FROM invoice ;
>>    WHERE invoice.amount > ?nAmount
>>

>>
>>But I'd like to do something like:
>>

>>cWhere = "invoice.amount > 100.00"
>>CREATE SQL VIEW invoice_view ;
>>    AS SELECT invoice.* FROM invoice ;
>>    WHERE &cWhere
>>

>>
>>That way I'd be able to set cWhere to anything I want and requery the view. Is this possible?