Author Topic: slSetRelNamedLocks  (Read 103 times)

Fim

  • Guru
  • ***
  • Posts: 108
    • View Profile
    • Fims sajt
slSetRelNamedLocks
« on: June 17, 2017, 08:13:48 AM »
How to avoid slSetRelNamedLock displaying an error message?
I will only have a ReturnCode -11, no display.
Code: [Select]
    SlSetProcessMods ("E0")
    SVAR = slSetRelNamedLocks("+" + PA_NR_X)
    MSGBOX "SVAR=" + STR$(SVAR)

Fredrick Ughimi

  • Master Geek
  • ****
  • Posts: 473
    • View Profile
    • Software Development Company
Re: slSetRelNamedLocks
« Reply #1 on: June 17, 2017, 01:11:09 PM »
Hello Fim,

>>I will only have a ReturnCode -11, no display.

As per the document %SQLitening_LockTimeout  = -11 - Timeout occurred trying to lock an object or database

Check Frank W. Kelley comments here:

http://sqlitening.com/support/index.php?topic=9391.msg24774#msg24774
Fredrick O. Ughimi

fughimi@yahoo.com
- Freedom lies in being bold -- Robert Frost, Poet

Fim

  • Guru
  • ***
  • Posts: 108
    • View Profile
    • Fims sajt
Re: slSetRelNamedLocks
« Reply #2 on: June 18, 2017, 06:19:06 AM »
In the version of SQLitening.Bas that I have, dated 24-Nov-2015 17:20, Frank's code is already inserted, but not Bern's correction.
And if I do the call as follows, I will not get a display of error message.
ANSWER = slSetRelNamedLocks ("+" + PA_NR_X, "E0", "", 0, "E0")

Thus, the problem is resolved.
Thanks for the help.
/Fim W