Recent content by Nesster

Here's how I use the WITH(NOLOCK): SELECT * FROM PUB.QuoteDtl WHERE PUB.QuoteDtl.Company = 'company' AND PUB.QuoteDtl.QuoteNum = 'QuoteNum' AND PUB.QuoteDtl.PartNum = 'PartNum' WITH(NOLOCK) We are at the same point in handling the error, if comes the situation where the record is locked by...

Hi, I looked around quite a bit for this and haven't been able to find the answer. I'm looking for a clean way to handle table locks when attempting to write via ODBC. I'm using VB.Net (Visual Studio 2008), Datadirect 4.10 SQL92 9.1E ODBC driver, on a 9.1E DB (Win32). I know the tricks for...