Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Creating a conditional 'where' clause
Message
De
07/06/1999 08:13:45
 
 
À
04/06/1999 15:07:15
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00226172
Message ID:
00227009
Vues:
31
>Yep... i remembered later how to do this. What you are actually doing is redefining the view that is in the .DBC depending on how you want it... So, you set the lcWhere to what you want, then run the create sql view command. Of course, this will requre each user to have there own .DBC, but that is not a big deal any way.
>
>Another idea is one I have used also... take the SQL from the view and build the where in code... then use SPT to do the view.
>
>One thing I din't know if you knew. If you create a parameterized view, and use like you can just populate the view with a % to get all records...
>
>select * from p1 where p1_function LIKE ?vp_function
>
>Then, you just populate vp_function with your value for that specific record, or % for all records.
>
>BOb

Thank you, thank you, thank you!! It was the LIKE % that did the trick! That's exactly what I needed. Thanks Bob!
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform