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