Try running R:Scope on the database.
I did have something similar happen when updating an operations table.
Every time a record was updated a 2nd copy of the record would appear.
Found the customer table, which is a feeder table, had corrupted.
Reloaded the customer table from a backup copy and all has been running
fine.
-------- Original Message --------
Subject: [RBASE-L] - Strange Update
From: Ed Rivkin <[email protected]>
Date: Fri, September 11, 2009 11:04 pm
To: [email protected] (RBASE-L Mailing List)
I am curious if someone has faced a similar situation.
The problem revolves around a .rmd file originally
written for my application 20 years ago using r:base 4.0.
I update a table monthly with 140 entries; one for each
account. To do so, I print a report to disk, load it into a table
and append the table to my master table which is the current
Rent table. In addition all rows for accounts with a zero balance
are moved to the Rent History table and deleted from the Rent Table
Prior to the print / load / append the DB is disconnected
and the DB is copied so I have a recovery point in case
something fails.
The only changes from 4.0-4.5 - 7.6 are the screen handling messages.
After testing the conversion everything seemed to work fine. Running
parallel we are having a strange problem. Many of the current Rent
records are duplicated, others tripled and quadrupled and some of the
history data is finding it's way back into the Rent file.
When I commented out the Disconnect / Copy to Disk / Connect
everything worked fine again.
Am I hitting some sort of DB corruption issue? Should I put a
Pause for 30-45 secs after the connect? Or am I totally missing
something else.
Thanks as always,
Ed
