Recent content by violetstarlight

A NativeError is returned. To check and see if a record is locked, I am checking for an error code 1222. per requirements, I have to use locking thru sql server and pessimistic locking for this specific functionality. The majority of the application is written to use client side cursors with...

I'm using SQL Server 7.0 and ado is connecting via OLE DB driver for SQL Server.

I was wondering if there was a way to get the process ID on a record that locked using VB. Allow me to explain more... I am using ADO, server side cursors, and pessimistic locking to lock a row when a user accesses it. If another user tries to access the record, I can capture the error to see...

...oh, and one thing is that the field erroring is the Message variable. And there are no quotes in it? The field contains text marked up with rich text formatting, but no quotes anywhere....

The code calling the stored proc is: sp = "InsertNewThread '" & _ ID & "', '" & _ DateTimeReceived & "', '" & _ From & "', " & _ SupplierID & ", '" & _ Subject & "', '" & _...

Why would a stored procedure error when called from VB using ADO but when the command text is entered into query analyzer, it would work correctly? VB returns an error about an unclosed quotation mark, that I can’t find anywhere in the statement. So I copied the command text and ran in query...

then my last question is.... is there a way to get the spid or other identifying info from the record that was initially locked to use they query that SonOfEmidec1100 presented?

This definately helps! Thank you!! one more question...is there a way to see who has the record locked?

I am familiar with the different kinds of lock types and cursor types. But how would I implement a client side cursor to lock a record? Wouldn't a client side cursor create a disconnected recordset and therefore, be unable to handle locking the record for all users of an app? it would only lock...

Bare with me because I am somewhat new to VB and ADO. Is there a way to lock a record in SQL Server using a client side cursor? I am trying to lock a record so that another user doesn't have access if someone else has it opened. I am currently using ADO with a server side cursor, with...

Have you rec'd any answer for this? Or did you find a solution? I have encountered the same problem. Thanks! Shaun

Hello all... is there a way to distinguish the format of an incoming email in outlook (thru visual basic, CDO references) or to, at the very least, simply convert the incoming text to rich text format (incoming mails could be in any format - rtf, plain text or html) Thanks! Shaun

I am new to FoxPro, so you'll have to excuse my lack of knowledge. Can you have more than one table open at a time? The program it's in uses tons of free tables for many diffrent purposes. It's about 12 years old and the programmer who wrote it is no longer with the company. My area of...

For what reasons would the following statement fail: USE("\\ServerName\FolderName\TableName") SHARED Troubleshooting an error that happens sporadically where an error is occuring and I'm not sure what that error is because it happens in the middle of the night (the calling program...

when you used CDO with exchange, did it pop the "another app is trying to send mail, are you sure" security pop up msg?