I Agnes issue a TABLEUPDATE(1, .t., air_aging) this should resolve your problem.
>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
Alexandre Palma
Senior Application Architect