John
Thank you for your response I CHANGED ALL OF THE UPDATES INTO ONE AS YOU SUGGESTED, THE EEP STILL WORKS ONLY WITH 1 USER. I LOOKED INTO THE CONFIGURATION SETTINGS ON THE MULTI USER TAB I NOTICED THAT BOTH COMPUTERS HAVE THE SAME USERID? Could this be part of my problem? I also looked at' from the edge' ,I was unable to see the file but there is a page(222) that deals with clearing stubborn table locks. Right know we cannot use the multi user and have resorted to running in single user mode which works fine but we have to take turns I will gladly pay for a support package ,let me know the cost but I really need to resolve this problem. Thanks again Mike From: [email protected] [mailto:[email protected]] On Behalf Of John Minyo II Sent: Monday, April 09, 2012 8:54 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: MULTI USER PROBLEMS At 07:54 PM 4/8/2012, mike epstein sony viao office wrote: Dave: There is a button on the form that updates a few tables and exits from the form. If there is another user connected to the database when the 'save and exit' button's eep has run then the form will not respond and the option to exit the program on is the only solution . It is then that some of the updated tables become locked and the user count increases. Which requires both users to exit the program to clear. I would love to blame it on 'network issues' but I really think it is an rbase issue . This is the eep of the 'save and exit button . SET TRACE Off SET MESSAGES OFF SET ERROR MESSAGES On SET NULL -0- UPDATE scratchpd SET callfrom = .vcf WHERE jidcode = .vjcd AND dtcall = .#DATE UPDATE scratchpd SET jphone = .vjph WHERE jidcode = .vjcd AND dtcall = .#DATE UPDATE scratchpd SET wkphone = .valtph WHERE jidcode = .vjcd AND dtcall = .#DATE UPDATE scratchpd SET ampmprom = .vamp WHERE jidcode = .vjcd AND dtcall = .#DATE UPDATE scratchpd SET tmcall = .#TIME WHERE jidcode = .vjcd AND dtcall = .#DATE UPDATE scratchpd SET typbill = .vtycode WHERE jidcode = .vjcd AND dtcall = .#DATE UPDATE scratchpd SET dteprom = .vdtprom1 WHERE jidcode = .vjcd AND dtcall = .#DATE UPDATE scratchpd SET svcneed = .svcmo WHERE jidcode = .vjcd AND dtcall = .#DATE UPDATE scratchpd SET tidcode = .vtd WHERE jidcode = .vjcd AND dtcall = .#DATE IF vdtprom1 = .vdtprom1 THEN UPDATE scratchpd SET flag2 = 't' WHERE flag2 IS NULL AND dteprom = .#DATE ENDIF SET NULL ' ' closewindow SET TRACE OFF This routine saves all the data that is updated and closes the form ...ONLY WHEN THERE IS ONLY 1 USER CONNECTED TO THE DATABASE How would power management settings affect the form? Neither of the computers have been reset. Mike, You can decrease the number of times R:BASE will access the "scratchpd" table by combining the UPDATE commands into one command. SET TRACE OFF SET MESSAGES OFF SET ERROR MESSAGES ON SET NULL -0- UPDATE scratchpd SET callfrom = .vcf, jphone = .vjph, + wkphone = .valtph, ampmprom = .vamp, tmcall = .#TIME, + typbill = .vtycode, dteprom = .vdtprom1, svcneed = .svcmo, + tidcode = .vtd WHERE jidcode = .vjcd AND dtcall = .#DATE IF vdtprom1 = .vdtprom1 THEN UPDATE scratchpd SET flag2 = 't' WHERE flag2 IS NULL AND dteprom = .#DATE ENDIF SET NULL ' ' CLOSEWINDOW SET TRACE OFF Check for duplicate or unneeded indexes for the "jidcode" and "dtcall" columns. Also, if no index is defined, add it if needed. By increasing the speed of the form EEP, you will decrease the chances in which users will update the table columns at the same time. Best regards, John Minyo II R:BASE Technologies, Inc. Customer Service
