Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excluding fields
Message
 
 
À
12/03/2007 14:45:46
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01202810
Message ID:
01202811
Vues:
14
No but you can build field list using AFIELD() or FIELD() function and than include it into select with macro substitution.

>Is it possible to use a wildcard (*) for the fields in a select statement and then EXCLUDE one of the fields? I need a SELECT-SQL that exports everything except the memo field into a cursor. For convienence sake I'd prefer to do it all in the SELECT rather than additional commands such as set fields afterwards.
>
>The table has lots of fields, so I'd also like to not have to type them all individually.
>
>Thanks
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform