Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Unique Key Violation
Message
 
To
24/07/1999 16:03:54
Antonio Gubaira
Ingenieria Y Sistemas
Valencia, Venezuela
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00245748
Message ID:
00245750
Views:
13
>Hi All,
>
>When designing a table I create a primary key. Afterwards I design a form to input data to the table indexed by the primary key. When adding a record to the table and deleting it; I cannot reuse the same key because VFP´s error handling engine submits the message "unique key violation". My DELETED setting is ON. Why does this happen and how can I work around the problem.
>
>Thanks

probably because until you pack the table that key still exists in the table.
Bruce Strom

Prayer of St Ephrem:
O Lord and Master of My Life,
Take from me the spirit of sloth, meddling, ambition and vain talk.
But give me a spirit of prudence, humility, patience and love.
Yes Lord and King grant me to see my own sins and faults
and not judge my brother.
For You are Blessed Forever and Ever. Amen.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform