ADO connection.execute problem

[saddist]

Hello,

I have a problem with connection.execute statemant

Con.Execute("UPDATE table SET column = 'a'")

It does compile, but does not complete. It 'hangs' on this command and does nothing. No error no result.

Cheers,
sad

[debasisdas]

What is the tablename and the column name.

[saddist]

table name "table" column name "column".
What's the difference?

[QVeen72]

Hi,

Table is a Reserved Word..
So why name a Table name as "Table"...?

Regards
Veena

[debasisdas]

Try avoiding the restricted key words for naming purpose.

[saddist]

Ok so table name is "ttt" and column name is "ccc". Still this does not solve the problem.

[QVeen72]

Hi,

This is Update Table syntax:

"UPDATE Table MyTable SET MyColName = 'a' "

Regards
Veena

[debasisdas]

Does your condition satisfies in the database ?

[saddist]

Hi,

This is Update Table syntax:

"UPDATE Table MyTable SET MyColName = 'a' "

Regards
Veena

ummm...no?

What do you mean by condition?

[VBWheaties]

Hello,

I have a problem with connection.execute statemant

Con.Execute("UPDATE table SET column = 'a'")

It does compile, but does not complete. It 'hangs' on this command and does nothing. No error no result.

Cheers,
sad

It compiles because your syntax is correct. It doesnt complete because of something wrong with the data source.
I usually see hangs when I use a Sql Server that does not exist or is not online.

[saddist]

It compiles because your syntax is correct. It doesnt complete because of something wrong with the data source.
I usually see hangs when I use a Sql Server that does not exist or is not online.

Server exists and is online, becouse

Con.Execute("Select * from *")

works just fine.

[VBWheaties]

Server exists and is online, becouse

Con.Execute("Select * from *")

works just fine.

I've never seen SELECT * FROM * but i'm sure its got its merits somewhere.

For your Execute, you can pass in adAsyncExecute for your Execute option parameter and it will allow you to return immediately without waiting for the Update to complete.

   con.Execute("Update Table Set Field = 'value'", adCmdText, adAsyncExecute)
 

[debasisdas]

ummm...no?

What do you mean by condition?

Does your update query execute successfully at the backend outside VB ?