请各位帮忙看看 为什么取最大值的时候
为什么提示dars.Fields("dtsqe")在对应所需名称或集合序数中,未找到项目~~
求教了~~~~dasql = " select max(dtsqe) as dtsql from test_item_ab_type where testid='" & testid & "' and test_item_ab='" & test_item_ab & "' and test_item_id ='" & test_item_id & "'"
dars.CursorLocation = adUseClient
dars.CursorType = adOpenStatic
Set dasql = dbconn.Execute(dasql)
MsgBox dars.Fields("dtsqe")
为什么提示dars.Fields("dtsqe")在对应所需名称或集合序数中,未找到项目~~
求教了~~~~dasql = " select max(dtsqe) as dtsql from test_item_ab_type where testid='" & testid & "' and test_item_ab='" & test_item_ab & "' and test_item_id ='" & test_item_id & "'"
dars.CursorLocation = adUseClient
dars.CursorType = adOpenStatic
Set dasql = dbconn.Execute(dasql)
MsgBox dars.Fields("dtsqe")
MsgBox dars.Fields("dtsql")
MsgBox dars.Fields("dtsql")
Set dars = dbconn.Execute(dasql)
MsgBox dars.Fields("dtsql")
MsgBox dars.Fields("dtsql")