Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem with Candidate key
Message
 
 
À
04/04/2011 17:53:20
Jill Derickson
Software Specialties
Saipan, CNMI
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01506055
Message ID:
01506060
Vues:
40
>>>The Import inserts the new entries into a view, v_MSAMedicalServices, and when the Tableupdate() is called for v_MSAMedicalServices, i get the error:
>>>
>>>Uniqueness of index CLINICINV is violated
>>>
>>>I'm trying to figure out how to handle this...any input is appreciated. Thanks, Jill
>>
>>Can you test if this record already exists before inserting into the view? What is the view definition?
>
>I left out that the entire group of entries is necessarily being updated in a transaction, i.e., with a single Tableupdate().
>
>WOWSA! THANKS! i hadn't even looked at the view, and when i recently added the SER_lVOID, i neglected to add it to the view...sorry, i should have seen that.
>
>J

Glad my question prompted you to check the view.
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform