请问为什么同一段语句在SQL SERVER里面就可以用，再VB里面就不能用呢？在线等

[Virus2003]

这是我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就不能通过呢？总是会说“类型不匹配”

大家帮帮忙啊

[zsgzsgzsg]

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 + "')"

[donglw]

应该是那个日期字段的问题
你可以在调试的时候去掉那个字段试下

[xks]

我觉得不是的！

应该在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 + "'）;"

我就是这么做的！

如果是类型不匹配！

那么你检查一下是不是每个字段都对就相应的值呢！

[haoK]

同意楼上
用cdate(DTpicker_birthday)试试

[饮水需思源]

字符型变量的引用方法：'" & 变量名 & "'
数值型变量的引用方法：" & 变量名 & "

[lxcc]

up

[watt]

in sql server '2003/01/01'
in access #2003/01/01#
do you know?

[cbzdream]

楼上说的对，你试试