◆◇◆◇ SQL Server 的问题还是 VB 的问题??◆◇◆◇ 这种情况严格来说是你的程序的问题,如果你把DTPicker取出的日期用FORMAT格式化一下是绝对不会出现这个问题的。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 Dim strsql As String Dim rssql As Recordset strsql = "insert into sell values('" + Text_sell_isbn.Text+ "'," strsql = strsql + "'" + Text_sell_name.Text + "'," strsql = strsql + "'" + Text_sell_concern.Text + "'," strsql = strsql + "'" + Text_sell_no.Text + "'," strsql = strsql + "'" + Text_sell_price.Text + "'," strsql = strsql + "'" + Text_sell_ma.Text + "'," strsql = strsql + "'" + Combo_sell_discount.Text + "'," strsql = strsql + "'" + Text_sell_shi.Text + "'," strsql = strsql + Format(DTPicker_sell_time.Value) + "," strsql = strsql + "'" + Text_sell_man.Text + "'," strsql = strsql + "'" + Text_sell_danhao.Text + "')" 倒数第三行错了吗?怎么改? sql="insert Tab_Test(F_Date,Msg) values ('"+format(DTPicker1,"yyyy-mm-dd")+"','"+trim(text1)+"')"con.execute sql Dim strsql As String Dim rssql As Recordset strsql = "insert into sell values('" + Text_sell_isbn.Text+ "'," strsql = strsql + "'" + Text_sell_name.Text + "'," strsql = strsql + "'" + Text_sell_concern.Text + "'," strsql = strsql + "'" + Text_sell_no.Text + "'," strsql = strsql + "'" + Text_sell_price.Text + "'," strsql = strsql + "'" + Text_sell_ma.Text + "'," strsql = strsql + "'" + Combo_sell_discount.Text + "'," strsql = strsql + "'" + Text_sell_shi.Text + "'," strsql = strsql + "'" + Format(DTPicker_sell_time.Value,"yyyy-mm-dd") + "'," strsql = strsql + "'" + Text_sell_man.Text + "'," strsql = strsql + "'" + Text_sell_danhao.Text + "')" Sql语句??? 关于MySql排序问题 求助~~sql问题~~ SQLSERVER服务器考虑做双机热备 数据库访问问题 SQL I/O不一致 824 问题寻答案 一张表里列相同合并成多列 SELECT语句的问题:真的不如ORACLE吗? {高分求助]SQL高手救救我! 我想在我的存储过程中调用系统存储过程sp_addlinkedsrvlogin,出错??? SQL SERVER2000中的自增字段的自增值不听话,不管我有没有添加,她都会加1,怎么办? 关于sql2000中链接服务器(Linker)的创建问题,高手请进
Dim rssql As Recordset
strsql = "insert into sell values('" + Text_sell_isbn.Text+ "',"
strsql = strsql + "'" + Text_sell_name.Text + "',"
strsql = strsql + "'" + Text_sell_concern.Text + "',"
strsql = strsql + "'" + Text_sell_no.Text + "',"
strsql = strsql + "'" + Text_sell_price.Text + "',"
strsql = strsql + "'" + Text_sell_ma.Text + "',"
strsql = strsql + "'" + Combo_sell_discount.Text + "',"
strsql = strsql + "'" + Text_sell_shi.Text + "',"
strsql = strsql + Format(DTPicker_sell_time.Value) + ","
strsql = strsql + "'" + Text_sell_man.Text + "',"
strsql = strsql + "'" + Text_sell_danhao.Text + "')"
倒数第三行错了吗?怎么改?
con.execute sql
Dim rssql As Recordset
strsql = "insert into sell values('" + Text_sell_isbn.Text+ "',"
strsql = strsql + "'" + Text_sell_name.Text + "',"
strsql = strsql + "'" + Text_sell_concern.Text + "',"
strsql = strsql + "'" + Text_sell_no.Text + "',"
strsql = strsql + "'" + Text_sell_price.Text + "',"
strsql = strsql + "'" + Text_sell_ma.Text + "',"
strsql = strsql + "'" + Combo_sell_discount.Text + "',"
strsql = strsql + "'" + Text_sell_shi.Text + "',"
strsql = strsql + "'" + Format(DTPicker_sell_time.Value,"yyyy-mm-dd") + "',"
strsql = strsql + "'" + Text_sell_man.Text + "',"
strsql = strsql + "'" + Text_sell_danhao.Text + "')"