I have a table called SALES declared GLOBAL and residing on a volume called SALES. I can create a MERGE document using this table; however if I try to include any field from the table I receive the error message "XXXXX not a valid field name." I can create a MERGE using other tables with no problem. LH_VERIFY checks out on this table. I removed QUICKDEX from the dictionary in case that was a problem but no dice. Suggestions??

Lauren Floyd

It would seem that the filename being the same name as the volume is the problem.

Try renaming the VOLUME to something else or rename the file temporarily and try the MERGE.

Yes, I have found that naming a file the same as the volume causes some significant problems. In particular, I have set up my client with an Imports file name within an account called Imports. I have found that I can't VERIFY this file. Rather, the procedure begins to verify all but the Imports file.

As far as merging, however, I have had no problems. I'm wondering if the SALES volume is the default volume. If not, I would be check to see if the volume is being attached. Even if the SALES volume is global, you need to attach that file if it's been used from another volume.

Changing the volume didn't work. I changed the volume name to SALES_VOL and even tried an alias for the file (SALES_ALIAS) but that didn't help either. If and when I solve it I'll post the problem/solution.

The %FIELDS% row in the dictionary was corrupted. It looked normal, but on closer inspection contained few or no dict items from the dictionary. It looked like it belonged to a differenct dictionary.

I copied the dictionary out to a temporary table, cleared indexed, cleared the dict then copied the items back in and reindexed. All is well now.

Lauren

View this thread on the forum...