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?
>
>