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 From: [email protected] [mailto:[email protected]] On Behalf Of Dave McCann Sent: Sunday, April 08, 2012 4:34 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: MULTI USER PROBLEMS Mike: Does the "not responding" error occur every time the user exits the form or after its been open for awhile? I had a somewhat similar issue where one workstation's power management settings were ultimately at fault - make sure nothing powers down after a period of time. My main menu form would come up "not responding" after a period of inactivity and changing the power settings solved it. On 4/8/2012 10:20 AM, mike epstein sony viao office wrote: It has been a while since I have posted on this list . I am hoping someone could help me with a problem. In a multi user enviorment with the rx1-4 files on a remote computer, and with 2 users, there are a number of forms that I have used for 3 or 4 years in an application That no longer work. On exit of the form the form will signal the 'not responding' the little blue circle churns and the 'rbase extreme 9.1 ' message is displayed. When I ' close the program' and then restart the rbase application there are a number of table locks and when using the 'list' command the number of users is over 2 . This problem only occurs when 2 users are logged on . Even when one of the 2 are just connected to the database with the external form idle. My settings are multi on staticdb on writechk off qualcols 2 rowlocks on wait 4 refresh 0 interval 5 Mike Epstein [email protected] -- Dave McCann Classic Micro Systems
