sql 求救 高手帮帮忙

Simpsons

Dim qry_edit As String = "UPDATE CommissionRate set isdeleted =  '" & isdeleted & "', createdlastediteddate = '" & strcreatedlastediteddate & "', createdlasteditedby = '" & strcreatedlasteditedby & "' where vehicle_plate = '" & Me.Vehicle_PlateComboBox1.Text & "' and code = '" & Me.CodeComboBox1.Text & "'"

请高手帮忙看看这个 syntax 有什么 error ?

兔仙人

什么 exception message

where vehicle_plate = '" & Me.Vehicle_PlateComboBox1.Text & "' <--- 这里吗 ？

chrizyuen2

Dim qry_edit As String = "UPDATE CommissionRate set isdeleted =  '" & isdeleted & "', createdlastediteddate = '" & strcreatedlastediteddate & "', createdlasteditedby = '" & strcreatedlasteditedby & "' where vehicle_plate = '" & Me.Vehicle_PlateComboBox1.Text & "' and code = '" & Me.CodeComboBox1.Text & "'"
Simpsons 发表于 1-7-2011 04:30 PM

眼力要好,不然就学排版...

doktorkoo

Dim qry_edit As String = "UPDATE CommissionRate set isdeleted =  '" & isdeleted & "', createdlastedi ...
Simpsons 发表于 1-7-2011 04:30 PM

建议用 sql parameters 方式来做吧，对我来说，你的方式看了很晕，要花时间去看每个符号，很费时

geekman

没头没脑的，又不知道你的Error Message，又不知道你的Data Type，如何判断？再说你的SQL Statement有写到这样乱，叫人怎么有心情去跟你一个一个慢慢辨识？SQL Statement出现error不一定是Syntax有错，有时你配对的Data的Data Type不对也会显示Syntax Error的。

ckbseng

其次的方法就是用debug mode 来拿它“qry_edit ” 的value，会比较用一看
然后把它paste去management studio的query 里实行，有问题的话他会给你知道是什么问题的