Hmmm... are you certain that all VFP commands that can reference an alias will work properly with an alias of "FIELDS"? If not, it would be better to accept that a mistake was made and do all the fixes now. This is the sort of situation that can come back to haunt you if not fixed properly.
>As a temporary fix, you might consider renaming the table to "MyFields" (or whatever) and then adding an ALIAS FIELDS clause wherever you have used it. This way the only code that will have to be changed will be the lines where you open the table.
>
>HTH
>Barbara
>
>>One of my databases contains a table named "fields." I get an error whenever I try to modify this table in Stonefield. I suspect it is because of the table name causing a conflict. Is this true?
>>
>>Elyse
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up