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.
