Shared be

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JO - 17 Oct 2004 15:57 GMT

This is split dbs with a shared be database - optimistic locking. When
testing to see if an appointment can be entered at the same date and time,
one of two entrys gets into the database ok, but no message appears, so appt
that did not make it just gets lost. How do we get some message to work like
'another user is editing now'? Thanks.

Reply to this Message

ChrisJ - 27 Oct 2004 04:13 GMT

You don't really give enough info to pinpoint the problem.
Assuming you are writing new rows in a table that has a unique key on person
and time period, and two users are trying to create the same key
concurrently, you should get a "duplicate key" error on the second write.
Are you using the dbFailOnError options constant?

Reply to this Message