Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Avoiding a parameter in a Parameterized View?
Message
From
11/02/1999 00:57:27
 
 
To
11/02/1999 00:35:06
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00186376
Message ID:
00186383
Views:
12
Hello, Adrian-
You do something like the following psuedo-code.

IF use2ndParameter
lflag = .F. && Yes, I really mean .F.! :-)
ELSE
lflag = .T.
ENDIF

SELECT * FROM cTable ;
WHERE ?cx = m.somevar .AND. ( lflag .OR. ( ?cy = m.someVar2 ) )


>Assume we have a view with two parameters, and in a given situation while running the application, we don't want the second parameter to limit the view, only the first one. How can I symbolize that? Can I put some "wildcard" as the value of the second (un-needed) parameter?
Previous
Reply
Map
View

Click here to load this message in the networking platform