General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>The problem is that you have different tables with sometimes the same primary keys.
>What you can do is setting the index to unique before you append the data
>Then you can append all the data
>Now you have some duplicate values.
>If you only want to have the first ones you can do this.
>Set the order off
>issue delete all
>set the order to the unique index
>issue recall all
>Now you have only one record per primary key value
>now pack the table and set the index to primary key again.
>
>(For changing the index type look at alter table.)
Thanks Ko for your answers..
I think I havn't explaines my self well...
I have the same table on remote sites, I want to unite the data together on a central station. I have a primary key on the "jobno" field. I use the APPEND FROM to a zapped empty table, and on the first append I get the unique key violation.
I'm not sopposed to have duplicate values because each site has it's own set of numbers.
In hope to get more good advice,
Thanks,
Gadi Hutt
Previous
Next
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