Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
V6s5 - How to make Parameterized Views return all record
Message
 
To
17/03/2004 05:12:35
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00886996
Message ID:
00887829
Views:
20
Hi Cetin

Sorry for replying late as I was out of town. Thanks for the idea.

>If ansi is off :
>myField = ?cValue && would return all for m.cValue = ''

I had no real experience with characters and I keep ANSI default ie. OFF

>between ?nVal1 and ?nVal2

Actually the requirement arose from numeric

>and put possible lowest/highest values for all.

but do I have to type in these nos. (from the help)
-2147483647 to 2147483647 or there is some shortcut to simulate these numbers something like GOMONTH(DATE(), 1) - 1
Regards
Bhavbhuti
___________________________________________
Softwares for Indian Businesses at:
http://venussoftop.tripod.com
___________________________________________
venussoftop@gmail.com
___________________________________________
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform