Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SELECTing Correct FieldNames
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 7 SP1
OS:
Windows 2000 SP4
Network:
Windows NT
Database:
Visual FoxPro
Divers
Thread ID:
00995349
Message ID:
00997896
Vues:
17
>Elgin,
>
>>Do I need to manually build an SQL statement using an Array built with AFIELDS() and concatenation? Or is there a better way?
>
>Pretty much so, you'll have to replace the * in the select with an enumerated list of all the other columns in order to prevent the duplicated/renamed columns.

David,

Thanks for the confirmation. I finally broke down and setup the array needed using AFIELDS(). It's working perfectly.

Thanks again.
Elgin Rogers
Epic Solutions
www.epicsolutions.net
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform