Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Integer Keys and Parameterized Views problem
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9
Database:
Visual FoxPro
Divers
Thread ID:
00991324
Message ID:
00991331
Vues:
16
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?
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform