>>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