临时表导出EXCEL有关问题
临时表导出EXCEL问题
SELECT cxrbb.pono as 单号, cxrbb.wdate as 工作日期, cxrbb.bc as 班次, cxrbb.bb as 班别, cxrbb.bzxm as 班长姓名, cxrbb.zyzgh as 作业者工号, cxrbb.zyzxm as 作业者姓名, cxrbb.matid as 品番名, cxrbb.gx as 工序, cxrbb.cpkzno as 成品控制单号, (cxrbb.lpzs-hgcrbb.blzs)*tm_excel.price as 良品总价,tm_excel.price as 单价,;
cxrbb.bzqty as 标准数量, cxrbb.zhgs as 折合工时, cxrbb.qs as 取数, cxrbb.scs as 生产数, (cxrbb.lpzs-hgcrbb.blzs) as 良品总数, hgcrbb.blzs as 不良总数, hgcrbb.blzs*tm_excel.price as 不良总价, hgcrbb.a as 脱胶, hgcrbb.b as 汽泡, hgcrbb.c as 硫化不良, hgcrbb.d as 生锈,;
hgcrbb.e as 裂开, hgcrbb.f as 变形, hgcrbb.g as 异物, hgcrbb.h as 残料, hgcrbb.i as 少料, hgcrbb.j as 模伤, hgcrbb.k as 模脏, hgcrbb.l as 脱模损伤, hgcrbb.m as 无弹簧, hgcrbb.n as 无芯金, hgcrbb.o as 烧焦, hgcrbb.p as 唇口伤, hgcrbb.q as 修边, hgcrbb.r as 毛边残留, hgcrbb.s as 其它, hgcrbb.t as 撕伤, hgcrbb.u as 芯金损伤, hgcrbb.v as 双重边, hgcrbb.w as 融合不良, hgcrbb.x as 粘合不良, hgcrbb.y as 压印, hgcrbb.z as 内径双修边, hgcrbb.aa as 内径大小边, hgcrbb.ab as 内径线纹, hgcrbb.ac as 芯金露出, hgcrbb.ad as 断面不良, hgcrbb.ae as 内径毛边残留, hgcrbb.af as 外周大小边, hgcrbb.ag as 外周毛边残留, hgcrbb.ah as 损伤, hgcrbb.ai as 双芯金, hgcrbb.aj as 压芯金,;
hgcrbb.ak as 冲伤, hgcrbb.al as 材料异物, hgcrbb.am as 尺寸不良, hgcrbb.an as 外周双修边 FROM cxrbb LEFT JOIN tm_excel ON cxrbb.matid=tm_excel.p_code LEFT JOIN hgcrbb on cxrbb.cpkzno=hgcrbb.cpkzno AND cxrbb.matid=hgcrbb.matid WHERE hgcrbb.wdate>=thisform.txtDate1.Value AND hgcrbb.wdate<=thisform.txtdate2.value AND cxrbb.matid like '%'+thisform.text4.Value+'%' AND cxrbb.gx='成型' AND cxrbb.cpkzno+cxrbb.matid in (SELECT cpkzno+matid FROM hgcrbb WHERE gx='检查') INTO CURSOR crxbbtmp
我在GRID.recordsource里设置的是crxbbtmp
但是我导出EXCEL
SELECT * FROM crxbbtmp提示这个crxbbtmp找不到。。怎么设置不用重新查找源数据。直接重crxbbtmp里取数
------解决思路----------------------
select * from tt into cursor newtt nofi
select * from newtt
能否成功
------解决思路----------------------
直接复制到文件
select crxbbtmp
copy to xxxx xls
用程序写
select crxbbtmp
scan
.....
endscan
------解决思路----------------------
select * from crxbbtmp 之前是不是有代码把 crxbbtmp 关闭了？
SELECT cxrbb.pono as 单号, cxrbb.wdate as 工作日期, cxrbb.bc as 班次, cxrbb.bb as 班别, cxrbb.bzxm as 班长姓名, cxrbb.zyzgh as 作业者工号, cxrbb.zyzxm as 作业者姓名, cxrbb.matid as 品番名, cxrbb.gx as 工序, cxrbb.cpkzno as 成品控制单号, (cxrbb.lpzs-hgcrbb.blzs)*tm_excel.price as 良品总价,tm_excel.price as 单价,;
cxrbb.bzqty as 标准数量, cxrbb.zhgs as 折合工时, cxrbb.qs as 取数, cxrbb.scs as 生产数, (cxrbb.lpzs-hgcrbb.blzs) as 良品总数, hgcrbb.blzs as 不良总数, hgcrbb.blzs*tm_excel.price as 不良总价, hgcrbb.a as 脱胶, hgcrbb.b as 汽泡, hgcrbb.c as 硫化不良, hgcrbb.d as 生锈,;
hgcrbb.e as 裂开, hgcrbb.f as 变形, hgcrbb.g as 异物, hgcrbb.h as 残料, hgcrbb.i as 少料, hgcrbb.j as 模伤, hgcrbb.k as 模脏, hgcrbb.l as 脱模损伤, hgcrbb.m as 无弹簧, hgcrbb.n as 无芯金, hgcrbb.o as 烧焦, hgcrbb.p as 唇口伤, hgcrbb.q as 修边, hgcrbb.r as 毛边残留, hgcrbb.s as 其它, hgcrbb.t as 撕伤, hgcrbb.u as 芯金损伤, hgcrbb.v as 双重边, hgcrbb.w as 融合不良, hgcrbb.x as 粘合不良, hgcrbb.y as 压印, hgcrbb.z as 内径双修边, hgcrbb.aa as 内径大小边, hgcrbb.ab as 内径线纹, hgcrbb.ac as 芯金露出, hgcrbb.ad as 断面不良, hgcrbb.ae as 内径毛边残留, hgcrbb.af as 外周大小边, hgcrbb.ag as 外周毛边残留, hgcrbb.ah as 损伤, hgcrbb.ai as 双芯金, hgcrbb.aj as 压芯金,;
hgcrbb.ak as 冲伤, hgcrbb.al as 材料异物, hgcrbb.am as 尺寸不良, hgcrbb.an as 外周双修边 FROM cxrbb LEFT JOIN tm_excel ON cxrbb.matid=tm_excel.p_code LEFT JOIN hgcrbb on cxrbb.cpkzno=hgcrbb.cpkzno AND cxrbb.matid=hgcrbb.matid WHERE hgcrbb.wdate>=thisform.txtDate1.Value AND hgcrbb.wdate<=thisform.txtdate2.value AND cxrbb.matid like '%'+thisform.text4.Value+'%' AND cxrbb.gx='成型' AND cxrbb.cpkzno+cxrbb.matid in (SELECT cpkzno+matid FROM hgcrbb WHERE gx='检查') INTO CURSOR crxbbtmp
我在GRID.recordsource里设置的是crxbbtmp
但是我导出EXCEL
SELECT * FROM crxbbtmp提示这个crxbbtmp找不到。。怎么设置不用重新查找源数据。直接重crxbbtmp里取数
------解决思路----------------------
select * from tt into cursor newtt nofi
select * from newtt
能否成功
------解决思路----------------------
直接复制到文件
select crxbbtmp
copy to xxxx xls
用程序写
select crxbbtmp
scan
.....
endscan
------解决思路----------------------
select * from crxbbtmp 之前是不是有代码把 crxbbtmp 关闭了？