SDAC - No Locking because of granularity

[Alex Schickel]

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.

[Alex Schickel]

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.

[azyk]

Glad to see you have found the reason of the problem. If any other questions come up, please contact us.