Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 5 of 5 total
Thread Multiuse RecordIsLocked ?
Fri, Nov 13 2009 1:51 PMPermanent Link

Charalampos Michael
Hello,
  Is RecordIsLocked multi-user because when i open another instance
  of the application it returns "false" even if it's locked by the
  first instance using "LockCurrentRecord".

Thank you

btw, using Unicode edition.
--
Charalampos Michael - [Creation Power] - http://www.creationpower.gr
Mon, Nov 16 2009 3:46 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Michael,

<< Is RecordIsLocked multi-user because when i open another instance of the
application it returns "false" even if it's locked by the first instance
using "LockCurrentRecord". >>

No, it only indicates whether the current session has the row locked.  You
can use the ServerSessionLocks table:

http://www.elevatesoft.com/manual?action=mantopic&id=edb2sql&category=3&topic=51

to look for locks placed by other sessions.

--
Tim Young
Elevate Software
www.elevatesoft.com

Mon, Nov 16 2009 5:35 PMPermanent Link

Charalampos Michael
Dear Tim,

> << Is RecordIsLocked multi-user because when i open another instance of the
> application it returns "false" even if it's locked by the first instance
> using "LockCurrentRecord". >>
>
> No, it only indicates whether the current session has the row locked.  You
> can use the ServerSessionLocks table:
>
> http://www.elevatesoft.com/manual?action=mantopic&id=edb2sql&category=3&topic=51
>
> to look for locks placed by other sessions.

Thanks!


--
Charalampos Michael - [Creation Power] - http://www.creationpower.gr
Mon, Nov 16 2009 5:49 PMPermanent Link

Charalampos Michael
Dear Tim,

>> << Is RecordIsLocked multi-user because when i open another instance
>> of the application it returns "false" even if it's locked by the first
>> instance using "LockCurrentRecord". >>
>>
>> No, it only indicates whether the current session has the row locked.  
>> You can use the ServerSessionLocks table:
>>
>> http://www.elevatesoft.com/manual?action=mantopic&id=edb2sql&category=3&topic=51
>>
>> to look for locks placed by other sessions.

A silly question. How can access "ServerSessionLocks" table ? Smile

--
Charalampos Michael - [Creation Power] - http://www.creationpower.gr
Mon, Nov 16 2009 10:45 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Michael,

<< A silly question. How can access "ServerSessionLocks" table ? Smile>>

Just open it using a TEDBTable component, with the DatabaseName set to the
"Configuration" database.  This is C/S only, so it won't work with a local
session.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image