Mike, Larry, Marc and others, In our business we provide support services for many people with very involved medical and/or behavioral histories and records are very text heavy. Forms all have the usual demographic fields and text note spaces. The text notes are the issues.
I had not used MDI since we simply had no conflicts while developing the database. What you don't see, you do not know, and that's what bites you. Think we are going to work on the lockout concept and start exploring MDI in detail. Thanks to all of you. 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 MikeB Sent: Monday, July 07, 2008 12:41 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Multi users updating the same fields In these instances, I don't believe I would edit bound data. You could land on the row with a bound field so you would get the notices of the activity (if any) of another user, but do you Edit in a MDI form populated with the appropriate edit control, giving yourself the advantage of seeing yours and (if any) theirs before doing an update on the row of data. ----- Original Message ----- From: "Tom Frederick" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[email protected]> Sent: Monday, July 07, 2008 11:27 AM Subject: [RBASE-L] - Re: Multi users updating the same fields 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.
