When I do paramaterized views, I have the parameter be ?lcSomeVar. Then I do:

LOCAL lcSomeVar
lcSomeVar = THISFORM.SomeProp
REQUERY("TheView")

That works for me.

Michelle


>Another silly question,
>Can I use the following sql statement to create sql view:
>'CREATE SQL VIEW MYVIEW AS SELECT * FROM MYTBL WHERE MYFIELD=Thisform.value'
>I found 'Thisform.value' can be replaced by a PUBLIC VARIABLE but I rather like to use local variable.
>
>Shall I change my mind?
>
>Sunny