• Welcome, Guest. Please login.
 
August 19, 2019, 07:17:37 am

News:

Welcome to the SQLitening support forums!


slSetRelNamedLocks

Started by Fim, June 17, 2017, 10:43:48 am

Previous topic - Next topic

Fim

How to avoid slSetRelNamedLock displaying an error message?
I will only have a ReturnCode -11, no display.

    SlSetProcessMods ("E0")
    SVAR = slSetRelNamedLocks("+" + PA_NR_X)
    MSGBOX "SVAR=" + STR$(SVAR)

Fim W

Fredrick Ughimi

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<br /><br />fughimi@gmail.com<br />- Freedom lies in being bold -- Robert Frost, Poet

Fim

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
Fim W