Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. kevinrm

    How to use SET LOCK MODE TO WAIT

    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...
  2. kevinrm

    How to use SET LOCK MODE TO WAIT

    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...

Part and Inventory Search

Back
Top