求助为什么提交数据到数据库时,身份证号若带X弹出下图提示,不带X时可以正常提交。谢谢
代码如下:
AdoCmd.CommandText = "CREATE TABLE " & Database & _
" (序号 text(3),录入时间 datetime,报销年份 INTEGER,报销月份 INTEGER,定点医疗机构名称 text(50),单位名称 text(50),医保卡号 text(12)," & _
"姓名 text(8),性别 text(2),年龄 text(2),就诊日期 datetime ,出生年月 datetime ,身份证号 text(18),病种名称 text(50),类别 text(10)," & _
"本年度慢性病就诊次数 INTEGER,前期帐户余额 real,当前帐户余额 real,上次范围内费用累计 real,本年范围内费用累计 real,本年范围内大病范围内费用累计 real," & _
"甲类药费 real,自费药品 real,超范围 real,医疗费用总额 real,起付标准支付金额 real,统筹基金支付金额 real," & _
"个人帐户支付金额 real,个人支付金额 real,大病求助基金支付金额 real)"
AdoCmd.Execute , , 1 'adCmdText
Set AdoCmd = Nothing
Set AdoxCat = Nothing
Set AdoConn = Nothing
- strSql = " insert into " & Database & " values(" & [B2] & ",#" & [D2] & "#," & [F2] & ",'" & [F3] & "','" & [B3] & "','" & [B4] & "','" & [F4] & "','" & _
- [B5] & "','" & [D5] & "','" & [F5] & "',#" & [B6] & "#,#" & [D6] & "#,'" & [F6] & "','" & [B7] & "','" & [F7] & "','" & _
- [B8] & "','" & [D8] & "','" & [F8] & "','" & [B9] & "','" & [D9] & "','" & [F9] & "','" & _
- [B10] & "','" & [D10] & "','" & [F10] & "','" & [B11] & "','" & [D11] & "','" & [F11] & "','" & _
- [B12] & "','" & [D12] & "','" & [F12] & "')"
复制代码
|