SQL语句生成一个表格 - 专家坐堂 - Foxtable(狐表) - 新一代数据库软件，完美融合Access、Foxpro、Excel、vb.net之优势，人人都能掌握的快速软件开发工具!

Foxtable(狐表) → 用户栏目 → 专家坐堂 → SQL语句生成一个表格

共有11919人关注过本帖树形打印复制链接主题：SQL语句生成一个表格

jxkqf

小大 1楼 | 信息 | 搜索 | 邮箱 | 主页 | UC

加好友

发短信

等级：三尾狐帖子：778 积分：7463 威望：0 精华：0 注册：2009/9/7 10:55:00

SQL语句生成一个表格 发帖心情

Post By：2011/5/30 10:17:00 [只看该作者]

现有如下SQL语句，希望能在FOXTABLE中生成一个表格，不知如何做？

insert into tblrsxx(GZLBMC,DWBM,BMMC,SFZ,XM,XB,GL,XLMC,XWMC,MZMC,RYBM,CSRQ,CSD,YJ,RYXZ,ZZZKMC,ZW,JBMC,JBDM,GZJB,RZSJNY,ZJYCTZSJ,YRZW,YRZSJNY,CJGZSJ,LBDWSJ,DZYSXLSJ,GZTFNY,LTSJ,LTQZW,KZQDMC,KMBM,JSBJ,RQ,GK,YHBM,YHZH,PXJBXH,BY1,BY2,BY3,BY4,BY5,BY6,BY7,BY8,BY9,BY10,RSXZ,GZXZ,BZQK,DWBS,ZGDW,L_ZWDJDM,BZLB,PROGRAM,JZDM,ZRYY,JRYY,JRXTSJ,WDWDRSJ,RYZXNY,YSNYBZ,YDWBM,L_ZWLBDM,RYDCNY,CZBJ) values('其他','JX0001000','002','612729192701024829','刘珍','女',0,'XL--','XW--','MZ--','0000QT021900200078118',NULL,NULL,NULL,'XZ01','ZZ--',NULL,'JB--',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'QD--','002001001001','0','2011-05-05','GK01','01','050501100078118',118,'0000QT02190020007811',NULL,NULL,NULL,'stencil601',0,0,0,0,0,'4','4','1','ZT01','JX0001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,'00100000000000000000')

insert into tblrsxx(GZLBMC,DWBM,BMMC,SFZ,XM,XB,GL,XLMC,XWMC,MZMC,RYBM,CSRQ,CSD,YJ,RYXZ,ZZZKMC,ZW,JBMC,JBDM,GZJB,RZSJNY,ZJYCTZSJ,YRZW,YRZSJNY,CJGZSJ,LBDWSJ,DZYSXLSJ,GZTFNY,LTSJ,LTQZW,KZQDMC,KMBM,JSBJ,RQ,GK,YHBM,YHZH,PXJBXH,BY1,BY2,BY3,BY4,BY5,BY6,BY7,BY8,BY9,BY10,RSXZ,GZXZ,BZQK,DWBS,ZGDW,L_ZWDJDM,BZLB,PROGRAM,JZDM,ZRYY,JRYY,JRXTSJ,WDWDRSJ,RYZXNY,YSNYBZ,YDWBM,L_ZWLBDM,RYDCNY,CZBJ) values('其他','JX0001000','002','610327193705092923','高兰','女',0,'XL--','XW--','MZ--','0000QT021900200078589',NULL,NULL,NULL,'XZ01','ZZ--',NULL,'JB--',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'QD--','002001001001','0','2011-05-05','GK01','01','050501100078589',589,'0000QT02190020007858',NULL,NULL,NULL,'stencil601',0,0,0,0,0,'4','4','1','ZT01','JX0001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,'00100000000000000000')

insert into tblrsxx(GZLBMC,DWBM,BMMC,SFZ,XM,XB,GL,XLMC,XWMC,MZMC,RYBM,CSRQ,CSD,YJ,RYXZ,ZZZKMC,ZW,JBMC,JBDM,GZJB,RZSJNY,ZJYCTZSJ,YRZW,YRZSJNY,CJGZSJ,LBDWSJ,DZYSXLSJ,GZTFNY,LTSJ,LTQZW,KZQDMC,KMBM,JSBJ,RQ,GK,YHBM,YHZH,PXJBXH,BY1,BY2,BY3,BY4,BY5,BY6,BY7,BY8,BY9,BY10,RSXZ,GZXZ,BZQK,DWBS,ZGDW,L_ZWDJDM,BZLB,PROGRAM,JZDM,ZRYY,JRYY,JRXTSJ,WDWDRSJ,RYZXNY,YSNYBZ,YDWBM,L_ZWLBDM,RYDCNY,CZBJ) values('其他','JX0001000','002','612729194409220047','曹兰','女',0,'XL--','XW--','MZ--','0000QT021900200087036',NULL,NULL,NULL,'XZ01','ZZ--',NULL,'JB--',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'QD--','002001001001','0','2011-05-05','GK01','01','050501100087036',36,'0000QT02190020008703',NULL,NULL,NULL,'stencil601',0,0,0,0,0,'4','4','1','ZT01','JX0001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,'00100000000000000000')

[此贴子已经被作者于2011-5-30 10:19:53编辑过]