ShumingWang wrote: In multi users envirenment(include Novell,Windows,samba server) and open many dbf tables ,dbf tables opening/shareing by many users, if comeone power off his computer or windows hang, the cdx/ntx/dbf often damaged .
Shuming Wang
Shuming , all my applications are working in multiuser enviroment . I don't have standalone applications . And the database of DBFs is very stable . Believe me , they are working for some years alreday . The servers are with UPS , so power problem doesn't exist . I never detected that hang up or other problems of users PC can damage data in server side . Only some times when electricity fault , in places where doesn't existed UPS for networks controlers ( swiths , hubs ) , then dissapears some lines of data . But that doesn't damage database in server .
All applications are working with Win2K servers , in one place with Novell . Sorry , but I don't have experience with Linux .
What I noticed that the problem of damaging exist inside program . Well writen with well checked variables , without globals , in 99 % with locals vars the application will be very stable . I can only say many good words for Przemek - he did giant job , very good working CDX RDD .
All records for insertion and update use this sequence :
( cAlias )->( dbappend() ) or ( cAlias )->( rlock() )
... new record ... / or upate
( cAlias )->( dbcommit() )
( cAlias )->( dbunlock() )
Maybe you didn't used dbcommit ?
At this time I working with Navision Axapta and Oracle . Though about Oracle database exist legends , I can't to say that this DB worst so big moneys for that ...
))
With best regards !
Rimantas U.