General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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
Yes, you can do that... you should have a ? before the property like...
'CREATE SQL VIEW MYVIEW AS SELECT * FROM MYTBL WHERE MYFIELD=?Thisform.value'
However, it is, as others have said, better to use a variable, and populate it prior to using or requerying the view...
'CREATE SQL VIEW MYVIEW AS SELECT * FROM MYTBL WHERE MYFIELD=?vp_value'
local vp_value
vp_value = ThisForm.Value
use MyView
BOb
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