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
