表 统计信息有一个姓名字段和12个货币字段,用来存放12个的月的收入,类型为Currency,需要将一个名字和12个货币用sql语句插入到表中,这条sql语句如何写:
部分代码如下:
Dim cN As New adodb.Connection
cN.Open "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source= " & filename
Dim Mon(1 To 12) As Currency
然后将Mon(1)toMon(12)赋值
INSERTSQL = "insert into 统计信息(XM,JAN,FEB,MAR,APR,MAY,JUN,JUL,AUG,SEP,OCT,NOV,DEC) values('张三'"+
接下来该如何写(需把12个变量值插入到表中)?
就算后面加上12个0,即+"0,0,0,0,0,0,0,0,0,0,0,0)" vb报告的错误为INSERT INTO语法错误?如何解决呀?
谢谢
部分代码如下:
Dim cN As New adodb.Connection
cN.Open "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source= " & filename
Dim Mon(1 To 12) As Currency
然后将Mon(1)toMon(12)赋值
INSERTSQL = "insert into 统计信息(XM,JAN,FEB,MAR,APR,MAY,JUN,JUL,AUG,SEP,OCT,NOV,DEC) values('张三'"+
接下来该如何写(需把12个变量值插入到表中)?
就算后面加上12个0,即+"0,0,0,0,0,0,0,0,0,0,0,0)" vb报告的错误为INSERT INTO语法错误?如何解决呀?
谢谢
解决方案 »
- cBottons和dwextraInFo参数是什么意思
- 已经知道按钮的句柄,如何判断此按钮是否被按下?
- 桌面项目弹出“提示操作框框”
- 如何用VB编写DLL ,(仅用于VB的调用)?
- 调用WaitForSingleObject问题
- 关于mschart的一个很难的问题
- 第二问[学习vb数载仍有数个问题从初学至今没有答案,不知各位高手大虾有谁知道]
- 关于跨表查询.急
- 关于EtCell的问题
- 数组大小的问题,是否影响程序的正常运行?
- 我的软件有Media Player 9.0控件,怎么样可以,在不安装Media Player 9.0时使用,我打包的时候要怎么做
- 求两个经典的VB源代码, 规模大小与 foxmail3.0 之类的软件差不多就行了, 就好试过可以才给网址
我的意思是要给12个货币变量值进去,而且我试验了一下就是加了12个0也不对!
INSERTSQL = "insert into 统计信息(XM,JAN,FEB,MAR,APR,MAY,JUN,JUL,AUG,SEP,OCT,NOV,DEC) values(" _
& "'" & "张三" & "'" _
& "," & Val(txtJan.Text) _
& "," & Val(txtFeb.Text) _
& "," & Val(txtMar.Text) _
& "," & Val(txtApr.Text) _
& "," & Val(txtMay.Text) _
& "," & Val(txtJun.Text) _
& "," & Val(txtJul.Text) _
& "," & Val(txtAug.Text) _
& "," & Val(txtSep.Text) _
& "," & Val(txtOct.Text) _
& "," & Val(txtNoV.Text) _
& "," & Val(txtDec.Text) _
& ")"