>>>>We are experiencing various errors when multiple users are adding records, specifically "Update Conflict" and "Uniqueness of x is violated". We are using optimistic row buffering and have an error routine that traps these errors. For the "Uniqueness" error we have coded a retry however we then get
>>>>"Table buffer for alias x contains uncommitted changes.".
>>>>
>>>>Has anyone got any ideas as to what were doing wrong, or any suggestions of a better way to handle these errors.
>>>>
>>>>Thanks.
>>>
>>>Do you have primary tag on your table? How do you generate this key for new records?
>>
>>We do have the field marked as a primary tag. It appears to be giving us the error on the Append Blank ie. two people have created a record on the table with a primary key of spaces.
>
>You should either generate key right from field default value procedure, or use INSERT INTO instead of APPEND BLANK.
Thanks, I think ultimately we'll change to INSERTs, but in the short term I'll look into the field default value procedure. This will be the first time I've used them - is there anything I should look out for?
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