我的代码
SQL = "select * from gsinfo1"
Set rs = ExecuteSQL(SQL, MsgText)While Not rs.EOF <===================说什么我的with没有设定qyno = rs.Fields("qyno").Value
gsname = rs.Fields("gsname").Value
gsperson = rs.Fields("gsperson").Value
gsaddr = rs.Fields("gsaddr").Value
gszz = rs.Fields("gszz").Value
gslx = rs.Fields("gslx").Value
gszx = rs.Fields("gszx").Value
hytype = rs.Fields("hytype").Value
mobile = rs.Fields("mobile").Value
jyfw = rs.Fields("jyfw").Valuers.MoveNexttxtSQL = "insert into saveqy (qyno,gsname,gsperson,gsaddr,gszz,gslx,gszx,hytype,mobile,jyfw,xmID) values('" & qyno & "','" & gsname & "','" & gsperson & "','" & gsaddr & "','" & gszz & "','" & gslx & "','" & gszx & "','" & hytype & "','" & mobile & "','" & jyfw & "','" & maxid & "')"
Set mrc = ExecuteSQL(txtSQL, MsgText)
WendtxtSQL = "delete from gsinfo1"
Set mrc = ExecuteSQL(txtSQL, MsgText)
SQL = "select * from gsinfo1"
Set rs = ExecuteSQL(SQL, MsgText)While Not rs.EOF <===================说什么我的with没有设定qyno = rs.Fields("qyno").Value
gsname = rs.Fields("gsname").Value
gsperson = rs.Fields("gsperson").Value
gsaddr = rs.Fields("gsaddr").Value
gszz = rs.Fields("gszz").Value
gslx = rs.Fields("gslx").Value
gszx = rs.Fields("gszx").Value
hytype = rs.Fields("hytype").Value
mobile = rs.Fields("mobile").Value
jyfw = rs.Fields("jyfw").Valuers.MoveNexttxtSQL = "insert into saveqy (qyno,gsname,gsperson,gsaddr,gszz,gslx,gszx,hytype,mobile,jyfw,xmID) values('" & qyno & "','" & gsname & "','" & gsperson & "','" & gsaddr & "','" & gszz & "','" & gslx & "','" & gszx & "','" & hytype & "','" & mobile & "','" & jyfw & "','" & maxid & "')"
Set mrc = ExecuteSQL(txtSQL, MsgText)
WendtxtSQL = "delete from gsinfo1"
Set mrc = ExecuteSQL(txtSQL, MsgText)
顺便看看我这个问题
此问题我自己已经解决了的这个不用回复了
直接去那里就好。帮我看看那个问题吧!我弄了很久了没弄出来
帮忙看看阿
别在这里回阿