我在VB中
有一十六进制:strVehicleNo =“7F0000000010000000”
转换:ChangeVehicleNO = Chr(("&H" + Mid(strVehicleNo, 1,4)) + Chr("&H" + Mid(strVehicleNo, 5, 2)) + Chr("&H" + Mid(strVehicleNo, 7, 2)) + _
Chr("&H" + Mid(strVehicleNo, 9, 2)) + Chr("&H" + Mid(strVehicleNo, 11, 2)) + Chr("&H" + Mid(strVehicleNo, 13, 2)) + _
Chr("&H" + Mid(strVehicleNo, 15, 2))
得到:“ ”
SQL语句是:insert into businessrecord values( newid() ,' ','2003-08-06 18:47:52','2003-08-06 19:43:37',01.40,000.000,'005502',0018.90,000.000,'0000000000',0000.00,0000.00,0000,'010000',000.000,0000,'00000000',02)结果出现:Unclosed quotation before the character string ''.
但是我在SQL中执行此语句没问题。
数据库中是CHAR(18)
请问怎么处理?谢谢
有一十六进制:strVehicleNo =“7F0000000010000000”
转换:ChangeVehicleNO = Chr(("&H" + Mid(strVehicleNo, 1,4)) + Chr("&H" + Mid(strVehicleNo, 5, 2)) + Chr("&H" + Mid(strVehicleNo, 7, 2)) + _
Chr("&H" + Mid(strVehicleNo, 9, 2)) + Chr("&H" + Mid(strVehicleNo, 11, 2)) + Chr("&H" + Mid(strVehicleNo, 13, 2)) + _
Chr("&H" + Mid(strVehicleNo, 15, 2))
得到:“ ”
SQL语句是:insert into businessrecord values( newid() ,' ','2003-08-06 18:47:52','2003-08-06 19:43:37',01.40,000.000,'005502',0018.90,000.000,'0000000000',0000.00,0000.00,0000,'010000',000.000,0000,'00000000',02)结果出现:Unclosed quotation before the character string ''.
但是我在SQL中执行此语句没问题。
数据库中是CHAR(18)
请问怎么处理?谢谢
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货