Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
MS ACCESS table through ODBC leave some records blank ?
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement