谁能帮我看看这错在哪了。?

wishstudying 2002-12-01 08:40:13
sql = "insert into base (xuelei,xuewei,leavetime,zhuanye," _
& "xuezhi,biyeschool,biye_type,zhiwu_dif,fazheng,gettime,zhiwu_name,gettype)" _
& "values(" & xuelei & "," & xuewei & "," & leavetime & "," & zhuanye & "," & xuezhi & "," _
& " " & biyeschool & "," & biye_type & "," & zhiwu_dif & "," & fazheng & "," & gettime & "," _
& " " & zhiwu_name & "," & gettype & ")"
gcn.Execute (sql)  <----
我在编译时,也没出现错误提示啊。但一运行时到gcn.Execute (sql)时,停止了。提示
insert into 语句的语法错误
我实在找不出来错误了。
高手赐教!
...全文
17 2 打赏 收藏 转发到动态 举报
写回复
用AI写文章
2 条回复
切换为时间正序
请发表友善的回复…
发表回复
tollers 2002-12-01
  • 打赏
  • 举报
回复
有可能出现的错误:
1、插入的值与数据库表中的数据类型不匹配
2、插入的值可能为null,而数据库表中的字段不能为null
3、插入的值为12个,数据库表中字段数量是不是有12个
wishstudying 2002-12-01
  • 打赏
  • 举报
回复
上面的不对。下面的是原文。大家帮小弟我看看吧
sql = "insert into base (xuelei,xuewei,leavetime,zhuanye," _
& "xuezhi,biyeschool,biye_type,zhiwu_dif,"_
& "fazheng,gettime,zhiwu_name,gettype)" _
& "values(" & xuelei & "," & xuewei & "," & leavetime & "," _
& " " & zhuanye & "," & xuezhi & "," _
& " " & biyeschool & "," & biye_type & "," & zhiwu_dif & "," _
& " " & fazheng & "," & gettime & "," _
& " " & zhiwu_name & "," & gettype & ")"
gcn.Execute (sql)  <----
我在编译时,也没出现错误提示啊。但一运行时到gcn.Execute (sql)时,停止了。提示insert into 语句的语法错误
我实在找不出来错误了。
高手赐教!

1,216

社区成员

发帖
与我相关
我的任务
社区描述
VB 数据库(包含打印,安装,报表)
社区管理员
  • 数据库(包含打印,安装,报表)社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧