TIP: Click on subject to list as thread! ANSI
echo: clipper
to: JAN DOGGEN
from: J ENDERS
date: 1996-12-08 18:37:00
subject: dbappend and corruption

JD> AH> I have a problem with dbappend and indexes. Sometimes when I do 
JD> AH> dbappend() I get a corruption detected DBFNTX 1210 error. When I
JD> AH> pack the dbf file and delete the index files and create new
JD> AH> index files it goes OK for a few dbappend()'s. But after 5 or 6
JD> AH> dbappend()'s I get the same error again. This problem happens
JD> AH> not on a stand-alone machine but always on one particular
JD> AH> fileserver. The way I handle rlock and flock is the same  as in
JD> AH> other program I wrote with no prblems. The problems happens on
JD>more then one workstation. 
JD>Try a commit (or dbcommit) after the append.
     For testing reasons you may want to try this
     replace dbappend with  the following code
     dbgobottom()
     dbskip()
     
     If you still get the error the problem is most likely somewhere in 
the enviorment. As a way arround it until you find the problem you could 
try this. I do not recommend using it for long but it is a temporary way 
around the mountain while you get some dynomite. Cteate a loop in which 
the dbappend occurs insert a local variable and give it the value of 0 
or 1 then every time the program does a dbappend() add one to the number 
and set it up so that when it gets up to 3 or 4 it will rebuild the 
index and then shoot to the append. As I said this is not a solution it 
is only a way around the problem until you find the mix up and fix it.
Jtenders
* Point van Lighthouse BBS * OS/
---
 * CmpQwk #UNREG * UNREGISTERED EVALUATION COPY
--- GEcho 1.00
---------------
* Origin: PHOENIX RISING BBS *SYSOP STARWITCH* 822-2017 (1:268/442)

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™.