General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only