you ...WHERE &?cWhere clause should EITHER have a & or a ? but not both.
& makes it Macro driven,
? is a parameterized view
Hope this helps
Peter
>Hi bob,
>
>Please read the reply of Jim,
>
>It's all about defining a view with a flexible where clause you can change at runtime without changing the view definition.
>
>Walter,
>
>
>>Try to put the line:
>>
>>cWhere = ".t." before your create.
>>
>>>This is getting depressing. Since the 10 day's or so ive been working with VFP 8 this is the 5th bug I had to report. I wonder what MS definition of stable they use when they say it's the most stable version. It does not crash more often than VFP7 allright, but the other bugs are pretty irritating.
>>>
>>>In VFP you can write a SQL VIEW definition with a macro in the where clause like
>>>
>>>
>>>CREATE SQL VIEW MyView AS ;
>>> SELECT * FROM MyTable WHERE &?cWhere
>>>
>>>
>>>which enables you to define a flexible whereclause in runtime by just filling the cWhere variable.
>>>
>>>However in VFP8 the view cannot be created either in code or the view designer. It would give a nice Syntax Error. The only workarround I found is to create the view in VFP.
>>>
>>>To the VFP team: If you're going to fix this please make it also possible for remote views to use this strategy....
>>>
>>>I beginning to wonder if I should start a new thread: The 100 bugs in VFP8
>>>
>>>Walter,
Peter Cortiel