SQL Server UPDATE and DELETE

[Jeff Carlin]

I'm new to the VB/SQL Server world and am having the following problem:

I get timeouts when executing either UPDATEs or DELETEs. INSERTs work fine.

Here's the code ("PROJ_DB" is the connection):

g_sSQL = "UPDATE tblRefI SET strType='A',sngRefI=1.23 WHERE strType='A';"
PROJ_DB.Execute g_sSQL, , adCmdText

and

g_sSQL = "DELETE FROM tblRefI WHERE strType='X';"
PROJ_DB.Execute g_sSQL, , adCmdText

and

g_sSQL = "INSERT INTO tblRefI (strType,sngRefI) VALUES('A',123);"
PROJ_DB.Execute g_sSQL, , adCmdText

If anyone can help, I'd really appreciate it. Thanks.

[Vit]

If you don't need to return records bask after update/delete, try to set parameter RecordsAffected=none in execute statement. This will reduce time needed for executing the query and maybe it will help

[Jeff Carlin]

Vit:

Thanks. I should mention that the table I'm testing my code on is a maintenance table with only 5 records.

Could it have something to do with the WHERE phrase??

[Vit]

No, it's a correct syntax

[Bigley]

Really the correct syntax for comparing strings in SQL is where
mythingy like 'A'
as opposed to
mythingy = 'A'
but I can't see that it would make a difference to what you are doing here......