点击grid表格,为什么数据变成一样的了
SELECT A.cname,A.patno,A.checker,A.cname1,A.doctor,A.bed,B.itemcname,B.Reportvalu,B.Resultstat,B.Refrange,A.checkdate,B.zdy3 INTO TABLE ptemp1 FROM plisb A,Pbgao B WHERE B.sampleno =A.sampleno ORDER BY cname
*SELECT A.cname INTO TABLE ptemp2 FROM plisb A,Pbgao B WHERE B.sampleno =A.sampleno ORDER BY cname
o2=thisform.grid1
thisform.grid1.RecordSource = 'ptemp1'
o2.column1.controlsource=''
o2.column2.controlsource='cname'
o2.column3.controlsource='patno'
o2.column4.controlsource='checker'
o2.column5.controlsource='cname1'
o2.column6.controlsource='doctor'
o2.column7.controlsource=''
o2.column8.controlsource='bed'
o2.column9.controlsource='itemcname'
o2.column10.controlsource='Reportvalu'
o2.column11.controlsource='Resultstat'
o2.column12.controlsource='Refrange'
o2.column13.controlsource='checkdate'
o2.column14.controlsource='iif (ptemp1.zdy3=null ,.f.,.t.)'
点击一下表格,数据为什么会变成一样的,如何控制