再问SQL语言问题

直来直往　发表于：2007-12-17 23:19:17 　

下面这段代码怎么也写不对，请帮帮忙！

     DoCmd.RunSQL "UPDATE tblBoxTool SET cToolBox = '" & Me.cboBoxName & "'," & _
                                           "cToolName = '" & Me.txtToolName & "'," & _
                                           "nNumber =" & Me.txtToolName " & _
                                           "dDate =" & Me.txtDate " & _
                                     WHERE nToolID = "& Me.txtToolID"

一是单双引号掌握不好，而是换行该加那些字符不清楚。

以上包括了字符串变量，整型变量，dDate是日期/时间变量，

尤其要问日期/时间变量的单双引号如何加？

多谢各位

Top

直来直往发表于：2007-12-17 23:23:31

换行是在句首家",句末加" & _吗？

Top

竹笛发表于：2007-12-18 08:37:00

换行是在句首加 &,句末加 _

Top

直来直往发表于：2007-12-18 12:53:53

还是搞不定：

       DoCmd.RunSQL "UPDATE tblBoxTool SET cToolBox ='" & Me.cboBoxName & "'," _
                                         & cToolName ='" & Me.txtToolName & "'," _
                                         & nNumber =" & Me.txtNum, _
                                         & dDate ='" & Me.txtDate & "'," _
                                         & WHERE nToolID=" & Me.txtToolID

　　　dDate是时间／日期格式

　　　nNumber是整型

cToolName和cToolBox是字符串，该如何写上面这段代码啊？

Top

钱玉炜发表于：2007-12-18 13:28:53

DoCmd.RunSQL "UPDATE tblBoxTool SET cToolBox ='" & Me.cboBoxName & "'," _
                                         & " cToolName ='" & Me.txtToolName & "'," _
                                         & " nNumber =" & Me.txtNum, _
                                         & " dDate ='" & Me.txtDate & "'," _
                                         & " WHERE nToolID=" & Me.txtToolID

Top

总记录：4篇页次：1/1 9 1 :

Access交流中心

再问SQL语言问题