"Append" would be a more elegant solution, but until then to get you by,
you could highlight and copy your work to the clipboard, answer no,
review the text changed by others, and if you want to over-write or
append the text you were working on, you could then paste your text from
the clipboard back to the form.
Ben
Tom Frederick wrote:
Razzak,
Many of the items in our database use text (1-5 paragraphs) that are
later used in larger, multi page text based reports. Multi users editing
the same text field at the same time has happened several times for us
with troubled outcomes. We tried the SET VERIFY ROW and SET VERIFY
COLUMN options and the "Data has been changed by Another User Since Last
Refresh. Do You Want to Save Changes" screen comes up as expected.
Trouble is I never see what the other person's edits until after the
fact.:
1. If I answer "Yes", I overwrite the existing info which may be
important to the person who wrote it. Their two paragraphs get
overwritten by my three words. I know edits can happen any time after a
field is saved. There seems to be a special irritation when it happens
while I am editing and I see my stuff go away because someone else is
editing the same field and saves before me. The refresh rate really
effects this issue. We set refresh to 0 because of the typing speed of
our users varies wildly.
2. If I answer "No", then my changes go away, the screen updates with
the edits done by the other person, and I have to start over. May not be
a big deal, but I still do not know what the other person wrote until
later particularly if we disagree.
Simple drop downs, short phrases, and any numerical data works great.
Multi paragraph text is a hassle due to writing time vs. refresh
rates/saves unless I lock a users out while someone is editing.
Is there a middle ground (Append, maybe?) where I can see what I am
saving against? Double clicking the field does bring up the Note/Blob
editor for my screen, but the other edits do not show until they get
saved to the table, which makes sense.
Tom Frederick
Elm City Center
1314 W Walnut
Jacksonville, IL 62650
Off - 217-245-9504
Fax - 217-245-2350
Email - [EMAIL PROTECTED]
Web - www.elmcity.org
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of A.
Razzak Memon
Sent: Monday, July 07, 2008 8:18 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Multi users updating the same fields
At 08:17 AM 7/7/2008, Marc Schluter wrote:
I always thought RBase did this automatically?.
Yes, R:BASE always handles the Concurrency Control automatically
to protect against data conflicts when more than one user edits
the same data at the same time.
For complete details, type HELP VERIFY at the R> prompt.
SET VERIFY ROW and SET VERIFY COLUMN tell R:BASE when to inform
you that someone else just changed the data you're currently
editing.
Very Best R:egards,
Razzak.
