Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Navigation causes a Uniqueness of Index violation Error
Message
From
04/02/2009 15:42:50
 
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Novell 6.x
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01379281
Message ID:
01379320
Views:
27
>>>>Whenever I find a PO number at a different site I get the error message
>>>>
>>>>Uniqueness of index CRELPONO is violated.
>>>>
>>>>where "CRELPONO" is the index associated with the PO number.
>>>>
>>>>The table is buffered and the index is a "candidate" index because the user needs unique PO numbers
>>>>
>>>>I have tried to fix it unsuccessfully.. How do I fix the problem so that I do not get the error message (number 1884)?
>>>
>>>Is the table TABLE buffered? Why do you get the error on the search?
>>
>>I do not get the error on the search but whenever I try to navigate off the entry.
>
>Use table buffering. What exactly happens when you navigate off the entry?

I have
buffering set o 2 - optimistic buffering
buffermodeovreride set ti 5 - optimistic table buffering
which is why I am confused, When I use the navigation buttons O get the error message that the index is violated.

In the find U either show the deleted message or if I find the entry I go into edit mode where I can change the values or revert it. in either case I then show the navigation buttons which if I click on them show the error message. If I navigate before using the find button I do not get the error message.
Previous
Reply
Map
View

Click here to load this message in the networking platform