General information
Category:
Coding, syntax & commands
>My brother has a table clients.dbf with 341 record
>
> I have a table clients with 351 records.
>
> My table is equal his table up to record 341.
>
>I have to send data to him every day because I add the clients
> to my table, he only process data
>
>
>
> Option1 - If I e-mail my table to him, how can he automatically
> add these 10 records to his table ?
You'll need a litle procedure the check for existing records on the destination table, if there is a unike key then you do not have to verify the data for every field in order to not include an existing record.
>
>
> Option 2 - If I e-mail only the 10 records to him, how can
> he add these 10 records to his table.
use destination_tabble
append from surce_table
Hope thie helps
Regards
Osar Corte
>
>
>
> TIA
>
> Moses
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only