You are not logged in.
Announcement
Unanswered posts
|
- Index
- » Usage, Operation
- » DECODE function
Post a reply
Topic review (newest first)
- shong
- 2008-12-16 04:24:35
Hello
Is this syntax correct for 3 values:
Yes, you can 
Best regards
shong
- dhonore
- 2008-12-12 13:19:26
Is this syntax correct for 3 values:
row1.DCF_STATUS.equals("VERIFIED")?1:(row1.DCF_STATUS.equals("CLOSED")?1:(row1.DCF_STATUS.equals("RECEIVED")?1:0))
thanks
Didier
- shong
- 2008-12-12 03:18:32
Hello
row1.DCF_STATUS =="PART RECEIVED"?"RECEIVED":row1.DCF_STATUS
If the filed type is a String, change to the following expression:
row1.DCF_STATUS.equals("PART RECEIVED")?"RECEIVED":row1.DCF_STATUS
Best regards
shong
- dhonore
- 2008-12-11 13:55:56
Hello,
I would like to implement a decode function.
e.g.
DECODE (al1.dcf_status,
'PART RECEIVED', 'RECEIVED',
al1.dcf_status
)
when I define an expression like:
row1.DCF_STATUS =="PART RECEIVED"?"RECEIVED":row1.DCF_STATUS
it does not work.
Why?
Any ideas??
Thanks
Didier