Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using parameterized views
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Using parameterized views
Miscellaneous
Thread ID:
00322466
Message ID:
00322466
Views:
57
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
Map
View

Click here to load this message in the networking platform