I was suprised to find the problem form was based on a simple two table view ( I thought I never based forms on a view). I re-wrote the form driving it from the table directly using lookup vars (to get the customer's name) instead of the view. Problem has not returned, even with eight people editing the same table at the same time. My theory is that the view added unnecessary complexity which occassionaly confused RBase's locking scheme when several users where editing with this view based form. Kenny Camp IT Manager Electro Enterprises, Inc. > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On > Behalf Of A. Razzak Memon > Sent: Tuesday, August 21, 2001 4:20 PM > To: [EMAIL PROTECTED] > Subject: Re: Internal Lock Error message - Razzak's Reply > > > > Kenny, > > In a Multi-User environment, you may want to look into > > the following very specific settings: > > 01. SET FASTLOCK > 02. SET INTERVAL > 03. SET LOCK > 04. SET MULTI > 05. SET NAME > 06. SET REFRESH > 07. SET VERIFY > 08. SET WAIT > > SET FASTLOCK removes table lock for faster multi-user > performance. > > SET INTERVAL specifies time before retrying a command. > > SET LOCK confines table updating to a single session > when operating in multi-user mode. > > SET MULTI specifies for R:BASE to operate in > multi-user > mode. > > SET NAME overwrite the name defined in RBASE.CFG file > > SET REFRESH sets how often a form data entry screen is > > refreshed. > > SET VERIFY verifies editing changes by row or column > in multi-user mode. > > SET WAIT specifies the wait period for access to a > shared resource in multi-user mode. > > Last but not least, I highly recommend to RELOAD! > > If you more details, feel free to send me a private > e-mail. > > Good Luck! > > Very Best Regards, > > Razzak. > > At 03:40 PM 8/21/2001 -0500, Kenny Camp wrote: > > >Questions: > > > >1. What exactly causes this? Two users on same > row, same column? > > > >2. Is there any real problems here or does RBase > resolve the lock problem on its own? > > > >3. Should I demand (again) that they follow the > message and get all 35 users out of the DB? > (They hate this.) > > > >4. Is there some way to work around this? > > > > > > > __________________________________________________ > Do You Yahoo!? > Make international calls for as low as $.04/minute with Yahoo! Messenger > http://phonecard.yahoo.com/ >
