control row %records% too long (AREV Specific)
At 05 APR 2000 03:56:42PM Katia wrote:
Every time I try to save a record from a table I get the following error message: " Physical error writing xxxxx in table MYTABLE"
" The control row %records% is too long to be saved"" The current length is 65548 characters"The average lenght of a record when I edit it, is 112. The file itself is not so big, around 3644 records. Im not sure what this error is all about. I'd appreciate all input. Thanks!
At 05 APR 2000 04:45PM Matt Sorrell wrote:
Katia,
If I remember correctly, this error is because you have either a Quickdex or a Rightdex on the table.
The number of records in the table, times the length of the key is too big for a Quickdex.
Remove the Quickdex and the error should go away.
At 06 APR 2000 12:30PM Don Miller - C3 Inc. wrote:
You undoubtedly have a Quickdex or Rightdex on your table. This stores all the keys in the table in a hidden record called %RECORDS%. The length of this record cannot exceed 64K. To estiamte the size of the record, add up the lengths of all the keys and add 1 byte times the number of keys to account for the field/value mark separator. You can make the problem go away by removing the Quickdex / Rightdex filing system from the file. If, however, you are counting on this structure to give you the data records in sorted order, then you'll have to change your app to select the file by key. I have a VOC item that we use to determine whether a Quickdex / Rightdex will work:
Call the symbolic KEYLEN_QD
@ANS=LEN(@ID)+1
then…
LIST TOTAL KEYLEN_QD DET_SUPP GRAND-TOTAL "KEYLEN"
to determine the size of the Quickdex.
HTH
Don Miller
C3 Inc.