[RBASE-L] - Re: Remote Lock

[David M. Blocker]

Karen   Any of these commands could cause it   UPDATE tablename INSERT into tablename DELETE rows from tablename EDIT colnames FROM tablename DECLARE CURSOR FOR tablename   You need to trap after any command like this by checking the error varaible to see if the command failed - if so, you need to decide how to write the code - by looping until it succeeds, or telling the user the problem and letting them decide if they want to try again, etc.   David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: [EMAIL PROTECTED] To: RBASE-L Mailing List Sent: Wednesday, September 01, 2004 4:58 PM Subject: [RBASE-L] - Remote Lock Using RBWin 6.5 What commands will cause a "remote lock" on a table, rather than a "row lock".  In this app there aren't any "set lock" commands that I'm aware of.  This happens pretty often on a table that has tons of complicated computed columns (not my design!), and while the remote lock is on, inserts into the table fail.  The remote lock usually clears up in 30 seconds or so.   There are Citrix users on the database, if this makes a difference. Karen