>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
You might try checking the reccount() after each insert, perhaps something like..
select yourtable
=flock()
store reccount() to m.records
insert into yourtable from memvar
*force reading of current table header
=rlock()
unlock
if reccount()<=m.records
wait window 'Insert was not successfull'
endif