>>Hi nadya,
>>
>>It does work with the view designer. However you'll have to omit the question mark. (so &cWhere) and be sure the cWhere variable does not exists. I'm not sure what you mean by "use this view as part of database" though. all views are part of a database....
>>
>>Walter,
>>
>Is it changed when you do requery() ?
>
>I have to try it...
>
>It doesn't allow me to do it. I open ViewSQL, remove my where condition and put &cWhere instead of the whole where clause. It produces an error and reverts back to original filter. What can I do?
>
>Thanks.
Just set a public variable cWhere = ".t." before saving the view or make cWhere as a parameter to view (Char Type) but then You must change WHERE clause to &?cWhere
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.