i got a local table ' arinvheader ' and a remote view named ' air_aging'

now.As I select all the data from arinvheader and insert into the remote table 'air_aging', I found that 'THE LAST RECORD CANNOT INSERT'

my syntax is as the following :-
'select * from arinvheader into cursor pTempTable'

SELECT pTempTable
SCAN
SELECT pTempTable
SCATTER MEMVAR MEMO
INSERT INTO air_aging FROM MEMVAR
MESSAGEBOX(pTempTable.invno)
ENDSCAN

The messagebox can show all the correct Invoice No.
However, As i browse the table 'air_aging' , The last no of invoice didn't insert into the table' air_aging'

Why??
Pls help.
From Agnes