1、查询表改成
Select {qh_rkdmx}.ID,rkdhxh,wzbm,wzmc,pyjm,ssdl,gg,dw,sl,dj,jsje,xzje,{qh_rkdmx}.rklx,cklx,{qh_rkdmx}.ly,{qh_rkdmx}.fkfs,ftts,{qh_rkdmx}.bz,ckmdd,{qh_rkd}.rkdh,stm,pzh,rksj,zdsj,zdr,{qh_rkdmx}.rkdh From {qh_rkdmx} Inner JOIN {qh_rkd} ON {qh_rkd}.[rkdh] = {qh_rkdmx}.[rkdh]
2、这段改一下
DataTables("qh_rkdmxcx").LoadFilter=StrFind %qh_rkdmxcx是查询表，由表qh_rkdmx和qh_rkd查询而来。
DataTables("qh_rkdmxcx").Load()
Tables("qh_rkdmxcx").Filter=StrFind
Tables("qh_rkdmxcx").Sort = "rksj,stm"
-------------
改成
DataTables("qh_rkdmxcx").LoadFilter="{qh_rkdmx}.ly = '张三'"
DataTables("qh_rkdmxcx").Load()
Tables("qh_rkdmxcx").Filter=StrFind
Tables("qh_rkdmxcx").Sort = "rksj,stm"
[此贴子已经被作者于2014-9-14 20:59:05编辑过]
加好友 
发短信
Post By：2014/9/14 20:05:00 [显示全部帖子]
