Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excluding fields
Message
 
 
To
12/03/2007 14:45:46
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01202810
Message ID:
01202811
Views:
15
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--
Previous
Reply
Map
View

Click here to load this message in the networking platform