>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.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer