程序代码如下: Dim strSql As String strSql = " UPDATE T_TaskFee SET "
strSql &= " FeeDate = '" & dateFeeDate & "'"
strSql &= ", UserId = '" & strUserId & "'"
strSql &= ", KeyFeeType = " & intKeyFeeType
strSql &= ", FeeSum = " & dblFeeSum
strSql &= ", Re= '" & strRe & "'"
strSql &= " WHERE [Key]=" & intKey Try
rs.RunSQLUpdate(strSql)
Catch e As Exception
Throw New MyException(e)
End Try执行时报错:
2004-11-10 10:58:50 Exception at cn.com.LT.DataAccess.RunSql.RunSQLUpdate(String& sSqlUpdate, SqlParameter[] parameters) in D:\tms\DataAccess\RunSql.vb:line 75
at cn.com.LT.EntityManager.BaseEntity.E_WorkSheetFee.updateWorkSheetFee(DataTable dtbCondition) in D:\tms\EntityManager\BaseEntity\E_WorkSheetFee.vb:line 255 - 将截断字符串或二进制数据。
语句已终止。这个问题是为什么出现的啊?
strSql &= " FeeDate = '" & dateFeeDate & "'"
strSql &= ", UserId = '" & strUserId & "'"
strSql &= ", KeyFeeType = " & intKeyFeeType
strSql &= ", FeeSum = " & dblFeeSum
strSql &= ", Re= '" & strRe & "'"
strSql &= " WHERE [Key]=" & intKey Try
rs.RunSQLUpdate(strSql)
Catch e As Exception
Throw New MyException(e)
End Try执行时报错:
2004-11-10 10:58:50 Exception at cn.com.LT.DataAccess.RunSql.RunSQLUpdate(String& sSqlUpdate, SqlParameter[] parameters) in D:\tms\DataAccess\RunSql.vb:line 75
at cn.com.LT.EntityManager.BaseEntity.E_WorkSheetFee.updateWorkSheetFee(DataTable dtbCondition) in D:\tms\EntityManager\BaseEntity\E_WorkSheetFee.vb:line 255 - 将截断字符串或二进制数据。
语句已终止。这个问题是为什么出现的啊?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货