在作ado连接vf数据库时,可以实现查询功能,但是添加记录时出现错误提示“不能更新查询,因为From子句不是单一的简单表名”简单程序如下: cc.Open "Provider=MSDASQL.1;Persist Security Info=True;Data Source=test"
rs.Open "select *from table1 where xingming='zhangsan'", cc, adOpenKeyset, adLockOptimistic, adCmdUnknown
rs.MoveLast
rs.AddNew
rs!xingming = Text1.Text
rs!xingbie = Text2.Text
rs.Update
rs.Open "select *from table1 where xingming='zhangsan'", cc, adOpenKeyset, adLockOptimistic, adCmdUnknown
rs.MoveLast
rs.AddNew
rs!xingming = Text1.Text
rs!xingbie = Text2.Text
rs.Update
INSERT INTO [tbl_students] ([stdName],[stdAge],[stdBir],[stdSex]) VALUES ('李想', 15, #1985-10-10#, 1)"