[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]


==== Physical Error Writing Writing Record (AREV Specific) ====
=== At 16 MAR 2002 02:27:56AM Jim Dierking wrote: ===
 
{{tag>"AREV Specific"}}
 
<QUOTE>
Physical Error Writing xyz in table 

FS152....The control row "RECORDS" is too long to be saved.

The current length is 65552 characters....

I am writing from a production file to an archive file.

The archive has 2814 records with an average of 23 characters in each

record key.  There are 194 dictionary records in the archive file.

Why am I receiving this message?  

TIA, Jim Dierking

Liberty Natural Products, Inc.
</QUOTE>
----

=== At 16 MAR 2002 02:37AM Jim Dierking wrote:  ===

<QUOTE>Also, I just deleted a record and then ran my archive routine.  It wrote an additional record.  I then tried to manually copy over the

deleted record and I received the same error message.  It seems like

it is saying there are too many records in the file.  How can this be?

Jim

</QUOTE>

----

=== At 16 MAR 2002 06:10AM Donald Bakke wrote:  ===

<QUOTE>Jim,



[i]The archive has 2814 records with an average of 23 characters in each record key.[/i]



If you multiply those two numbers you have nearly 64K of key ID characters. Add in an @FM for each key and you have exceeded 64K in the QuickDex (or RightDex) control record (%RECORDS% in the data table). The only solution is to remove the QuickDex. However, this may affect how reports and popups against this table are sorted. You would then need to add a Btree index against the key ID and do some programming changes to achieve the same sorting requirements.



dbakke@srpcs.com

[url=http://www.srpcs.com]SRP Computer Solutions, Inc.[/url]



[img]http://www.srpcs.com/srpicon1.gif[/img]

</QUOTE>

----

=== At 16 MAR 2002 05:21PM Jim Dierking wrote:  ===

<QUOTE>Thanks Don.  I created the file by using copy file.  I forgot that

I had installed rightdex in the original file and also did not know that %RECORDS% is a Rightdex file.  Thanks for the help, Jim.

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=5B451EE5492DC8C888256B7E0023843C|View this thread on the  forum...]]