Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
IN clause in Parameterized views
Message
De
02/04/1999 12:43:52
Bruce Gilmour
Cal-Mour Consultants
Calgary, Alberta, Canada
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00204282
Message ID:
00204697
Vues:
12
>>I want to create a view that contains only certain records (eg- from an order file containing orders 1 through 15 I want to print 3, 6, 7, 9, 12 where the order number is a character field). I figured the easiest way was a parameterized view that contained a clause such as "WHERE ordernumber IN

>That's a known bug...INLIST() will work. (but is not upsizeable, I guess...)

Thanks Bruce. As you state, it has a limited number of parameters ans thus is not feasable. Also please see my reply to Edward. Thanks again for your input.
***************************
Bruce Gilmour

"Two things are infinite, the Universe and human stupidity. And I am not sure about the Universe."
- Albert Einstein
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform