I have created a remote view to an ms access table (archive). I need to import all records into a foxpro table. So I run the code as below.
When I look in the foxpro table the right number of records is always written but the content of some records is completely blank (Not always the same records if I do a rerun) It is like foxpro write the record before it as been completly fetched ! Does anyone knows why and what to do. I have always trusted ODBC view !!!!

Thanks

Xavier

(Using VFP6 with SP3)


SELECT SELECT(1)
USE archive
GO TOP
DO WHILE .NOT.EOF()
INSERT INTO logfile (ldatetime,lreference) VALUE ;
(thedatetime,archive.reference)
SKIP
ENDIF
ENDDO
SELECT archive
USE