exclusive databases, how do i keep forim erasing during a crash!?

[redzombi19]

hey guys,
i need to figure out how to make my database indexes from getting erased when the program freezes, there exclusive so i can open them and zap them to start a new day, any help???
:0) thanks

 

[ramani]

HI REdzombi,

You should wrap all your write operations using transaction processing and flus. This will ensure that you are almost safe from these problems.

Example..
BEGIN TRASACTION
APPEND BLANK
REPLACE myFields with myData.. whatever
or
INSERT INTO TABLE.. WHATEVER
FLUSH
END TRANSACTION

WHen you use the update functions within the above loop of BEGIN TRANSACTION.. END TRANSACTION.. if any failure occurs, the records are auto rolled back to the correct position.

Remeber to keep the transactions small and without any user inputs inbetween.. such as a wait statement or acceptance of data.

ramani
(Subramanian.G),FoxAcc, ramani_g@yahoo.com