sm_trace(TRACE) to file C:\Project\HR\employeetrace.rtf called 2014/06/19 20:39:31

20:39:31 screen entry rwcrpal

20:39:31 screen exit secrpal

20:39:31 sm_ldb_init

20:39:33 getkey " "

20:39:33 getkey SPF5

20:39:38 screen entry employee.jam

20:39:38 screen JPL info form employee.jam

20:39:38 screen JPL form employee.jam

20:39:38 field entry form employee.jam deptno

20:39:40 getkey PI_KEY_CTRL_STRING

20:39:40 ctrl string start ^dm_handle_connect 1

20:39:40 proc start CONTROL_FUNC dm_handle_connect 1

20:39:40 proc end CONTROL_FUNC dm_handle_connect 1 returned 0

20:39:40 ctrl string end ^dm_handle_connect 1

20:39:40 field entry form dmcheng eng_opt

20:39:40 proc start FIELD_FUNC dm_ff_dmcheng

20:39:40 proc end FIELD_FUNC dm_ff_dmcheng returned 0

20:39:41 getkey form dmcheng ok_button MOUS LeftClick

20:39:41 field exit form dmcheng eng_opt

20:39:41 proc start FIELD_FUNC dm_ff_dmcheng

20:39:41 proc end FIELD_FUNC dm_ff_dmcheng returned 0

20:39:41 field entry form dmcheng ok_button

20:39:41 getkey form dmcheng ok_button MOUS LeftRelease

20:39:41 getkey form dmcheng ok_button ACTIVATE

20:39:41 ctrl string start ^dm_ok_dmcheng

20:39:41 proc start CONTROL_FUNC dm_ok_dmcheng

20:39:41 field exit form dmcheng ok_button

20:39:41 proc end CONTROL_FUNC dm_ok_dmcheng returned 0

20:39:41 ctrl string end ^dm_ok_dmcheng

20:39:41 field entry form dmconn conn_values occ 1

20:39:41 proc start FIELD_FUNC dm_ff_dmconn

20:39:41 proc end FIELD_FUNC dm_ff_dmconn returned 0

20:39:42 getkey s

20:39:42 getkey c

20:39:42 getkey o

20:39:42 getkey t

20:39:42 getkey t

20:39:43 getkey #

20:39:44 getkey BKSP

20:39:44 getkey @

20:39:44 getkey o

20:39:44 getkey r

20:39:45 getkey a

20:39:45 getkey 1

20:39:45 getkey 0

20:39:45 getkey 2

20:39:45 getkey TAB

20:39:45 field validation form dmconn conn_values occ 1

20:39:45 field exit form dmconn conn_values occ 1

20:39:45 field entry form dmconn conn_values occ 2

20:39:45 proc start FIELD_FUNC dm_ff_dmconn

20:39:45 proc end FIELD_FUNC dm_ff_dmconn returned 0

20:39:46 getkey t

20:39:46 getkey i

20:39:47 getkey g

20:39:47 getkey e

20:39:47 getkey r

20:39:48 getkey form dmconn ok_button MOUS LeftClick

20:39:48 field exit form dmconn conn_values occ 2

20:39:48 field entry form dmconn ok_button

20:39:48 proc start FIELD_FUNC dm_ff_dmconn

20:39:48 proc end FIELD_FUNC dm_ff_dmconn returned 0

20:39:48 getkey form dmconn ok_button MOUS LeftRelease

20:39:48 getkey form dmconn ok_button ACTIVATE

20:39:48 ctrl string start ^dm_ok_dmconn

20:39:48 proc start CONTROL_FUNC dm_ok_dmconn

20:39:48 DBi start engine oracle

20:39:48 DBi end engine oracle

20:39:48 DBi start declare dm_ora0_conn connection for USER 'scott@ora102' PASSWORD 'tiger'

20:40:22 DBi end declare dm_ora0_conn connection for USER 'scott@ora102' PASSWORD 'tiger'

20:40:22 DBi start connection dm_ora0_conn

20:40:22 DBi end connection dm_ora0_conn

20:40:22 getkey form dmconn ok_button ACTIVATE

20:40:23 proc end CONTROL_FUNC dm_ok_dmconn returned 0

20:40:23 ctrl string end ^dm_ok_dmconn

20:40:24 getkey form employee.jam deptno MOUS LeftClick

20:40:25 getkey form employee.jam deptno MOUS LeftRelease

20:40:25 getkey 1

20:40:25 getkey 0

20:40:26 getkey form employee.jam getpb MOUS LeftClick

20:40:26 field exit form employee.jam deptno

20:40:26 field entry form employee.jam getpb

20:40:26 getkey form employee.jam getpb MOUS LeftRelease

20:40:26 getkey form employee.jam getpb ACTIVATE

20:40:26 field validation form employee.jam getpb

20:40:26 ctrl string start ^get_emp

20:40:26 JPL proc name get_emp

20:40:26 screen JPL info form employee.jam

20:40:26 JPL proc start get_emp

20:40:26 JPL line 3 dbms sql select ename, empno,hiredate, job from emp, dept where emp.deptno=dept.deptno and emp.deptno=:deptno

20:40:26 DBi start sql select ename, empno,hiredate, job from emp, dept where emp.deptno=dept.deptno and emp.deptno=10

20:40:27 DBi warning No more rows indicator.

20:40:27 DBi end sql select ename, empno,hiredate, job from emp, dept where emp.deptno=dept.deptno and emp.deptno=10

20:40:27 JPL proc end get_emp

20:40:27 ctrl string end ^get_emp

20:40:39 getkey EXIT

20:40:39 field exit form employee.jam getpb

20:40:39 screen exit employee.jam

20:40:39 getkey EXIT

20:40:39 getkey SPF5