1187
社区成员
请问为什么同一段语句在SQL SERVER里面就可以用，再VB里面就不能用呢？在线等
这是我VB里面的代码
cn.Execute "insert into customers(cust_usnm,cust_name, Cust_Pswd,Cust_IDCd,Cust_Birth,Cust_Add,Cust_Phone,Cust_MP,Cust_Zip,Cust_Email,cust_sex,cust_fav)values('" + txt_UserName + "','" + txt_RealName + "','" + txt_Pass + "','" + txt_Certificate + "','" + DTPicker_Brithday + "','" + txt_Address + "','" + txt_Tel + "','" + txt_MobelTel + "','" + txt_Post + "','" + txt_Email + "','" + sex + "','" + txt_Fax + "')"
这是我SQL里面的代码
USE PUBS
insert into customers(cust_usnm,cust_name, Cust_Pswd,Cust_IDCd,Cust_Birth,Cust_Add,Cust_Phone,Cust_MP,Cust_Zip,Cust_Email,cust_sex,cust_fav) values('VV','A','A', 'A','2003-3-30','A', 'A','A','A','A','F','A')
GO
我再VB里面也是添的这些东西，为什么SQL能通过，VB就不能通过呢？总是会说“类型不匹配”
大家帮帮忙啊
cn.Execute "insert into customers(cust_usnm,cust_name, Cust_Pswd,Cust_IDCd,Cust_Birth,Cust_Add,Cust_Phone,Cust_MP,Cust_Zip,Cust_Email,cust_sex,cust_fav)values('" + txt_UserName + "','" + txt_RealName + "','" + txt_Pass + "','" + txt_Certificate + "','" + DTPicker_Brithday + "','" + txt_Address + "','" + txt_Tel + "','" + txt_MobelTel + "','" + txt_Post + "','" + txt_Email + "','" + sex + "','" + txt_Fax + "')"
这是我SQL里面的代码
USE PUBS
insert into customers(cust_usnm,cust_name, Cust_Pswd,Cust_IDCd,Cust_Birth,Cust_Add,Cust_Phone,Cust_MP,Cust_Zip,Cust_Email,cust_sex,cust_fav) values('VV','A','A', 'A','2003-3-30','A', 'A','A','A','A','F','A')
GO
我再VB里面也是添的这些东西，为什么SQL能通过，VB就不能通过呢？总是会说“类型不匹配”
大家帮帮忙啊
...全文
当前发帖距今超过3年，不再开放新的回复
发表回复
cbzdream 2003-04-01
楼上说的对，你试试
watt 2003-04-01
in sql server '2003/01/01'
in access #2003/01/01#
do you know?
in access #2003/01/01#
do you know?
lxcc 2003-04-01
up
饮水需思源 2003-04-01
字符型变量的引用方法：'" & 变量名 & "'
数值型变量的引用方法：" & 变量名 & "
数值型变量的引用方法：" & 变量名 & "
haoK 2003-04-01
同意楼上
用cdate(DTpicker_birthday)试试
用cdate(DTpicker_birthday)试试
xks 2003-04-01
我觉得不是的！
应该在insert语句的最后一个双引号之前加一个分号！
如下 ：
cn.Execute "insert into customers(cust_usnm,cust_name, Cust_Pswd,Cust_IDCd,Cust_Birth,Cust_Add,Cust_Phone,Cust_MP,Cust_Zip,Cust_Email,cust_sex,cust_fav)values('" + txt_UserName + "','" + txt_RealName + "','" + txt_Pass + "','" + txt_Certificate + "','" + DTPicker_Brithday + "','" + txt_Address + "','" + txt_Tel + "','" + txt_MobelTel + "','" + txt_Post + "','" + txt_Email + "','" + sex + "','" + txt_Fax + "'）;"
我就是这么做的！
如果是类型不匹配！
那么你检查一下是不是每个字段都对就相应的值呢！
应该在insert语句的最后一个双引号之前加一个分号！
如下 ：
cn.Execute "insert into customers(cust_usnm,cust_name, Cust_Pswd,Cust_IDCd,Cust_Birth,Cust_Add,Cust_Phone,Cust_MP,Cust_Zip,Cust_Email,cust_sex,cust_fav)values('" + txt_UserName + "','" + txt_RealName + "','" + txt_Pass + "','" + txt_Certificate + "','" + DTPicker_Brithday + "','" + txt_Address + "','" + txt_Tel + "','" + txt_MobelTel + "','" + txt_Post + "','" + txt_Email + "','" + sex + "','" + txt_Fax + "'）;"
我就是这么做的！
如果是类型不匹配！
那么你检查一下是不是每个字段都对就相应的值呢！
donglw 2003-04-01
应该是那个日期字段的问题
你可以在调试的时候去掉那个字段试下
你可以在调试的时候去掉那个字段试下
zsgzsgzsg 2003-04-01
cn.Execute "insert into customers(cust_usnm,cust_name, Cust_Pswd,Cust_IDCd,Cust_Birth,Cust_Add,Cust_Phone,Cust_MP,Cust_Zip,Cust_Email,cust_sex,cust_fav)values('" + txt_UserName + "','" + txt_RealName + "','" + txt_Pass + "','" + txt_Certificate + "', convert(datetime,'" & Format(DTPicker_Brithday, "MM-dd-yyyy") & "',102),'" + txt_Address + "','" + txt_Tel + "','" + txt_MobelTel + "','" + txt_Post + "','" + txt_Email + "','" + sex + "','" + txt_Fax + "')"
