Re: Lock is Always Free

2007-09-17 Thread Baron Schwartz
Hi, John Comerford wrote: Hi Folks, My problem is that the IS_FREE_LOCK always returns true. I have done some testing with two instances of the Query Browser running. In one I execute: SELECT GET_LOCK('testing',10) > 1 In the second I execute : SELECT IS_FREE_LOCK('testing'); > 1 Ma

Lock is Always Free

2007-09-13 Thread John Comerford
Hi Folks, I am having problems trying to use the GET_LOCK and IS_FREE_LOCK commands. I am trying to put together a queue manager. The theory is that is would scan for queues, check for a lock and if the lock if free then start the queue. When the queue process starts it should use GET_LOCK