C++Builder Programming Forum
C++Builder  |  Delphi  |  FireMonkey  |  C/C++  |  Free Pascal  |  Firebird
볼랜드포럼 BorlandForum
 경고! 게시물 작성자의 사전 허락없는 메일주소 추출행위 절대 금지
C++빌더 포럼
Q & A
FAQ
팁&트릭
강좌/문서
자료실
컴포넌트/라이브러리
메신저 프로젝트
볼랜드포럼 홈
헤드라인 뉴스
IT 뉴스
공지사항
자유게시판
해피 브레이크
공동 프로젝트
구인/구직
회원 장터
건의사항
운영진 게시판
회원 메뉴
북마크
볼랜드포럼 광고 모집

C++빌더 Q&A
C++Builder Programming Q&A
[70237] BCB6+Oracle 9i+TQuery
민현호 [] 22250 읽음    2013-10-16 09:21
안녕하세요..

TQuery의 Edit/Post메소드로데이터를 변경하는 처리가
어떤때는 에러가 나고 어떤 때는 정상적으로 처리 되는
경우가  발생했습니다.

SQL모니터로 확인한 로그입니다.
같은 처리인데 아래와 같이 정상일때가 있고 에러일때 가 있습니다..
무엇이 문제일까요??? 정말 모르겠습니다..
정상일 때는 9845    17:34:31  SQL Data In: ORACLE - Rows affected = 1
에러일때는 184422  19:49:36  SQL Data In: ORACLE - Rows affected = 0


>>1. 정상일때는
9830    17:34:31  SQL Prepare: ORACLE - UPDATE "TEST_HEAD" SET "INTIME"=:1 WHERE "TEST_ID"=:2 AND "TT_NAME"=:3 AND "PRN_NAME"=:4 AND "SCOMMENT"=:5 AND "INDATE"=:6 AND "INTIME"=:7 AND "BLK_CNT"=:8 AND "LOCK_FLAG"=:9 AND "USER_ID"=:10 AND "TEST_LIB_ID" IS NULL  AND "ACCS_DATE" IS NULL  AND "ACCS_TIME" IS NULL  AND "LIB_FLAG"=:11 AND "TUNING_FLAG"=:12 AND "ROWID"=:13
9831    17:34:31  SQL Data In: ORACLE - Param = 1, Name = INTIME, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 17:34:25
9832    17:34:31  SQL Data In: ORACLE - Param = 2, Name = TEST_ID, Type = fldFLOAT, Precision = 4, Scale = 0, Data = 11.000000
9833    17:34:31  SQL Data In: ORACLE - Param = 3, Name = TT_NAME, Type = fldZSTRING, Precision = 16, Scale = 0, Data =  ABS-2004  m0 12
9834    17:34:31  SQL Data In: ORACLE - Param = 4, Name = PRN_NAME, Type = fldZSTRING, Precision = 16, Scale = 0, Data = 079461-2007
9835    17:34:31  SQL Data In: ORACLE - Param = 5, Name = SCOMMENT, Type = fldZSTRING, Precision = 16, Scale = 0, Data = -CM-000525
9836    17:34:31  SQL Data In: ORACLE - Param = 6, Name = INDATE, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2013/10/15
9837    17:34:31  SQL Data In: ORACLE - Param = 7, Name = INTIME, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 17:32:31
9838    17:34:31  SQL Data In: ORACLE - Param = 8, Name = BLK_CNT, Type = fldFLOAT, Precision = 4, Scale = 0, Data = 0.000000
9839    17:34:31  SQL Data In: ORACLE - Param = 9, Name = LOCK_FLAG, Type = fldFLOAT, Precision = 1, Scale = 0, Data = 1.000000
9840    17:34:31  SQL Data In: ORACLE - Param = 10, Name = USER_ID, Type = fldZSTRING, Precision = 16, Scale = 0, Data = NLB-0042
9841    17:34:31  SQL Data In: ORACLE - Param = 11, Name = LIB_FLAG, Type = fldFLOAT, Precision = 1, Scale = 0, Data = 1.000000
9842    17:34:31  SQL Data In: ORACLE - Param = 12, Name = TUNING_FLAG, Type = fldFLOAT, Precision = 1, Scale = 0, Data = 0.000000
9843    17:34:31  SQL Data In: ORACLE - Param = 13, Name = ROWID, Type = fldZSTRING, Precision = 18, Scale = 0, Data = AAAHefAAPAAABfaAAK
9844    17:34:31  SQL Execute: ORACLE - UPDATE "TEST_HEAD" SET "INTIME"=:1 WHERE "TEST_ID"=:2 AND "TT_NAME"=:3 AND "PRN_NAME"=:4 AND "SCOMMENT"=:5 AND "INDATE"=:6 AND "INTIME"=:7 AND "BLK_CNT"=:8 AND "LOCK_FLAG"=:9 AND "USER_ID"=:10 AND "TEST_LIB_ID" IS NULL  AND "ACCS_DATE" IS NULL  AND "ACCS_TIME" IS NULL  AND "LIB_FLAG"=:11 AND "TUNING_FLAG"=:12 AND "ROWID"=:13
9845    17:34:31  SQL Data In: ORACLE - Rows affected = 1
9846    17:34:31  SQL Stmt: ORACLE - Close

>>>2.에러 일때는

184407  19:49:36  SQL Prepare: ORACLE - UPDATE "TEST_HEAD" SET "INTIME"=:1 WHERE "TEST_ID"=:2 AND "TT_NAME"=:3 AND "PRN_NAME"=:4 AND "SCOMMENT"=:5 AND "INDATE"=:6 AND "INTIME"=:7 AND "BLK_CNT"=:8 AND "LOCK_FLAG"=:9 AND "USER_ID"=:10 AND "TEST_LIB_ID" IS NULL  AND "ACCS_DATE" IS NULL  AND "ACCS_TIME" IS NULL  AND "LIB_FLAG"=:11 AND "TUNING_FLAG"=:12 AND "ROWID"=:13
184408  19:49:36  SQL Data In: ORACLE - Param = 1, Name = INTIME, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 19:49:36
184409  19:49:36  SQL Data In: ORACLE - Param = 2, Name = TEST_ID, Type = fldFLOAT, Precision = 4, Scale = 0, Data = 11.000000
184410  19:49:36  SQL Data In: ORACLE - Param = 3, Name = TT_NAME, Type = fldZSTRING, Precision = 16, Scale = 0, Data =  ABS-2004  m0 12
184411  19:49:36  SQL Data In: ORACLE - Param = 4, Name = PRN_NAME, Type = fldZSTRING, Precision = 16, Scale = 0, Data = 079461-2007
184412  19:49:36  SQL Data In: ORACLE - Param = 5, Name = SCOMMENT, Type = fldZSTRING, Precision = 16, Scale = 0, Data = -CM-000525
184413  19:49:36  SQL Data In: ORACLE - Param = 6, Name = INDATE, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2013/10/15
184414  19:49:36  SQL Data In: ORACLE - Param = 7, Name = INTIME, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 19:49:30
184415  19:49:36  SQL Data In: ORACLE - Param = 8, Name = BLK_CNT, Type = fldFLOAT, Precision = 4, Scale = 0, Data = 0.000000
184416  19:49:36  SQL Data In: ORACLE - Param = 9, Name = LOCK_FLAG, Type = fldFLOAT, Precision = 1, Scale = 0, Data = 1.000000
184417  19:49:36  SQL Data In: ORACLE - Param = 10, Name = USER_ID, Type = fldZSTRING, Precision = 16, Scale = 0, Data = NLB-0042
184418  19:49:36  SQL Data In: ORACLE - Param = 11, Name = LIB_FLAG, Type = fldFLOAT, Precision = 1, Scale = 0, Data = 1.000000
184419  19:49:36  SQL Data In: ORACLE - Param = 12, Name = TUNING_FLAG, Type = fldFLOAT, Precision = 1, Scale = 0, Data = 0.000000
184420  19:49:36  SQL Data In: ORACLE - Param = 13, Name = ROWID, Type = fldZSTRING, Precision = 18, Scale = 0, Data = AAAHefAAPAAABfaAAK
184421  19:49:36  SQL Execute: ORACLE - UPDATE "TEST_HEAD" SET "INTIME"=:1 WHERE "TEST_ID"=:2 AND "TT_NAME"=:3 AND "PRN_NAME"=:4 AND "SCOMMENT"=:5 AND "INDATE"=:6 AND "INTIME"=:7 AND "BLK_CNT"=:8 AND "LOCK_FLAG"=:9 AND "USER_ID"=:10 AND "TEST_LIB_ID" IS NULL  AND "ACCS_DATE" IS NULL  AND "ACCS_TIME" IS NULL  AND "LIB_FLAG"=:11 AND "TUNING_FLAG"=:12 AND "ROWID"=:13
184422  19:49:36  SQL Data In: ORACLE - Rows affected = 0
184423  19:49:36  SQL Stmt: ORACLE - Close


+ -

관련 글 리스트
70237 BCB6+Oracle 9i+TQuery 민현호 22250 2013/10/16
70251     Re:BCB6+Oracle 9i+TQuery 초행길 19521 2013/10/22
Google
Copyright © 1999-2015, borlandforum.com. All right reserved.