>>>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