我在一本书上看到了一段在datagrid上修改数据的代码,原代码可以使用,其中将更改后的值存入数据库中的一段是这么写的:
strSQL = "update hrinfo Set empname=" & strname & ","
strSQL = strSQL & "empcode=" & strcode & " where empno=" & strNo & ""
现在我的数据库中不止empname,empcode和empno这几个字段,我想继续写,该怎么做?我依据我的数据库写了strSQL = strSQL & "empsort=" & strsort & " where empno=" & strNo & ""
strSQL = strSQL & "empdepart=" & strdepart & " where empno=" & strNo & ""
这两句话,但是在修改时就出错了,我应该怎样继续下去?
改为:
strSQL = "update hrinfo Set empname=" & strname & ","
strSQL = strSQL & "empcode=" & strcode & ","
strSQL = strSQL & "empsort=" & strsort & ","
strSQL = strSQL & "empdepart=" & strdepart & " where empno=" & strNo & ""
一条sql语句只能有一个where子句