Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
>>>>>>>Glad my question prompted you to check the view.
>>>>>>
>>>>>>But no...that didn't work...i was SURE it was the problem..hmmmmm...got the same thing....the view now DOES def. update the SER_lVoid field.
>>>>>
>>>>>When you insert a new record into the view - is this new record unique (e.g. these 2 IDs don't yet exist in your actual table)?
>>>>
>>>>The error is on the TableUpdate()...all the entries have been added to the view...see attached.
>>>
>>>BINTOC(SER_CLINICFK)+BINTOC(SER_INVOICE)
>>>FOR NOT DELETED() and NOT lVOID
>>>
>>>This means, you can have only one record for the same SER_CLINICFK and Ser_Invoice which has lVOID = .F.
>>
>>Right...i believe that is the case here (UNLESS I'm missing something, which very well could be!)..there is a single record for:
>>SER_ClinicFK = 820
>>invoice = 1
>>Void = .F.
>>
>>the other records have Void = .T.
>>
>>>
>>>Also, does it let you save the data if you don't add the very last record?
>>YES! huh! it allows the multiple VOIDED entries to be imported. hmmmmm....
>
>my have messed up data...sorry...will post again in a bit....
ALL RIGHT. SO SORRY. Yes, the problem WAS the SER_lVOID not being in the view. My problems after that were due to not looking at the test data, and, yes, already having a non-voided invoice for the clinic.
Thanks for all your help! (My only excuse is that I just completed this HUGE installation that i've been working on for a long, long, time...National Health Care in the country of Palau...feeling pretty good about it....and i'm REALLY tired.)
Précédent
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