Event Mapping failed
Hi every one ,
I am beginner and need help with my event script , i want update table in condition when data with " account like 1* and amount < 0 then accountx = N OR account like 2* and amount > 0 then accountx = N " after that it will validation error because i havent member N in my target. For now i use event aftprocmap :
My data
Account Accountx Amount
100000 100001 10
120000 100001 -5
200000 200001 20
220000 200001 -25
my script :
fdmAPI.logdebug
try:
query = "UPDATE TDATASEG SET ACCOUNTX = 'N' WHERE LOADID= ? and ACCOUNTX like '1%' And AMOUNT < 0 OR ACCOUNTX like '2%' And AMOUNT > 0"
params = [ fdmContext["LOADID"] ]
print fdmAPI.executeDML(query, params, False)