General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Parameterized Views
Hello everyone,
I would like to know how to pass a parameter to a view's "where" clause for conditions. For example, in different areas I may have different "where" clause conditions. In one instance, I may have "cField1 = 'x'" and in another instance "cField2 = 'y' .AND. !empty(cField1)". Is this possible? I had attempted the following but it did not work: "create sql view test as select * from myTable where ?x"
then before issuing the "use test" I assigned x="cField1 = 'x'". I would appreciate any suggestions.
Next
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