I am adding a record to each of 3 tables and then updating them, wrapped in a transaction. For some reason, the records are not going in to one of the tables. I stepped through to see what was happening. After the TABLEUPDATE, the record in question is in the table. I can seek it, browse it, etc. and all looks fine. It's when I END TRANSACTION that the record disappears and the reccount drops back down. Apparently this file keeps getting corrupted, but why would that happen on an END TRANSACTION? Any suggestions?
Thanks,
Elyse
Elyse Pomerantz