General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>>>>>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....
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only