Genero 的部落格

# CONSTRUCT+ SUM --> 取得特定某些單據上金額的總和 

LET g_sql + DECLARE xxx  CURSOR FROM g_sql + OPEN + FETCH + CLOSE

EX:       LET g_sql = "SELECT sum(tc_fad008) FROM tc_fad_file,tc_fac_file ",
                        "WHERE tc_fac001 = tc_fad001 AND ",g_wc
            DECLARE p400_cur_s_fad008 SCROLL CURSOR FROM g_sql
            OPEN p400_cur_s_fad008
            FETCH p400_cur_s_fad008 INTO g_sum
            CLOSE p400_cur_s_fad008