Greetings, all. We are having an issue with a particular file in our AREV application and wonder if anyone can offer advice/solutions/etc.

In one of our files (ORG_TYPE) – used specifically as a control file, it contains roughly 45 rows and is rarely, if ever, updated – we've discovered a problem getting with the ORG_TYPE dictionary. When we are try to remove a Quickdex on the table key (in the ABBREVIATIONS – also the key – field), we encounter an FS215 error writing "LOCAL.GROUP" and when we go back to add the Quickdex, a pop-up message indicates that a Quickdex already exists on the file.

Further, we found a thread in this forum suggesting removing the %RECORDS% row for the file from the SYSPROG account, but we haven't been able to follow these suggestions, because we can't execute the ATTACH command from SYSPROG to attach the REVMEDIA file.

Any ideas/suggestions are welcome. Many thanks, –Tim

Don't understand what is wrong. What is "problem getting with the ORG_TYPE dictionary"?

You can just delete the %RECORDS% row in the file ( ORG_TYPE ) with the command:

DELETEROW ORG_TYPE %RECORDS%

Then, just select the entire file to recreate it:

SELECT ORG_TYPE

The advice to use the REVMEDIA file in SYSPROG is about manually removing the QUICKDEX.MFS from your file,

but in that case %RECORDS% has nothing to do with that procedure.

Dave Harmacek

Harmacek Database Systems

Thanks for the reply, Dave. Since this is a relatively small table, we were able to recreate the dictionary successfully. So far, the problem has not recurred. I'll post here if we have any subsequent related issues. –Tim

View this thread on the forum...