jolly
VIP Member
Hi All, in an event rule I am doing a Update Table I/0. I am providing the left-hand part of a non primary key (AN8, ICU of AN8, ICU, PRTR). The system generates this SQL:
"UPDATE TESTDTA.F06116 SET YTAN8=32346.000000,YTP003=' ',YTP004='060',YTICU=1880308.000000 WHERE ( YTICU = 1880308.000000 AND YTAN8 = 32346.000000 ) AND ( YTAN8 NOT BETWEEN 1.000000 AND 9999999.000000 )"
How the heck did that AND ... NOT BETWEEN ... stuff get in there??? Here is the ER:
0018 F06116.Update
VA evt_AddressNumber = TK Address Number
VA evt_ReportingCodesPayro003 -> TK Category Codes - Payroll 003
VA evt_ReportingCodesPayro004 -> TK Category Codes - Payroll 004
VA evt_BatchNumber = TK Batch Number
It seems JDE is deliberately excluding the entire valid range of address numbers for some reason. Row security perhaps?
This system is SP16, Oracle 8.1.7.4 on Solaris8.
TIA,
JohnO
"UPDATE TESTDTA.F06116 SET YTAN8=32346.000000,YTP003=' ',YTP004='060',YTICU=1880308.000000 WHERE ( YTICU = 1880308.000000 AND YTAN8 = 32346.000000 ) AND ( YTAN8 NOT BETWEEN 1.000000 AND 9999999.000000 )"
How the heck did that AND ... NOT BETWEEN ... stuff get in there??? Here is the ER:
0018 F06116.Update
VA evt_AddressNumber = TK Address Number
VA evt_ReportingCodesPayro003 -> TK Category Codes - Payroll 003
VA evt_ReportingCodesPayro004 -> TK Category Codes - Payroll 004
VA evt_BatchNumber = TK Batch Number
It seems JDE is deliberately excluding the entire valid range of address numbers for some reason. Row security perhaps?
This system is SP16, Oracle 8.1.7.4 on Solaris8.
TIA,
JohnO