>We have the same Problem with Novell. The transactions can stay one or two days and can be dispear at 3rd day.
>Interesting...!
Not being in your shoes I'm not as familiar with your situation as you are, however ....
When a record is written to the table it can't be removed with out a PACK. You can mark it as deleted but it is still there. PACK is the only way to
remove it from the table. (unless you write code to perform the same function as PACK)
If we take this as fact, then either the record is being deleted and the table PACKed or it was not written to the table in the first place. If the transaction existed for a few days before disappearing this would appear to rule out buffers not being written out to disk (which would probably not have such a specific effect anyway.)
I'd look elsewhere for the problem.
Regards
Liam
PS I don't mind being told I'm wrong so if there's explanation for such specific behaviour on the part of Novell I'd love to hear it.
Liam O'Hagan
MCP VFP Desktop Apps