string 변환 1. 날짜 형식 - String(Now(),'yyyy-mm-dd hh:mm:ss.f') : 2018-01-09 09:05:10.9 - String(Now(),'yyyy-mm-dd hh:mm:ss.ff') : 2018-01-09 09:05:10.98 - String(Now(),'yyyy-mm-dd hh:mm:ss.fff') : 2018-01-09 09:05:10.987 - String(Now(),'yyyy-mm-dd hh:mm:ss.ffff') : 2018-01-09 09:05:10.9870 - String(Now(),'yyyy-mm-dd hh:mm:ss.fffff') : 2018-01-09 09:05:10.98700 - String(Now(),'yyyy-mm-dd hh:mm:ss.ffffff') : 20.. 더보기 [파워빌더]DB에 저장된 이미지 다운로드 하기 string ls_path, ls_file, ls_emp_cdblob lb_image, lb_templong ll_filelen, ll_retinteger li_loop, i, li_file ll_ret = dw_1.getrow() if ll_ret = 0 then returnls_emp_cd = dw_1.getitemstring(ll_ret, 'as_emp_cd') selectblob empnp_pic into :lb_image from inse98t1 where empno = :ls_emp_cd using sqlca; IF SQLCA.SQLCode = -1 THEN MessageBox("SQL error", SQLCA.SQLErrText)END IF ll_filelen = len(lb_image)if.. 더보기 [파워빌더] 이미지 DB에 저장하기 bloblb_temp, lb_totintegerli_filenum, li_index, li_loopStringls_file, ls_filename, ls_emp_cd, ls_pathlongll_filelen, ll_read, ll_rowcnt, i, ll_cnt if GetFileOpenName("JPG,BMP File",ls_file,ls_filename,"JPG","JPG Files, *.JPG,BMP Files, *.BMP") = 1 thenll_filelen = FileLength(ls_file)li_filenum = FileOpen(ls_file,StreamMode!,Read!,LockRead!) if li_filenum -1 thenif ll_filelen > 32765 thenif mod(l.. 더보기 이전 1 2 3 4 5 6 ··· 9 다음 목록 더보기