rollback problem?

[Yash]

Hello people,
My tables are all MyISAM. I found the database did a rollback when the server was rebooted. Also, an invoice will be created. The parent' invoice table does not allow duplicate invoice id's - however strangely enough invoice 711 was created and printed off - then the clerk created another invoice - in which the same # was issued and all record of the previous 711 was gone. But then a small rollback occurred. Any idea why this would happen? Your help is appreciated.
Thank you so much! -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[Beau]

MyISAM cannot do rollback. Every change is immediately written to the data file. But this file is not flushed to disk immediately. The operating system flushes it on its own discretion. Hence, data can be lost if the operating system stops without flushing its file system cache. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --