为什么我不能向数据库插入数据? 首先你的用户有没有权限?把你的代码帖出来! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 代码如下sub begininput() if len(weekno.value)=0 then msgbox "请输入周别......",,"提示窗口" exit sub end if if len(classno.value)=0 and len(xm.value)=0 and len(start_no.value)=0 then msgbox "请选择班级或者输入学号,姓名......",,"提示窗口" exit sub end if l_date=trim(dateno.value) if len(start_no.value)=0 and len(xm.value)=0 then rds1.SQL="execute kaoqin_class "+"'"+trim(weekno.value)+"',"+"'"+trim(l_date)+"',"+"'"+trim(classno.value)+"',"+"'"+trim(kno.value)+"'" rds1.ExecuteOptions = 1 rds1.SQL="select * from kaoqin where 班号='" & trim(classno.value) & "'" rds1.Refresh elseif len(start_no.value)<>0 and len(xm.value)=0 then rds1.SQL="execute kaoqin_xh"+"'"+trim(weekno.value)+"',"+"'"+trim(l_date)+"',"+"'"+trim(start_no.value)+"',"+"'"+trim(kno.value)+"'" rds1.ExecuteOptions = 1 rds1.SQL="select * from kaoqin where 学号='" & trim(start_no) & "'" rds1.Refresh elseif len(start_no.value)=0 and len(xm.value)=0 then rds1.SQL="execute kaoqin_xm"+"'"+trim(weekno.value)+"',"+"'"+trim(l_date)+"',"+"'"+trim(xm.value)+"',"+"'"+trim(kno.value)+"'" rds1.ExecuteOptions = 1 rds1.sql="select * from kaoqin where 姓名='" & trim(xm.value) & "'" rds1.Refresh elseif len(start_no.value)<>0 and len(xm.value)=0 then rds1.SQL="execute kaoqin_xh"+"'"+trim(weekno.value)+"',"+"'"+trim(l_date)+"',"+"'"+trim(start_no.value)+"',"+"'"+trim(kno.value)+"'" rds1.ExecuteOptions = 1 rds1.SQL="select * from kaoqin where 学号='" & trim(start_no) & "'" rds1.Refresh end if end sub 你在什么地方有插入的代码?我怎么找不到? 你把代码邮件给我,我发邮件给你! 请教一个关于2个表查询效率的问题 SQL 语句:在当天(日期)所有加入的会员中我随机抽取一位会员 这道题关于行压缩和页压缩 本人求一sql语句解决方案,详情请点击。如果解决马上结贴!!!!! sqlserver2008 更新字段问题 使用两个表里的数据横向联合成一个数据报表的问题 求助!关于mysql服务器不能启动的新问题 关于从多对多影射到一对一影射。 人命关天,数据库高手请进!!! 各位大佬帮我看下哪里不对 Analysis Services 的一个很简单的问题 求教:如何把ms sql server中某个数据库的数据导入Access ?
sub begininput() if len(weekno.value)=0 then
msgbox "请输入周别......",,"提示窗口"
exit sub
end if
if len(classno.value)=0 and len(xm.value)=0 and len(start_no.value)=0 then
msgbox "请选择班级或者输入学号,姓名......",,"提示窗口"
exit sub
end if
l_date=trim(dateno.value)
if len(start_no.value)=0 and len(xm.value)=0 then
rds1.SQL="execute kaoqin_class "+"'"+trim(weekno.value)+"',"+"'"+trim(l_date)+"',"+"'"+trim(classno.value)+"',"+"'"+trim(kno.value)+"'"
rds1.ExecuteOptions = 1
rds1.SQL="select * from kaoqin where 班号='" & trim(classno.value) & "'"
rds1.Refresh
elseif len(start_no.value)<>0 and len(xm.value)=0 then
rds1.SQL="execute kaoqin_xh"+"'"+trim(weekno.value)+"',"+"'"+trim(l_date)+"',"+"'"+trim(start_no.value)+"',"+"'"+trim(kno.value)+"'"
rds1.ExecuteOptions = 1 rds1.SQL="select * from kaoqin where 学号='" & trim(start_no) & "'"
rds1.Refresh
elseif len(start_no.value)=0 and len(xm.value)=0 then
rds1.SQL="execute kaoqin_xm"+"'"+trim(weekno.value)+"',"+"'"+trim(l_date)+"',"+"'"+trim(xm.value)+"',"+"'"+trim(kno.value)+"'"
rds1.ExecuteOptions = 1 rds1.sql="select * from kaoqin where 姓名='" & trim(xm.value) & "'"
rds1.Refresh
elseif len(start_no.value)<>0 and len(xm.value)=0 then
rds1.SQL="execute kaoqin_xh"+"'"+trim(weekno.value)+"',"+"'"+trim(l_date)+"',"+"'"+trim(start_no.value)+"',"+"'"+trim(kno.value)+"'"
rds1.ExecuteOptions = 1 rds1.SQL="select * from kaoqin where 学号='" & trim(start_no) & "'"
rds1.Refresh
end if
end sub