General information
Category:
The Mere Mortals Framework
Title:
Dynamic SQL Views - what can be done?
Greetings!
I am working on a view that CAN have from 0 to 3 filters on it. That is, the WHERE clause could have up to 8 combinations of filters:
1) 1 = A and 2 = B and 3 = C
2) 1 = A and 2 = B
3) 1 = A and 3 = C
4) 2 = B and 3 = C
5) 1 = A
6) 2 = B
7) 3 = C
8) No filter
I must be getting old and suffering from memory failure...reason being, I could almost swear that parameterized views used to return ALL records if the parameter was blank, null or zero (something along those lines??)?? Or was that a Clipper '87 thing? (Now we're going back in time ).
Any ideas on how to write a local view that has three view parameters and may get from 0 to 3 of them populated? (Within the realm of the MM framework of course!).
Thanks!
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