General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi Mary-Ann.
Some ideas:
- are you sure the data in the column has no duplicates
- there might be some deleted records in the table. You must pack the table to remove. Uniqueness is enforced for deleted rows as well since they are still in the table and could possibly be "undeleted".
>trying to create a database with 2.6 tables. I'm able to put them in the container, but then if I try to change the 'main' file's index to 'Primary', I get "Uniqueness of Index IndexName is violated". I can't set up the relationships. The only way it will work is if I delete all the records. But when I do that, (obviously I'm going to need the data) and try to append from a copy to add the records back in, it stops at about a third of the way through and gives me the same "uniqueness of index" error. What am I doing wrong?
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