>>>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:
>
>Under the heading of Stupid VFP Tricks, try the following:
>
>CREATE TABLE _vfp (formcount I, name c(50))
>APPEND
>
>And even stupider VFP Tricks:
>
>CREATE TABLE _VFP (formcount I, name c(50), activeform m)
>APPEND

Ed,

I have no doubt that certain field names will cause problems if using reservered words. Others obviously don't, since I'm not having problems with them.