When I try to lock a record (LockMode = Pessimistic) I get the Error message
---------------------------------------------------
Exception Class EMSError "the Row-Granularity hint for the table can't be used because lock are not allowed with the mentioned granularity..."
(It's roughly translated from the german message)
How can I avoid this error?
brgds. alex.
SDAC - No Locking because of granularity
-
- Posts: 3
- Joined: Tue 27 Mar 2007 13:30
- Location: Germany/Birkenfeld
-
- Posts: 3
- Joined: Tue 27 Mar 2007 13:30
- Location: Germany/Birkenfeld
Re: SDAC - No Locking because of granularity
Changing my Database from my beloved Advantage Database Server to MS SQL-Server I was not aware that when EMS SQL Manager creates an index it uses the parameters:
......
ALLOW_ROW_LOCKS = OFF,
ALLOW_PAGE_LOCKS = OFF
.....
as a default. You have to allow the locking otherwise you get the granularity error.
brgds. alex.
......
ALLOW_ROW_LOCKS = OFF,
ALLOW_PAGE_LOCKS = OFF
.....
as a default. You have to allow the locking otherwise you get the granularity error.
brgds. alex.
Re: SDAC - No Locking because of granularity
Glad to see you have found the reason of the problem. If any other questions come up, please contact us.