General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Cannot insert all the data
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only