글 수 7,449
조회 수 : 1889
2006.04.13 (20:25:41)
그리드에 소수점이 입력이 되지 않는 것은,
데이타셋의 헤더 선언시 categoryId 칼럼에 대한 선언이 소수점을 입력할 수 있는 타입이나 자릿수가 정해지지 않아서 그런 문제가 생기는 것 같습니다.
해당 데이타셋의 헤더 선언하는 부분을 찾으셔서,
categoryId 칼럼의 타입이 TB_DECIMAL 로 선언이 되어 있는지
사이즈는 15, 2 와 같이 소수점 자릿수가 정해져 있는지 확인해 보시기 바랍니다.
>게시판을 이용해 주셔서 감사합니다.
>다음양식에 맞게 입력해주세요.
>
>* 고객시스템명 : GSCP
>* GAUCE 버전 : 4.0(4013) (Max 2.0)
>* WAS 종류(WebLogic 등등) : Weblogic 8.1
>* DB 종류 : Oracle
>* 문의 유형(질문/요청/참조) : User Status 변경
>* 내용 :
>그리드 셀에 소수점 수치가 표현 및 입력이 되지 않습니다.
>
>Edit={Decode(categoryId, '4', 'None', '5', 'None', 'True') } Dec=1 과 Edit='Numeric' Dec=1
>
>이렇게 두개의 설정 모두 소수점 이하의 수치는 표현 및 입력이 되지 않습니다.
>
>참고로 데이터를 보내 드리겠습니다.
>OBJECT_TO_GDRs=[LMultiData[ResultSet]={lineId=[160021, 160021, 160021, 160021, 160022, 160022, 160022, 160022, 160023, 160023, 160023, 160023], divisionCode=[DFZ, DFZ, DFZ, DFZ, DFZ, DFZ, DFZ, DFZ, DFZ, DFZ, DFZ, DFZ], siteId=[25, 25, 25, 25, 25, 25, 25, 25, 25, 25, 25, 25], siteName=[EAIL, EAIL, EAIL, EAIL, EAIL, EAIL, EAIL, EAIL, EAIL, EAIL, EAIL, EAIL], line=[IL_L1, IL_L1, IL_L1, IL_L1, IL_T1, IL_T1, IL_T1, IL_T1, IL_T2, IL_T2, IL_T2, IL_T2], weeklyOrderSeq=[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0], lineDesc=[EAIL TL Physical Line, EAIL TL Physical Line, EAIL TL Physical Line, EAIL TL Physical Line, EAIL TT Physical Line, EAIL TT Physical Line, EAIL TT Physical Line, EAIL TT Physical Line, EAIL TT Physical Line, EAIL TT Physical Line, EAIL TT Physical Line, EAIL TT Physical Line], bucketSeq=[119, 119, 119, 119, 119, 119, 119, 119, 119, 119, 119, 119], bucketStartDttm=[20061002, 20061002, 20061002, 20061002, 20061002, 20061002, 20061002, 20061002, 20061002, 20061002, 20061002, 20061002], lineCapaType=[null, null, null, null, null, null, null, null, null, null, null, null], capacityUom=[HOUR, HOUR, HOUR, HOUR, HOUR, HOUR, HOUR, HOUR, HOUR, HOUR, HOUR, HOUR], uomTime=[WEEK, WEEK, WEEK, WEEK, WEEK, WEEK, WEEK, WEEK, WEEK, WEEK, WEEK, WEEK], uph=[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0], displayType=[_WEEK_HOUR, _WEEK_HOUR, _WEEK_HOUR, _WEEK_HOUR, _WEEK_HOUR, _WEEK_HOUR, _WEEK_HOUR, _WEEK_HOUR, _WEEK_HOUR, _WEEK_HOUR, _WEEK_HOUR, _WEEK_HOUR], displayFlag=[O, O, O, O, O, O, O, O, O, O, O, O], categoryId=[1, 2, 3, 4, 1, 2, 3, 4, 1, 2, 3, 4], categoryName=[Working Day, Capa(HOUR/WEEK), Over Capa(HOUR/WEEK), Week Capa(HOUR/WEEK), Working Day, Capa(HOUR/WEEK), Over Capa(HOUR/WEEK), Week Capa(HOUR/WEEK), Working Day, Capa(HOUR/WEEK), Over Capa(HOUR/WEEK), Week Capa(HOUR/WEEK)], bucketSeq1=[8.1, 50.1, 0.1, 400.1, 6.1, 48.1, 0.1, 288.1, 6.1, 48.1, 0.1, 288.1], bucketSeq2=[6.1, 48.1, 0.1, 288.1, 6.1, 48.1, 0.1, 288.1, 6.1, 48.1, 0.1, 288.1], bucketSeq3=[6, 48, 0, 288, 6, 48, 0, 288, 6, 48, 0, 288], bucketSeq4=[6, 48, 0, 288, 6, 48, 0, 288, 6, 48, 0, 288], bucketSeq5=[6, 48, 0, 288, 6, 48, 0, 288, 6, 48, 0, 288], bucketSeq6=[6, 48, 0, 288, 6, 48, 0, 288, 6, 48, 0, 288], bucketSeq7=[6, 48, 0, 288, 6, 48, 0, 288, 6, 48, 0, 288], bucketSeq8=[6, 48, 0, 288, 6, 48, 0, 288, 6, 48, 0, 288], bucketSeq9=[6, 48, 0, 288, 6, 48, 0, 288, 6, 48, 0, 288], bucketSeq10=[6, 48, 0, 288, 6, 48, 0, 288, 6, 48, 0, 288], bucketSeq11=[6, 48, 0, 288, 6, 48, 0, 288, 6, 48, 0, 288], bucketSeq12=[6, 48, 0, 288, 6, 48, 0, 288, 6, 48, 0, 288], bucketSeq13=[6, 48, 0, 288, 6, 48, 0, 288, 6, 48, 0, 288], bucketSeq14=[6, 48, 0, 288, 6, 48, 0, 288, 6, 48, 0, 288], bucketSeq15=[6, 48, 0, 288, 6, 48, 0, 288, 6, 48, 0, 288], bucketSeq16=[6, 48, 0, 288, 6, 48, 0, 288, 6, 48, 0, 288], bucketSeq17=[6, 48, 0, 288, 6, 48, 0, 288, 6, 48, 0, 288], bucketSeq18=[6, 48, 0, 288, 6, 48, 0, 288, 6, 48, 0, 288], bucketSeq19=[6, 48, 0, 288, 6, 48, 0, 288, 6, 48, 0, 288], bucketSeq20=[6, 48, 0, 288, 6, 48, 0, 288, 6, 48, 0, 288], bucketSeq21=[6, 48, 0, 288, 6, 48, 0, 288, 6, 48, 0, 288], bucketSeq22=[6, 48, 0, 288, 6, 48, 0, 288, 6, 48, 0, 288], bucketSeq23=[6, 48, 0, 288, 6, 48, 0, 288, 6, 48, 0, 288], bucketSeq24=[6, 48, 0, 288, 6, 48, 0, 288, 6, 48, 0, 288], bucketSeq25=[6, 48, 0, 288, 6, 48, 0, 288, 6, 48, 0, 288], bucketSeq26=[6, 48, 0, 288, 6, 48, 0, 288, 6, 48, 0, 288]}]}
데이타셋의 헤더 선언시 categoryId 칼럼에 대한 선언이 소수점을 입력할 수 있는 타입이나 자릿수가 정해지지 않아서 그런 문제가 생기는 것 같습니다.
해당 데이타셋의 헤더 선언하는 부분을 찾으셔서,
categoryId 칼럼의 타입이 TB_DECIMAL 로 선언이 되어 있는지
사이즈는 15, 2 와 같이 소수점 자릿수가 정해져 있는지 확인해 보시기 바랍니다.
>게시판을 이용해 주셔서 감사합니다.
>다음양식에 맞게 입력해주세요.
>
>* 고객시스템명 : GSCP
>* GAUCE 버전 : 4.0(4013) (Max 2.0)
>* WAS 종류(WebLogic 등등) : Weblogic 8.1
>* DB 종류 : Oracle
>* 문의 유형(질문/요청/참조) : User Status 변경
>* 내용 :
>그리드 셀에 소수점 수치가 표현 및 입력이 되지 않습니다.
>
>Edit={Decode(categoryId, '4', 'None', '5', 'None', 'True') } Dec=1 과 Edit='Numeric' Dec=1
>
>이렇게 두개의 설정 모두 소수점 이하의 수치는 표현 및 입력이 되지 않습니다.
>
>참고로 데이터를 보내 드리겠습니다.
>OBJECT_TO_GDRs=[LMultiData[ResultSet]={lineId=[160021, 160021, 160021, 160021, 160022, 160022, 160022, 160022, 160023, 160023, 160023, 160023], divisionCode=[DFZ, DFZ, DFZ, DFZ, DFZ, DFZ, DFZ, DFZ, DFZ, DFZ, DFZ, DFZ], siteId=[25, 25, 25, 25, 25, 25, 25, 25, 25, 25, 25, 25], siteName=[EAIL, EAIL, EAIL, EAIL, EAIL, EAIL, EAIL, EAIL, EAIL, EAIL, EAIL, EAIL], line=[IL_L1, IL_L1, IL_L1, IL_L1, IL_T1, IL_T1, IL_T1, IL_T1, IL_T2, IL_T2, IL_T2, IL_T2], weeklyOrderSeq=[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0], lineDesc=[EAIL TL Physical Line, EAIL TL Physical Line, EAIL TL Physical Line, EAIL TL Physical Line, EAIL TT Physical Line, EAIL TT Physical Line, EAIL TT Physical Line, EAIL TT Physical Line, EAIL TT Physical Line, EAIL TT Physical Line, EAIL TT Physical Line, EAIL TT Physical Line], bucketSeq=[119, 119, 119, 119, 119, 119, 119, 119, 119, 119, 119, 119], bucketStartDttm=[20061002, 20061002, 20061002, 20061002, 20061002, 20061002, 20061002, 20061002, 20061002, 20061002, 20061002, 20061002], lineCapaType=[null, null, null, null, null, null, null, null, null, null, null, null], capacityUom=[HOUR, HOUR, HOUR, HOUR, HOUR, HOUR, HOUR, HOUR, HOUR, HOUR, HOUR, HOUR], uomTime=[WEEK, WEEK, WEEK, WEEK, WEEK, WEEK, WEEK, WEEK, WEEK, WEEK, WEEK, WEEK], uph=[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0], displayType=[_WEEK_HOUR, _WEEK_HOUR, _WEEK_HOUR, _WEEK_HOUR, _WEEK_HOUR, _WEEK_HOUR, _WEEK_HOUR, _WEEK_HOUR, _WEEK_HOUR, _WEEK_HOUR, _WEEK_HOUR, _WEEK_HOUR], displayFlag=[O, O, O, O, O, O, O, O, O, O, O, O], categoryId=[1, 2, 3, 4, 1, 2, 3, 4, 1, 2, 3, 4], categoryName=[Working Day, Capa(HOUR/WEEK), Over Capa(HOUR/WEEK), Week Capa(HOUR/WEEK), Working Day, Capa(HOUR/WEEK), Over Capa(HOUR/WEEK), Week Capa(HOUR/WEEK), Working Day, Capa(HOUR/WEEK), Over Capa(HOUR/WEEK), Week Capa(HOUR/WEEK)], bucketSeq1=[8.1, 50.1, 0.1, 400.1, 6.1, 48.1, 0.1, 288.1, 6.1, 48.1, 0.1, 288.1], bucketSeq2=[6.1, 48.1, 0.1, 288.1, 6.1, 48.1, 0.1, 288.1, 6.1, 48.1, 0.1, 288.1], bucketSeq3=[6, 48, 0, 288, 6, 48, 0, 288, 6, 48, 0, 288], bucketSeq4=[6, 48, 0, 288, 6, 48, 0, 288, 6, 48, 0, 288], bucketSeq5=[6, 48, 0, 288, 6, 48, 0, 288, 6, 48, 0, 288], bucketSeq6=[6, 48, 0, 288, 6, 48, 0, 288, 6, 48, 0, 288], bucketSeq7=[6, 48, 0, 288, 6, 48, 0, 288, 6, 48, 0, 288], bucketSeq8=[6, 48, 0, 288, 6, 48, 0, 288, 6, 48, 0, 288], bucketSeq9=[6, 48, 0, 288, 6, 48, 0, 288, 6, 48, 0, 288], bucketSeq10=[6, 48, 0, 288, 6, 48, 0, 288, 6, 48, 0, 288], bucketSeq11=[6, 48, 0, 288, 6, 48, 0, 288, 6, 48, 0, 288], bucketSeq12=[6, 48, 0, 288, 6, 48, 0, 288, 6, 48, 0, 288], bucketSeq13=[6, 48, 0, 288, 6, 48, 0, 288, 6, 48, 0, 288], bucketSeq14=[6, 48, 0, 288, 6, 48, 0, 288, 6, 48, 0, 288], bucketSeq15=[6, 48, 0, 288, 6, 48, 0, 288, 6, 48, 0, 288], bucketSeq16=[6, 48, 0, 288, 6, 48, 0, 288, 6, 48, 0, 288], bucketSeq17=[6, 48, 0, 288, 6, 48, 0, 288, 6, 48, 0, 288], bucketSeq18=[6, 48, 0, 288, 6, 48, 0, 288, 6, 48, 0, 288], bucketSeq19=[6, 48, 0, 288, 6, 48, 0, 288, 6, 48, 0, 288], bucketSeq20=[6, 48, 0, 288, 6, 48, 0, 288, 6, 48, 0, 288], bucketSeq21=[6, 48, 0, 288, 6, 48, 0, 288, 6, 48, 0, 288], bucketSeq22=[6, 48, 0, 288, 6, 48, 0, 288, 6, 48, 0, 288], bucketSeq23=[6, 48, 0, 288, 6, 48, 0, 288, 6, 48, 0, 288], bucketSeq24=[6, 48, 0, 288, 6, 48, 0, 288, 6, 48, 0, 288], bucketSeq25=[6, 48, 0, 288, 6, 48, 0, 288, 6, 48, 0, 288], bucketSeq26=[6, 48, 0, 288, 6, 48, 0, 288, 6, 48, 0, 288]}]}
http://member.shift.co.kr/index.php?document_srl=232420
(*.124.184.195)
|
|
