Unload not equal to select
Posted in 2000
Hello,
I have a record in which the unload is not equal to select:
1) Select:
NN YY
AC-DIVCOMMOAC-CAUORDIOAC-FAMCOMMOAC-CLIENTEF001*YA0303
000000000AC-STATIS1AC-STATIS2AC-STATIS3 AN
TNN01I
2) Unload:
NN YY
AC-DIVCOMMOAC-CAUORDIOAC-FAMCOMMOAC-CLIENTEF001*YA0303
000000000AC-STATIS1AC-STATIS2AC-STATIS3 ^A
Following I report the output of the command oncheck 'pd of that record:
page_type rowid length fwd_ptr
HOME 109 210 0
0: 45 43 45 43 20 4f 43 c1 1 0 4e 4e 20 20 20 20 ECEC OCA..NN
16: 20 20 20 59 59 20 20 20 20 20 41 43 2d 44 49 56 YY AC-DIV
32: 43 4f 4d 4d 4f 41 43 2d 43 41 55 4f 52 44 49 4f COMMOAC-CAUORDIO
48: 41 43 2d 46 41 4d 43 4f 4d 4d 4f 41 43 2d 43 4c AC-FAMCOMMOAC-CL
64: 49 45 4e 54 45 46 30 30 31 2a 59 41 30 33 30 33 IENTEF001*YA0303
80: 30 30 30 30 30 30 30 30 30 41 43 2d 53 54 41 54 000000000AC-STAT
96: 49 53 31 41 43 2d 53 54 41 54 49 53 32 41 43 2d IS1AC-STATIS2AC-
112: 53 54 41 54 49 53 33 20 20 20 20 20 20 20 20 20 STATIS3
128: 20 20 20 20 20 20 20 1 99 90 40 1c 20 20 41 4e ...@. AN
144: 20 20 0 0 0 0 c 20 20 20 20 20 54 4e 4e 30 ..... TNN0
160: 31 49 20 20 20 20 20 20 20 20 20 20 20 20 20 20 1I
176: 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
192: 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
208: 20 20 ..............
The field is char (256).
Wath is the problem ?
Regards Enrico
Sent via Deja.com http://www.deja.com/
Before you buy.