Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Problem with Candidate key
Versions des environnements
Hi,
I have a table, MSAMedicalServices, that has the following fields:
SER_ClinicFK I
SER_Invoice I Caption "Invoice"
SER_lVoid L
And a CANDIDATE key, CLINICINV, defined as follows:
Expression: BINTOC(SER_CLINICFK)+BINTOC(SER_INVOICE)
Filter: .NOT.DELETED().AND..NOT.SER_LVOID
This works fine, at the clinic installation as i can have multiple invoice entries for a clinic that are voided, but only 1 non-voided invoice for the clinic.
No problem.
I have an Export/Import scheme, however, that updates this table at Headquarters, and here is the problem.
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement