执行插入语句 cnnmoney.Execute sqlmoney 时系统说“至少一个参数没被指定值”,但参数都是13个啊!
sqlmoney = "insert into 费用表(用户代码,日期,底度,电度,基本电费,力率电费,附加电费,线路代码,用户类型,用户类型2,比例,片区代码,倍率) " & _
" select 用户代码,'" & DTPicker1.Value & "'," & Trim(Text4.Text) & "," & dian & "," & Trim(Text6.Text) & "," & Trim(Text8.Text) & ", " & Trim(Text7.Text) & ", " & _
" 用户表.线路代码,用户表.类型代码,用户表.类型代码2,比例,用户表.片区代码,用户表.倍率 from 用户表 where 用户代码='" & Trim(Text9.Text) & Trim(Text1.Text) & "'"
'sqlmoney = "insert into 费用表(用户代码,日期,底度,电度,基本电费,力率电费,附加电费,) values ('" & Trim(Text9.Text) & Trim(Text1.Text) & "','" & DTPicker1.Value & "'," & Trim(Text4.Text) & "," & dian & "," & Trim(Text6.Text) & "," & Trim(Text8.Text) & ", " & Trim(Text7.Text) & ")"
If cnnmoney.State <> adstatedclosed Then cnnmoney.Close
cnnmoney.Open str
cnnmoney.Execute sqlmoney
cnnmoney.Close