RecordSource是数据源,你把"insert into credit values (" & a & "," & b & "," & c & ")"放进去当然不行!!RecordSource应放入数据连接字符串,然后用Adodc1.EXECUTE="insert into credit values (" & a & "," & b & "," & c & ")"就可以了,试试吧。
调试欢乐多
不过你的INSERT语句也有问题啊
应该是INSERT INTO CREDIT (字段名,字段名,字段名)VALUES(" & a & "," & b & "," & c & ")"
参考一下"春城"的意见,再者你可以用ADODC1的NEW方法。
1、
a = 8133
b = 8133
c = 9133
sql_s = "insert into credit values (" & a & "," & b & "," & c & ")"
Adodc1.RecordSource = sql_s
Adodc1.Refresh
这样做,插入成功,但提示adodc1.refresh失败,因为对象没有关闭...
2、照你说的做,提示Adodc1.Execute处未找到方法或成员
3、烦请那位再指点一下,我确实是菜鸟,而且很笨!!!
请问,我为什么不能执行adodc1.execute?
既然大家说下面的做法是错误的,那为什么数据被插入了?
sql_s = "insert into credit values (" & a & "," & b & "," & c & ")"
Adodc1.RecordSource = sql_s
我简直说不清楚了!!!
1、我的adodc1就没有execute这个方法,怎么回事?
2、既然能插入,就说明adodc1.recordsource=“insert ...”应该是可以的,对吗?问题在于为什么接下来不能refresh?
我真是麻烦大家了!!