I made the change to add it to the following.
iNoOfRunning = CInt(oDB.GetDataValue("SET LOCK MODE TO WAIT; select count(*) from Scheduler where LastRunStatus='R' and TaskType='C'"))
i get an error -555...
-555 Cannot use a select or any of the database statements in a multi-query...
I have an error -244 that causes a VB app to stall.
-244:Could not do a physical-order read to fetch next row
I have read many docs and most thing point to using SET LOCK MODE TO WAIT. I interpret this as an SQL statement. Having never used this before how should I include this in the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.