[SQL ] SQL語法問題

看板Database作者perasa (緣份的天梯)時間10年前 (2013/09/25 13:08)推噓1(1推 0噓 17→)

留言18則, 2人參與討論串4/5 (看更多)

小弟繼日前的SELECT CASE 上級說這樣的語法是有的不過能否運作仍是未知數因此要小弟修改成 SELECT INTO FROM CASE WHEN END CASE 而小弟自行撰寫成 SELECT azf03 INTO l_azf03 FROM azf_file CASE g_pmk.pmk01 WHEN azf03 LET azf01 = g_pmk.pmk02 END CASE DISPLAY g_pmk.pmk02 TO pmk02 補上之前寫的2個code，該2個code均可正常執行 ========================================= SELECT azf03 INTO l_azf03 FROM azf_file WHERE azf01 = g_pmk.pmk01 LET g_pmk.pmk02 = l_azf03 DISPLAY g_pmk.pmk02 to pmk02 ========================================= CASE g_pmk.pmk01 WHEN "G310-" LET g_pmk.pmk02 = "EXP" WHEN "G312-" LET g_pmk.pmk02 = "CAP" WHEN "G313-" LET g_pmk.pmk02 = "REG" END CASE 其中的欄位名稱如下 | azf_file ___________ ___________ | ------- ------- |g_pmk.pmk01| |g_pmk.pmk02| | |azf01| |azf03| |___________| |___________| | |-----| |-----| | |G310-| | EXP | | |G312-| | CAP | | |G313-| | REG | | |-----| |-----| 目的：小弟想要使用SELECT INTO FROM CASE END CASE的語法來達到只要輸入azf01的值可自動挑選出azf03的值而g_pmk.pmk01則是輸入視窗，可輸入azf01的值 g_pmk.pmk02會自動顯示g_pmk.pmk01輸入之值挑選出所許之值為何 error code ========================== ../42m/cpm_sapmt420.4gl:1840:16:1840:20:error:(-4369) The symbol 'azf03' does not represent a defined variable. ../42m/cpm_sapmt420.4gl:1841:15:1841:19:error:(-4369) The symbol 'azf01' does not represent a defined variable. The compilation was not successful. Errors found: 2. 請問大大知道是何處寫錯嗎能否告知小弟一下呢謝謝.... -- ※ 發信站: 批踢踢實業坊(ptt.cc) ◆ From: 210.66.52.158 ※ 編輯: perasa 來自: 210.66.52.158 (09/25 13:10)

→