Con="Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=master;Data Source=.\WINCC"
Set conn = CreateObject("ADODB.Connection")
conn.ConnectionString = Con
conn.CursorLocation = 3
conn.Open
Set oRs = CreateObject("ADODB.Recordset")
Set oCom = CreateObject("ADODB.Command")
Set oCom.ActiveConnection = conn
oCom.CommandType = 1
oCom.CommandText = sSql
sSql="UPDATE Table1 Set Name = 7y7 WHERE Name='"&data21&"';"
oCom.CommandText = sSql
Set oRs = oCom.Execute
我现在想将字段Name为data21的名字修改成7y7 为什么就是修改不了呢 错在哪里呢 ？请大侠告知 很急啊