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:
01202813
Vues:
13
>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

Use this handy function
Re: INSERT not as maintainable? Thread #1140411 Message #1140531
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform