>>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


Seems like the =rlock(), unlock has done the trick.. it has been two weeks and no lost records.. Mucho thanks

Mike