Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Missing records and need to be inserted in tables
Hi All,
I have one EMPLOYEE.DBF which contains many employee's ID number
EMPLOYEE.DBF
ONE FIELD:(5 CHAR)
EMPNO (employee's id field)
AAAAA
BBBBB
CCCCC
DDDDD
EEEEE
FFFFF
.......
linked to the following tables also dbf extension on the same directory :
AAAAA.DBF, BBBBB.DBF, CCCCC.DBF, DDDDD.DBF, EEEEE.DBF .....
but in the AAAAA.dbf contains 2 fields :
date code
06/20/2000 AA (1 record)
06/21/2000 AB (2 record)
06/22/2000 AC (3 record)
compare with another master table called ABSENCE.DBF with 3 fields
empno date code
AAAAA 06/20/2000 AA (1 record)
AAAAA 06/22/2000 AC (2 record)
AAAAA 06/23/2000 AD (3 record)
How can I insert the (2 record) from AAAAA.DBF in ABSENCE.DBF and vice-versa the (3 record) from ABSENCE.DBF in AAAAA.DBF ,and actually
the two tables should have the same number of records.
The expected results should be :
AAAAA.DBF
date code
06/20/2000 AA (1 record)
06/21/2000 AB (2 record)
06/22/2000 AC (3 record)
06/23/2000 AD (4 record newly inserted)
ABSENCE.DBF with 3 fields
empno date code
AAAAA 06/20/2000 AA (1 record)
AAAAA 06/21/2000 AB (4 record newly inserted)
AAAAA 06/22/2000 AC (2 record)
AAAAA 06/23/2000 AD (3 record)
I'm looking for the fast processing codes to do this because of millions records to be compared and inserted.
Any code's suggestions would be really appreciated and thanks in avance.
Paul
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