Internal Error #1210, __DBPACK(0), __DBSKIP(0)
() Record not found in index. It should only occur if the database
is updated without the index being open. Recreating the index and
re-running may clear it up.
(See Also Richard Thompson's BADPAC.ZIP or Fernando Villar's
IE1210.COM in the Nanforum libraries for examples)
(#95089) This scenario says to make a small database, and then make
2 indexes, one indexed on a large field and the other a small field).
Make sure the order in the SET INDEX command is <large key> then
<small key>. Performing consecutive GO BOTTOM; DELETE; PACK will crash
to internal error #1210.
() I was unable to reproduce this error by using this method. My key
was 30 characters for the large index, 1 for the small, and I had 300
records in my test database.
(#110430) This indicates that 1210 can occur when two machines update
the same record at approximately the same time using an rlock(), commit,
unlock sequence.
(#112069) The following code fragment goes through an entire table
replacing the FILTER field. There are three indexes open when the order
is set to 0 before the loop. Part of the way through the table the error
INTERNAL ERROR 1210 __DBSKIP(0) occurs.
set order to 0
go top
do while !eof()
@ 0,0 say "Company"+profit->comp_code
lockrec()
profit->filter := if(profit->contract<nAmount,.t.,.f.) // Field Assign
// Suggested fix: GOTO RECNO()
skip
enddo
Nantucket indicated that placing a GOTO RECNO() directly after the
field assignment may solve this particular instance of the problem.
(Mail: Sandy Mark [73730,3601]) Sandy found that, in her application, ~
if a replacement occurred on a keyfield and her 6 indexes were not up
to date, then the internal error would occur during an UNLOCK command.
Sandy commented out the UNLOCK command, and got the bomb on CLOSE DATABASES
instead. When Sandy tried the GOTO RECNO() fix above, the internal error
simply referred to __GOTO.
(#120706) Alan Wilburn [71640,1322] suggests: "If you are running on ~
Novell 3.x make sure all of your .ntx and .dbf files are marked Shareable
Read Write. Novell 3.x will buffer at the workstation if the files are
not marked this way. Tech support has informed me the 1210 internal error
was a 'buffering' problem."
Also, make sure the buffers setting in CONFIG.SYS is a multiple of 8.