TCL LIST COMMAND PROBLEM (AREV Specific) [Revelation On-Line Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

[[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]]


==== TCL LIST COMMAND PROBLEM (AREV Specific) ====
=== At 02 AUG 1999 10:12:18AM Dave Berkovsky wrote: ===
 
{{tag>"AREV Specific"}}
 
<QUOTE>
I never seen this before. I issue the following cammand

in TCL "LIST INVOCE_FILE BY @ID" and a good number

of records are skipped but yet I can look at them

in editor. I don't know what the problem is. Please help.
</QUOTE>
----

=== At 02 AUG 1999 10:22AM Don Miller - C3 Inc. wrote:  ===

<QUOTE>David:

If you have a B-Tree index on @ID, then it's probably corrupted.  If you have a Quickdex/Rightdex on the Table, it may have overflowed.  There is a 64K limit on the size of the %RECORDS% field.  You can check these condtions by:  Using DUMP to get the supposed record count from the table.  Then do an R/LIST Select using the Index.  If you don't get the same number of records, then the index is bad.  You can also do a FORM-LIST on the table using %RECORDS%.  If you don't get the correct # of records then the Quickdex/Rightdex is broke.



Don Miller

</QUOTE>

----

=== At 02 AUG 1999 10:59AM Dave Berkovsky wrote:  ===

<QUOTE>Don,



Thanks Don it was the Quickdex/Rightdex problem.



Thanks again.

</QUOTE>


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