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)
|