→ agmax:SELECT ....pmn01,pmn02,pmnud01,pmp05 改成 11/21 13:22
→ agmax:SELECT ...,pmnud01,pmp05,pmn01,pmn02 11/21 13:23
小弟想要請教一下
由 "定義"-->"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)