Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Integer Keys and Parameterized Views problem
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00991324
Message ID:
00991331
Views:
15
Craig
You mean using two params for each integer field?
Jaime

>Use between. Make the low end 0 and the high end a very, very big number.
>
>>Hi
>>I generally use Character type fields ( even for key fields ) specially when there is a chance i'll use these fields in param. views. This way, in my app, setting the parameter to the empty string just ignores this parameter. This is great specially for views with many parameters. The problem is that i would like to use Integer fields instead of char. for some key fields to improve speed and efficiency, but in this case, how would i go to make the view ignore the parameter involving the integer field? Setting it to 0 just brings me all those records having the 0 value, not at all what i want.
>>
>>TIA
>>Jaime
Why do programs stop working correctly as soon as you leave the Fox?
Previous
Reply
Map
View

Click here to load this message in the networking platform