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