Paul,


>What's the ? mark used for in the WHERE clause?

Wel, for VFP asking me the Where clause when opening the view when a cWhere variable does not exist.

>This works OK for me:

>

>cWhere = "1 = 1"
>CREATE SQL VIEW MyView AS ;
>     SELECT * FROM MyTable WHERE &cWhere
>

I doubt if this works for you. If you'll open the VFP8 view designes and look at the SQL code, you'll see

WHERE (1) = (1)

and this of course is not what you like it to do. VFP7 OTOH does the job right.

You can avoid the issue indeed if the cWhere variable does not exists. then VFP8 does recognize &cWhere beeing a macro. OTOH, there is no way you can create a view with the &?cWhere clause


>The code you posted doesn't work for me in VFP 8 or VFP 7. In VFP 7 it creates the view, but I can't open or modify it w/o getting an error.

It should, I've been defining my views this way since VFP6.

Walter,