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

So we'd have something like this.

m.lnMin = iif(empty(m.tnID),-0x80000000,m.tnID)
m.lnMax = iif(empty(m.tnID),0x7FFFFFFF,m.tnID)

>>>
>>>and query looks like :
>>>.... myID between ?m.lnMin and ?m.lnMax
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