Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Navigation causes a Uniqueness of Index violation Error
Message
De
04/02/2009 15:44:15
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Novell 6.x
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01379281
Message ID:
01379321
Vues:
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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform