>when I want to add a record with a key value that exist but is deleted,i can't because the key must be unique.How can I solve this problem ?
Hola Favio,
I'm not sure that set deleted on will fix this. I just did a quick test and didn't work.
You have two options:
1. pack the table to physically remove the offending keys.
2. when deleting a record, change the value of the field with the primary key to something else so it doesn't byte you next time you add this records.
Normally (as in normalized), the primary key is a number or string that is completely unrelated to the data you're working with.
If you'd like me to send you all this in Spanish, let me know and I'll email you.
Good luck!
Alex
Low-carb diet not working? Try the Low-food diet instead!