'Update the customer sequence No. & path according to the customer ID
Public Function updateCustomer(ByVal p_customer As customer) As Boolean
Dim sqlcmd As String
sqlcmd = "update Customer set sequence_no = " & p_customer.sequence_no & _
" , path = " & in_util.addQuote(p_customer.path) & _
" where customer_id = " & in_util.addQuote(Trim(p_customer.id))
MsgBox (sqlcmd)
Set db = OpenDatabase("", False, False, "ODBC;DSN=CTIDSN;UID=sa;PWD=;TIMEOUT=180")
db.Execute (sqlcmd)
db.Close
Set db = Nothing
updateCustomer = True
End Function上面的execute会alarm,大意说明不能update
刚接触VB,求教
Public Function updateCustomer(ByVal p_customer As customer) As Boolean
Dim sqlcmd As String
sqlcmd = "update Customer set sequence_no = " & p_customer.sequence_no & _
" , path = " & in_util.addQuote(p_customer.path) & _
" where customer_id = " & in_util.addQuote(Trim(p_customer.id))
MsgBox (sqlcmd)
Set db = OpenDatabase("", False, False, "ODBC;DSN=CTIDSN;UID=sa;PWD=;TIMEOUT=180")
db.Execute (sqlcmd)
db.Close
Set db = Nothing
updateCustomer = True
End Function上面的execute会alarm,大意说明不能update
刚接触VB,求教
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货