Ed, To the best of my knowledge, R:Scope and AUTOCHK do not validate INDEXES. In addition to making the duedate column NOT NULL you might consider adding a rule to make sure the due date is within a valid range.
Jim Bentley American Celiac Society [email protected] tel: 1-504-737-3293 ________________________________ From: "[email protected]" <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Tuesday, September 15, 2009 8:50:33 AM Subject: [RBASE-L] - Re: Strange Update 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.
