小弟想要请教一下 由 "定义"-->"CR temptable"-->sr_record-->sr2_record-->"select"-->"FOREACH" 己知表单设定有31个定义 在CR temptable也设置了31个相对应栏位的 ? sr_RECORD也设定相关的栏位值 sr2_RECORD也等同上方的栏位值 在SELECT取值上假设也取到相关的栏位值 而在FOREACH内应该要如何撰写呢 原始写法为 FOREACH r506_c1 INTO sr2[l_i].*,l_pmn01,l_pmn02 范例为 LET g_sql="pmm01.pmm_file.pmm01" ="pmm12.pmm_file.pmm12" . . . ="pmnud01.pmn_file.pmnud01" ="pmp05.pm_file.pmp05" sr_RECORD= pmm01 LIKE pmm_file.pmm01, pmm12 LIKE pmm_file.pmm12, . . . ,pmnud01 LIKE pmn_file.pmnud01 ,pmp05 LIKE pmp_file.pmp05 sr2_RECORD= pmm01 LIKE pmm_file.pmm01, pmm12 LIKE pmm_file.pmm12, . . . ,pmnud01 LIKE pmn_file.pmnud01 ,pmp05 LIKE pmp_file.pmp05 l_sql = "SELECT '','','',",pmm01,pmm12,..,pmn01,pmn02,pmnud01,pmp05" FOREACH r506_c1 INTO sr2[l_i].*,l_pmn01,l_pmn02 小弟知道是因为栏位对应不到的关系 所以取不到相关的资料表 因为後方的pmnud01 和 pmp05 是小弟加上的 不知FOREACH该如何修正 才能取得应有的对应的栏位值 请问小弟该如何修正才能取到正式的栏位值呢? 谢谢... ================================================== 补充 小弟使用SQL Develop测试 SELECT语法 发现 仅有取到部分栏位 有部分栏位未被取出，如pmnud01 详细语法如下 SELECT '','','',pmm01,pmm12,pmm13,gen02,pmm25,pmn02,pmm04,pmm09,pmc03,pmn04,pmn20, pmn33,'','','','','','',pmn041,ima021,pmn122,pmn98,pmn07, pmn35,pmn50,pmn55,pmn01,pmn02,pmnud01,pmp05 FROM pmm_file left join pmc_file on pmm09 = pmc_file.pmc01 left join gen_file on pmm12 = gen_file.gen01 ,pmn_file left join (select pnb01,pnb03,pnb20a from pna_file,pnb_file where pna05='Y' AND pna13='1' and pna01=pnb01 and pna02=pnb02 ) on pmn01=pnb01 and pmn02=pnb03 left join ima_file on pmn04 = ima_file.ima01 ,pmp_file WHERE pmm01 = pmn01 AND pmm18 <> 'X' AND pmm25 ='2' AND ( pnb20a is null or pnb20a !=0) AND pmp04 ='1' AND pmn20 > 0 order by pmm_file.pmm01,pmn_file.pmn02 请问小弟是缺少那个语法才导致pmnud01捞不出资料呢 谢谢... ※ 编辑: perasa 来自: 210.66.52.158 (11/07 16:34)