Hello! It's been a long time. I've been working around this one for as long as I can. Here's the msg:

        The control record "RECORDS"

          is too long to be saved.

The current record length is 65540 characters.

Any ideas? (ARev 2.1)

I'd say you have QUICKDEX or RIGHDEX installed on the file. This MFS writes a record in the file with the key "%RECORDS%" which has the ordered keys for the file in it, field mark delimited. The problem you have is that all the record keys and field marks have a length of more than 64k, and you cannot have records greater than 64k, so it will not write. The only way out is to removed QUICKDEX.

J

Marty,

This means that there is a QuickDex set against this file. A QuickDex (in case you don't know) is a pseudo-index that stores all the keys of a table alpha-numerically sorted in a record with the key %RECORDS%. This record is stored in the datatable and is invisible to most table processes (e.g. LIST, SORT, etc.) When the total length of all the keys (plus 1 for each @FM in between them) exceed 64K you will get this error message.

The only solution is to remove the QuickDex which can be done by opening a Dictionary window for this table and pressing Shift-F3. You will be prompted to remove the QuickDex which only takes a second. From this point forward you will have no more trouble with this.

The one caveat is that you may have some reports or other table processes that depended on this table for the sorted keys maintained by this QuickDex. If so, then you will need to added a Btree index and added a sort logic to duplicate the same effect.

dbakke@srpcs.com

SRP Computer Solutions

Ah! So easy! Should've asked years ago!

Thanks to you both!

View this thread on the forum...