Not likely, Mohammed
Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Mohammed Sattar Sent: Sunday, January 12, 2014 5:49 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Tip of the Day: AUTOMUMbering in aMulti-User Environment Hi Razzak Once in a while we get this error "Multi Off" especially when there are many users logged in Then we need to logoff all users and the error goes away I was wondering if changing the SET WAIT and SET INTERVAL would help ? thanks Mohammed Sattar Utah Group of Companies -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Saturday, January 11, 2014 9:54 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Tip of the Day: AUTOMUMbering in aMulti-User Environment At 05:46 AM 1/11/2014, Mohammed Sattar wrote: >Hi Razzak >Does the below have anything to do with getting Multi Off sometimes ?? Mohammed, Not that I personally know of. However, I suggest to carefully review all sections of your application for key word, such as "MULTI", that may have been used to SET MULTI OFF when performing any system maintenance, etc. Database Explorer | Forms ... [Ctrl] + A to select all forms [Ctrl] + F to Find in Form Custom EEPs Database Explorer | External Forms ... [Ctrl] + A to select all external forms [Ctrl] + F to Find in External Form Custom EEPs Database Explorer | Command Files ... [Ctrl] + A to select all files [Ctrl] + F to Find in Files Hope that provides you with some blue's clues ... Please feel free to reach out to me with further questions. Very Best R:egards, Razzak >-----Original Message----- >From: [email protected] [mailto:[email protected]] On Behalf Of A. >Razzak Memon >Sent: Tuesday, December 31, 2013 12:44 AM >To: RBASE-L Mailing List >Subject: [RBASE-L] - Tip of the Day: AUTOMUMbering in a Multi-User >Environment > >Monday, December 30, 2013 > >Tip of the Day: AUTOMUMbering in a Multi-User Environment >Product.: R:BASE eXtreme 9.5 (32/64) >Build...: 9.5.3.21205 or higher www.rupdates.com >Keywords: Commands, Settings > >In a typical multi-user, multi-session environment, you may notice the >resource conflict or I/O -ERROR- when resources are not available, >mainly from trying to get a lock on the SYS_DEFAULTS table to update >the AUTONUM values. > >Did you know that by increasing the setting for WAIT and INTERVAL in a >multi-user, multi-session environment can reduce the instances of >resource conflicts? > >You can still get a resource not available message, but the chances of >getting it can be reduced by increasing the value for WAIT from 4 >(default) to something larger. > >SET WAIT sets the minimum number of seconds to retry the last requested >resource (a table or database) before halting execution. Rather than >aborting execution, SET WAIT allows you to set a length of time for >R:BASE to keep trying to access a resource. A message is displayed >showing the approximate percentage of wait time remaining. > >If you do not run a SET WAIT command, R:BASE automatically retries the >locked resource for approximately four seconds before issuing a retry >message. > >You can also adjust the INTERVAL in which R:BASE tries the command >during the SET WAIT period. The SET INTERVAL command specifies the time >to elapse before R:BASE retries the command that caused a conflict >within the waiting period. > >The upcoming update of R:BASE eXtreme 9.5 (32/64), Update 4 in 2014, >includes more enhancements related to the resource not available and >I/O >-ERROR- in a multi-user, multi-session environment that loops adding >rows with Autonumbered columns. > >Alternatively, in a multi-user, multi-session, and/or on-line R:BASE >applications using a common database, you may also take advantage of >(NEXT(tblname,autonumcol)) function. > >A sample application is available to demonstrate the use of such >feature in R:BASE eXtreme 9.5. > >Sample Applications: http://www.razzak.com/sampleapplications/ > >Application Title: >Understanding R:BASE (NEXT(tblname,autonumcol)) Function > >Date Posted: 06/27/2013 > >Have Fun! > >Very Best R:egards, > >Razzak. > >www.rbase.com >www.facebook.com/rbase >www.RazzakMemon.com --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
