Sample listpos() trace output
When the listpos() user-defined function
executes successfully, it produces the following output in the listpos.trc file:
============================================================
Tracing session: 18 on 03/16/2000
13:12:24 Insert 1 into LIST of INTEGER @1
13:12:24 Insert 2 into LIST of INTEGER @2
13:12:24 Insert 3 into LIST of INTEGER @3
13:12:24 Fetch MI_CURSOR_ABSOLUTE @ jump=1:
13:12:24 should get 1
13:12:24 got 1, fetch succeeded
13:12:24 Fetch MI_CURSOR_ABSOLUTE @ jump=3:
13:12:24 should get 3
13:12:24 got 3, fetch succeeded
13:12:24 Fetch MI_CURSOR_ABSOLUTE @ jump=2:
13:12:24 should get 2
13:12:24 got 2, fetch succeeded
13:12:24 Fetch MI_CURSOR_PRIOR @ jump=1:
13:12:24 should get 1
13:12:24 got 1, fetch succeeded
13:12:24 Fetch MI_CURSOR_LAST @ jump=3:
13:12:24 should get 3
13:12:24 got 3, fetch succeeded
13:12:24 Fetch MI_CURSOR_FIRST @ jump=1:
13:12:24 should get 1
13:12:24 got 1, fetch succeeded
13:12:24 Fetch MI_CURSOR_RELATIVE @ jump=2:
13:12:24 should get 3
13:12:24 got 3, fetch succeeded
13:12:24 Fetch MI_CURSOR_RELATIVE @ jump=-2:
13:12:24 should get 1
13:12:24 got 1, fetch succeeded
13:12:24 Update 3 into LIST of INTEGER @1
13:12:24 Fetch MI_CURSOR_ABSOLUTE @ jump=1:
13:12:24 should get 3
13:12:24 got 3, fetch succeeded
13:12:24 Insert '1234567689' into LIST of CHAR @1
13:12:24 Insert 'abcdefghij' into LIST of CHAR @2
13:12:24 Insert 'three' into LIST of CHAR @3
13:12:24 Fetch MI_CURSOR_ABSOLUTE @ jump=1:
13:12:24 should get '1234567689'
13:12:24 got '1234567689', fetch succeeded
13:12:24 Fetch MI_CURSOR_ABSOLUTE @ jump=3:
13:12:24 should get 'three'
13:12:24 got 'three', fetch succeeded
13:12:24 Fetch MI_CURSOR_ABSOLUTE @ jump=2:
13:12:24 should get 'abcdefghij'
13:12:24 got 'abcdefghij', fetch succeeded
13:12:24 Fetch MI_CURSOR_PRIOR @ jump=1:
13:12:24 should get '1234567689'
13:12:24 got '1234567689', fetch succeeded
13:12:24 Fetch MI_CURSOR_LAST @ jump=3:
13:12:24 should get 'three'
13:12:24 got 'three', fetch succeeded
13:12:24 Fetch MI_CURSOR_FIRST @ jump=1:
13:12:24 should get '1234567689'
13:12:24 got '1234567689', fetch succeeded
13:12:24 Fetch MI_CURSOR_RELATIVE @ jump=2:
13:12:24 should get 'three'
13:12:24 got 'three', fetch succeeded
13:12:24 Fetch MI_CURSOR_RELATIVE @ jump=-2:
13:12:24 should get '1234567689'
13:12:24 got '1234567689', fetch succeeded
13:12:24 Update 'mnopqrstuv' into LIST of CHAR @1
13:12:24 Fetch MI_CURSOR_FIRST @ jump=1:
13:12:24 should get 'mnopqrstuv'
13:12:24 got 'mnopqrstuv', fetch succeeded
13:12:24 Insert 1.100000 into LIST of FLOAT @1
13:12:24 Insert -2.200000 into LIST of FLOAT @2
13:12:24 Insert 3.300000 into LIST of FLOAT @3
13:12:24 Fetch MI_CURSOR_ABSOLUTE @ jump=1:
13:12:24 should get 1.100000
13:12:24 got 1.100000, fetch succeeded
13:12:24 Fetch MI_CURSOR_ABSOLUTE @ jump=3:
13:12:24 should get 3.300000
13:12:24 got 3.300000, fetch succeeded
13:12:24 Fetch MI_CURSOR_ABSOLUTE @ jump=2:
13:12:24 should get -2.200000
13:12:24 got -2.200000, fetch succeeded
13:12:24 Fetch MI_CURSOR_PRIOR @ jump=1:
13:12:24 should get 1.100000
13:12:24 got 1.100000, fetch succeeded
13:12:24 Fetch MI_CURSOR_LAST @ jump=3:
13:12:24 should get 3.300000
13:12:24 got 3.300000, fetch succeeded
13:12:24 Fetch MI_CURSOR_FIRST @ jump=1:
13:12:24 should get 1.100000
13:12:24 got 1.100000, fetch succeeded
13:12:24 Fetch MI_CURSOR_RELATIVE @ jump=2:
13:12:24 should get 3.300000
13:12:24 got 3.300000, fetch succeeded
13:12:24 Fetch MI_CURSOR_RELATIVE @ jump=-2:
13:12:24 should get 1.100000
13:12:24 got 1.100000, fetch succeeded
13:12:24 Update 0.004400 into LIST of FLOAT @1
13:12:24 Fetch MI_CURSOR_ABSOLUTE @ jump=1:
13:12:24 should get 0.004400
13:12:24 got 0.004400, fetch succeeded