Hi Razzak Does the below have anything to do with getting Multi Off sometimes ??
Mohammed Sattar Utah Group of Companies -----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. ================================================
