Sorry just paste that one by mistake but should not be there, it is only a mistake in the messsage not in the code.

Xavier

>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