Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SELECTing Correct FieldNames
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows 2000 SP4
Network:
Windows NT
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00995349
Message ID:
00997896
Views:
19
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform