Information générale
Catégorie:
Codage, syntaxe et commandes
Hi Ajay,
The following is what I did, However it doesn't check the duplicate record.
Also the code works for the first time when both temp and annual database are empty. But when the second time come, where temp database now contain duplicate records for each record (double the size). And the code didn't check for dup, instead it just append all the records from temp database into annual database.
Any ideas!!!
select temp
APPEND FROM d:\dean\ftp.txt TYPE delimited with |
select annual
set order to lastname
select temp
scan
if !seek(f_fname+f_lname, "annual")
scatter fields like * to t_array
select annual
append from array t_array
release t_array
else
exit
endif
endscan
Précédent
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