You can't use a property in a SQL statement, but you can assign it to a local variable before the query:
local MyValue
MyValue = Thisform.value
CREATE SQL VIEW MYVIEW AS SELECT * FROM MYTBL WHERE MYFIELD=MyValue
>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
Peter Franz