>If I have a large file with, say 100 fields in it and 1000 records. If I need only 10 of the fields to be updated, will my app perform better if my SQL gets only those 10 fields, instead of all fields? Also, if I have to orphan a field in a free table because it's name is a reserved word in VFP, what kind of memory issues occur if I continue to retrieve this field (25 characters) in a SQL select *; blah,blah,blah?
>
>TIA
>Mike

Yes, the SQL will perform better if you only get those 10 fields. Why do you need to orphan the field? I have FoxDOS code that I'm simply recompiling and running under VFP that has fields that are reserved words and I'm not having any problems.