TIP: Click on subject to list as thread! ANSI
echo: clipper
to: ANDRE HOONHOUT
from: RAYMOND PESEK
date: 1996-11-27 17:23:00
subject: Dbappend and corruption d

AH ->I have a problem with dbappend and indexes. Sometimes when I do
   ->dbappend() I get a corruption detected DBFNTX 1210 error. When I
   ->pack the dbf file and delete the index files and create new
   ->index files it goes OK for a few dbappend()'s. But after 5 or 6
   ->dbappend()'s I get the same error again.
That's a toughie. The usual reason for a 1210 error is that the index
file has gotten out of sync with the .dbf file. It would _appear_ that
maybe you're not opening all of the index files you think you are when
run on that particular server. Have you tried upping the number of file
handles available on that server? If you're using the //F:xxx
environment variable, are you sure it's set on that server?
The best bet would be to run the program under the debugger on that
computer and assure that all of the index files are in fact opening
properly.
Could also be a SHARE problem. If you're loading SHARE, make sure
you're doing it as
SHARE /L:200 /F:4096
at a minimum, as the defaults are usually too low.
Are you issuing a COMMIT after each append?
Raymond Pesek
 * 1st 2.00 #2448 * Moderator - Clipper Echo
--- InterEcho 1.18
---------------
* Origin: PC-Ohio PCBoard * Cleveland, OH * 216-381-3320 (1:157/200)

SOURCE: echomail via exec-pc

Email questions or comments to sysop@ipingthereforeiam.com
All parts of this website painstakingly hand-crafted in the U.S.A.!
IPTIA BBS/MUD/Terminal/Game Server List, © 2025 IPTIA Consulting™.