Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with Candidate key
Message
 
 
To
04/04/2011 17:53:20
Jill Derickson
Software Specialties
Saipan, CNMI
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01506055
Message ID:
01506060
Views:
39
>>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform