Does anybody know how to check to see if an insert into from memvar actually worked?

I have a system that seems to not be storing the all of the records properly.

i.3. ifthere were 10 to insert, it might only insert 6...
i.e. 1-4 in 5,6 out7 in 8,out, 9 in 10 out...


I create a cursor to store the jobs to print. I scan through this cursor and place the records into the main table using insert into...

Right after this, I print a report, based on the cursor.... (all of the records are there as they all show up in the report.) However, some of them don't get added to my table.


Any ideas,

Mike