sql = "select id,origin,supplier,invoice_name,receiving_date,invoice_no,cbl1,cbl2,so,fcr,hbl,consignee,department,product,etd,due_date,container_no,container_size,quantity,charge_item,charge_code,unit_price,invoice_amount,due_amount,no_vat,currency,cus_uid,status,remark,po,item,po_amt,com1,fact_code from dbo.invoice where 1=1 "
sql = sql & " and id in (" & ids & ")"
data.Open sql, cnn
这个是SQL代码,我定义ids为String类型,然后把PO number赋值给了ids,PO number是一个从数据库里面查询得出来的10位数的数字(比如1111111111).
然后选择报错...
求解答阿
------解决方案--------------------
把数据类型显式转换成varchar(10)