홈 · 개발 참고자료

개발 참고자료

[파워빌더] Evaluate 활용하기...

작성자
왕희복
작성일
2016-04-26
조회
11603
분류
파워빌더
ll_cnt_air = Long(idw_air_03.Describe("Evaluate('sum( if( res_code = ~~~"#########~~~", 0, 1 ) for all )',1)"))

ld_comm_amt = Double(idw_air_03.Describe("Evaluate('sum( if( res_code = ~~~"#########~~~", if( isnull( comm_amt ), 0, comm_amt ), 0 ) for all )',1)"))

ld_full_amt = Double(idw_air_03.Describe("Evaluate('sum( if( res_code = ~~~"" + ls_res_code + "~~~" and res_no = " + String(li_res_no) + ", if( isnull( full_amt ), 0, full_amt ), 0 ) for all )',1)"))