UC知道VB访问数据库
来源：百度知道 编辑：UC知道 时间：2024/06/30 02:05:21
请问这句话什么意思？
Set QY_rs = QY_dbs.OpenRecordset("select B.SamTNo,B.reqno,B.chedate,B.samno,B.patno,B.pname,B.psex,B.page,B.ageunit,B.disno,E.micname,E.germid from resultexe E inner join resultbill B on E.reqno=B.reqno where (micname<>'') and (B.chedate>= cdate('" & F_date.Value & "')) and (B.chedate<=cdate('" & L_date.Value & "'))")
Set QY_rs = QY_dbs.OpenRecordset("select B.SamTNo,B.reqno,B.chedate,B.samno,B.patno,B.pname,B.psex,B.page,B.ageunit,B.disno,E.micname,E.germid from resultexe E inner join resultbill B on E.reqno=B.reqno where (micname<>'') and (B.chedate>= cdate('" & F_date.Value & "')) and (B.chedate<=cdate('" & L_date.Value & "'))")
打开一个记录集 从resultexe E inner join resultbill B on E.reqno=B.reqno表的B.SamTNo,B.reqno,B.chedate,B.samno,B.patno,B.pname,B.psex,B.page,B.ageunit,B.disno,E.micname,E.germid这些栏位里选择满足(micname<>'') and (B.chedate>= cdate('" & F_date.Value & "')) and (B.chedate<=cdate('" & L_date.Value & "'))") 条件的数据