Also just do a LIST and look for locked tables. If you see one, try SET ROWLOCKS ON and note if that makes a difference.
Using ROWLOCKS ON will cause R:BASE to use row locks instead of a table lock, thereby reducing the opportunities for conflict. This is especially important in a multi user environment. If ROWLOCKS ON does make a difference, the next pursuit is to find what is leaving the orphaned lock on your table. Emmitt Dove Converting Systems Architect Evergreen Packaging, Inc. [email protected] (203) 214-5683 m (203) 643-8022 o (203) 643-8086 f [email protected] From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Thursday, November 11, 2010 09:24 To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Resources required by . . . Thanks for the suggestion, Karen. I will check my code and try to watch for this. The next time I get the message I will immediately do a "LIST CURSORS" command to see if there are any open ones. Thanks again. -- Mike From: [email protected] To: [email protected] (RBASE-L Mailing List) Date: 11/11/2010 09:11 AM Subject: [RBASE-L] - Re: Resources required by . . . Sent by: [email protected] _____ 99% of the time that I see this message it is because there is a cursor open on the table (type "list cursors" at the r> prompt). Maybe you ran a program that declared a cursor and never dropped it?? Karen It's strange because this morning, for instance, I updated values in one column and everything was fine. I then moved over a couple of columns to update some other values in another column and boom "Resources required . . .". Confidentiality Notice This message is intended exclusively for the individual or entity to which it is addressed and may contain privileged, proprietary, or otherwise private information. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message.
