[求助]如何判断SQL语句是否有效执行
用vb+ACCESS
如何判断执行一次Sql语句是否成功?是否有相关的返回值?
代码:
Set Conn = New ADODB.Connection
Set RS1 = New ADODB.Recordset
SqlStr = "update gid set G_ID='6' where g_num= 7" (gid是表名,g_id&g_num是属性)
Conn.Open ConStr
RS1.Open SqlStr, Conn