General information
Title:
Using parameterized views
Hi, We are starting converting our app. which is presently using Native VFP Database TO C/S. and i am pretty new at using views. So my question will probably be an easy one for all of you...
For example, i need to get an updatable view with 2 different parameters of the same table, my select statement in the create sql view would look like this:
1. SELECT SomeFields FROM RemoteTable WHERE MyField = ?SomeVariable
2. SELECT SomeFields FROM RemoteTable WHERE MyField IN ?SomeVariableList
The only difference is the WHERE clause. Do i have to create 2 different views or is there a better way to to this? Basicly, what i need to know is: do i have to create a new view every time my WHERE clause changes?
Thanks a lot.
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