깨비네 마을 ~ 'ㅁ'/

ii_rc = dw_entry.retrieve(gs_company, ls_fr_dt, ls_to_dt, ls_slip_yy, ls_slip_job, ll_slip_no, ls_state, ls_cust_cd, ls_busi_no) if ls_state = 'Y' then // 전송완료 이면 dw_entry.Object.nts_send_gb.Protect = 1 else dw_entry.Object.nts_send_gb.Protect = 0 end if

1) 해당 datawindow의 itemchanged 이벤트에 filter 스크립트 작성(entry datawindow에 조회된 데이타 filter) filter컬럼명 : filter_yn CASE "filter_yn" dw_entry.SetReDraw(False) if data = 'Y' then dw_entry.SetFilter("jan_amt 0") else dw_entry.SetFilter("") end if dw_entry.Filter() dw_entry.SetReDraw(True) 2) dw_head에 filter 컬럼 dropdownlistbox로 설정 : state_gb(filter컬럼) state_gb로 선택된 내용으로 조회 후 자동 filter 설정하기 ue_retrieve 이벤트에서 ..

ORA-29250: Invalid index specifed in call to dbms_sql.bind_array Cause: An invalid index was specified in a call to bind_array of dbms_sql. The index may have been null or of an improper value. Action: Correct the index value by modifying your PL/SQL program and try the bind_array call again. ORA-29251: Index1 is greater than Index2 in call to dbms_sql.bind_array Cause: The value of index1 was g..

[에러] ERROR at line 1: ORA-32313: REFRESH FAST of "SWSIS"."TA_E012_MV" unsupported after PMOPs ORA-06512: at "SYS.DBMS_SNAPSHOT", line 820 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 877 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 858 ORA-06512: at "SWSIS.JU_TMP", line 851 ORA-06512: at line 1 ORA-32313: REFRESH FAST of "string"."string" unsupported after PMOPs Cause: A Partition Maintenance Operation (P..

1) create session 권한을 주지 않아서 에러날 경우 이거나 비밀번호, 유저명을 잘못 쓴 경우~ system/password 로 접속후 SQL> grant connect, resource to sw ; Grant succeeded. 2) 재접속 [웬만하면 이걸로 다 해결!!!]

먼저, 1) ue_insert에 순차적으로(마지막row추가) 입력하게 한다 /*===========================================================================*/ /* Event : ue_insert */ /* Description : 추가버튼 클릭시 발생 */ /* Update : 수정불가 */ /*===========================================================================*/ String ls_yymm, ls_div long ll_cur_row, ll_row_count if dw_entry.AcceptText() 1 then return ls_yymm = String(dw_1.object..

해당 datawindow의 constructor event This.of_SetBase(True) This.of_SetSort(True) This.inv_base.of_SetColumnNameSource(2) // header로 sort This.inv_sort.of_SetUseDisplay(True) // dddw같은 경우 display value로 sort This.inv_sort.of_SetColumnHeader(True) // DATAWINDOW COLUMN을 자동으로 Modify Integer i, li_column_count String ls_column_name, ls_modify li_column_count = Integer(This.Describe("DataWindow.Column.Cou..

String ls_path, ls_file blob blob_image, blob_temp long Job, ll_filelen integer li_x, li_y, net, li_loop, i Integer ll_file String ls_yymm Long ll_cnt, ll_chk pointer oldpointer // Declares a pointer variable ls_yymm = String(dw_1.object.yymm[1], 'yyyymm') if isnull(ls_yymm) or trim(ls_yymm) = '' then messagebox("알림", "DOWNLOAD할 년월을 입력하세요") return 1 end if select count(*) into :ll_cnt from tb_ta..

[ 파일 업로드 ] blob blob_temp, blob_tot integer li_filenum, li_index, li_loop String ls_file, ls_filename long ll_filelen, ll_read String ls_yymm Long ll_cnt, ll_rtn pointer oldpointer // Declares a pointer variable ls_yymm = String(dw_1.object.yymm[1], 'yyyymm') if isnull(ls_yymm) or trim(ls_yymm) = '' then messagebox("알림", "UPLOAD 대상 년월을 입력하세요") return 1 end if oldpointer = SetPointer(HourGlass!) ..

select count(case when to_char(hiredate,'MM') ='01' then count(*) end) as jan, count(case when to_char(hiredate,'MM') ='02' then count(*) end) as feb from emp