Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Append unique?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00351193
Message ID:
00351203
Vues:
17
>>I need to append from a table only those records I have not appended before. I have a unique field but just cannot find the proper way to do this.
>>I have to append data from 3 remote locations into a local table daily
>>without duplicating these records
>>any ideas?
>>thanks in advance..
>>Dave Carter
>
>You can use a SQL select to get the records you haven't previously appended and then append them from your temporary cursor.
>
select * from mytable where mytable.uniqueID not in ;
>   (select uniqueID from targettable) into cursor c_temp
>select targettable
>append from dbf("c_temp")
>
>HTH.
Man....when I think of the things I don't see...
Thanks I believe that will do it.
Dave Carter
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform