>Hello everybody,
>I have a table that keep on geting corrupted from time
>to time, this is weird, it looks fine, but I know is
>corrupted because I can't use BEGIN TRANS/END TRANS.
>It just doesn't save the information ,
>If I do something like this from the command line :
>
>USE MyTable
>=cursorsetprop("BUFFERING",5)
>
>BEGIN TRANS
> APPEND BLANK
> =TABLEUPDATE()
>END TRANS
>
>As soon as I do the END TRANSACTION the appended record
>is lost and the pointer moves to EOF. I have recreated from
>scratch both the container and the table, it works fine
>for a couple days and then it crash again. Any Ideas ?
>
>=this.thanks('in advance')
There can be many things that cause file corruption. I have an article on my web site that may give you some things to look at.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer