Thanks for the good wishes and advice. The progress feels like two steps forward
and one backward but thanks to you and all the great folks on the forum it will
get done.
Records are being deleted from the table getting the insert but they are relatively
small in number. Put it a different way.
Before the insert. Table has 2100 records currently approx. It is the current Rent table
100 records max are moved to history and deleted from current Rent table
140 records are created in table that I call Rentemp but is actually saved
as empty table in the DB. I don't believe we had Temp tables 19 years
ago and I didn't think to change the design today.
This table is used for a few different things in the system. It would be
easy enough to Drop it and Recreate empty each time rather than
just delete the rows. My system is single-user to there isn't a
consideration in that regard.
Back to the record count. 41,000 is obviously a problem. What is interesting about it is that many of the
erroneously created records are history records now sitting in the current table. I never copy in this .rmd
from history to current.
Take care,
Ed
Sep 15, 2009 08:51:34 AM, [email protected] wrote:
Ed: Glad you've made progress! If I remember right, didn't your code
delete rows from the table that you were inserting the data into?
Maybe your delete wasn't working due to some problems with that table,
so you were constantly adding to the table. If the table was a temp one,
try dropping it and recreating it rather than deleting rows (I try never to
delete rows from a temp table). If the table was a permanent one, see
if you can change the code to use a temp table instead, or drop and recreate
the permanent table if you don't think others would be using it at the same
time.
Karen
b) Switched to another b/u copy of the DB. I generated the 140 records several
times and it worked as desired; i.e. 140 records added to the Rent Table. I
am sticking with Emmitt's advice and using the new code going forward for this.
So it appears that the problem was corruption somewhere along the way. I am
still wondering why R:Scope didn't pickup anything. I also discovered that the
date errors I was getting reloading the entire Rent table after an unload (Believe
this was Karen's input) was likely due to 6 records that didn't have Duedate in
them. My user apparently added some special charges without Duedate.
