Thank-you Sergey.
Do you have any reservations about using this unsupported aspect of views?
Mike
>Mike,
>
>The variabe has to exist before view creation.
>
>>I see on the FoxWiki (
http://fox.wikis.com/wc.dll?Wiki~ViewParameters ) that macro substitution in VFP9 has changed. But when I attempt the following from the command box:
>>
>>
>pcWhere = ".T."
>>CREATE SQL VIEW vClients as ;
>>Select Clients.* from Clients ;
>>where &?pcWhere
>>
>>
>>I get a syntax error. Did this not make it into the release version?
>>
>>