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.