Information générale
Catégorie:
Codage, syntaxe et commandes
>I do put the name like this: FUNB-04102001.TXT. I rename the file the same way in some cases. There are others where I have to name the file something else ao that another program that I have no control over can use it. This is usually when I run into this problem. Have any idea how to find duplicates int ehtables if thus does occur?
If there is no Primary Key or unique identifier in the incoming file that can be used to check against existing data. You would have to check each entire line against the data. And add each record individually if it was not found. I assume this is what you want to avoid. Since there is a new file coming every day. You could keep a log of when the files have come in and been entered. When you go to import your file check to see if the process has been done for that day. If so, then just rename it so the other app can use it.
HTH
Mike
Précédent
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