Information générale
Catégorie:
Codage, syntaxe et commandes
Lee,
I think what I would do is convert all of the fields in the keyfield to one type
and store it in one field say of Char type. Then you would only have an primary
key index on one field.
OR
Does the text file have an added date or any kind of system date in it.
If so save the latest date when appending and only append the records
that are greater then that date the next time.
hope this helps
Jeff Whitaker
>This works, but since the keyfield is actually a combination of several different typed fields, it requires a complex index and relation that is problematic. My question is this : Is there a way of using a select statement to select just the new items to be added.
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