Set SNRec = DB_SerialNO.Execute("select * from tablename")
Dim InsertRecSql As String
InsertRecSql = " insert into tablename values('aa')"
DB_SerialNO.Execute InsertRecSql运行后出现查询值的数目与目标字段中的数目不同
Dim InsertRecSql As String
InsertRecSql = " insert into tablename values('aa')"
DB_SerialNO.Execute InsertRecSql运行后出现查询值的数目与目标字段中的数目不同
Set SNRec = DB_SerialNO.Execute("select * from tablename")
if SNRec.RecordCount = ? then
Dim InsertRecSql As String
InsertRecSql = " insert into tablename values('aa')"
DB_SerialNO.Execute InsertRecSql
else
不插入记录
end if