Has anyone ever come across a problem when adding rows to a table through a standard MM business object and the index on the table has become corrupt?

I have an audit table that records changes to other tables in the database. I use a standard business object to create a new row using the new method, I replace the column values accordingly and save the object using the save method.

No errors take place, the id table gets incremented properly for the primary key id value, but no rows are added to the audit table. After dropping the index and recreating the index, the object works properly (until of course the index gets corrupted again.)

This sounds like a VFP issue, however, it is very disconcerting, since no errors are being triggered and the rows that should have been inserted are lost.

Any help in this is appreciated.