Could you have On Exit EEP from the note field that Checks Dirty Flag PROPERTY <ComponentID> CopyToClipboard 'TRUE' ......
That way you can save your text and compare it to the other users changes. It might work but I have not tried it yet, you might need to use a Bit Button to Save then Exit compared to clicking the X Marc ----- Original Message ----- From: Ben Petersen To: RBASE-L Mailing List Sent: Monday, July 07, 2008 11:06 AM Subject: [RBASE-L] - Re: Multi users updating the same fields "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.
