Thank you Razzak. Ended up having to restart the server...it appears that is what caught up the process somehow.
Tom -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Wednesday, April 06, 2011 1:50 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Lock Challenge At 01:32 PM 4/6/2011, Tom Eldred wrote: >What I need to know is how to get rid of the table lock? Tom, Without knowing all details, try the following test: At the R> prompt: DISCONNECT SET MULTI OFF CONNECT dbname DISCONNECT SET MULTI ON CONNECT dbname LIST TABLES In addition, you may also take advantage of new (CHKCUR('cursorname')) function. CHKCUR function checks to see if a cursor is declared and is not dropped. The function returns an integer value of 1 if the name exists and is not dropped, and 0 if it is not declared or dropped. You may also use (GETVAL('GetLock','tableviewname')). GetLock is the first required parameter and the table/view name is the name of the table or view. Use this function to programmatically find the LOCK status of a table or view. The returning value is ON or OFF, depending on whether a lock is in place upon the table/view. Example: SET VAR vCheclLock = (GETVAL('GetLock','Customer')) vCheckLock will return the value of ON or OFF for the Customer table. Hope that helps! Very Best R:egards, Razzak.
