What does
ENDIF do here in your code?
>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
Igor Gelin
Database Developer