Originally posted by: Edward_chan4

Hi,

I put this

=IF (DBLOOKUP("SELECT DECK_IND FROM cargo_details WHERE bl_no_id="+CAST(BOOKING_NO_ID Column:BKHeader AS CHARACTER)+" and rownum=1","-DBType Oracle %IQSHIP_CONN% %IQSHIP_PASS%") = "U", "UN", IF (DBLOOKUP("SELECT DECK_IND FROM cargo_details WHERE bl_no_id="+CAST(BOOKING_NO_ID Column:BKHeader AS CHARACTER)+" and rownum=1","-DBType Oracle %IQSHIP_CONN% %IQSHIP_PASS%") = "O", "OD", ""))

to the rule of the Composite element.

But I get these

M114 ERROR:

Map: f_cargo_remarks Output: TextRef Composite:FTX2

Output argument of rule does not match output type:

=IF (DBLOOKUP("SELECT DECK_IND FROM cargo_details WHERE bl_no_id="+CAST(BOOKING_NO_ID Column:BKHeader AS CHARACTER)+" and rownum=1","-DBType Oracle %IQSHIP_CONN% %IQSHIP_PASS%") = "U", "UN", IF (DBLOOKUP("SELECT DECK_IND FROM cargo_details WHERE bl_no_id="+CAST(BOOKING_NO_ID Column:BKHeader AS CHARACTER)+" and rownum=1","-DBType Oracle %IQSHIP_CONN% %IQSHIP_PASS%") = "O", "OD", ""))

M108 ERROR:

Map: f_cargo_remarks Output: TextRef Composite:FTX2

Rule references unknown map: CAST.

M105 ERROR:

Map: f_cargo_remarks Output: TextRef Composite:FTX2

Rule references unknown type: BOOKING_NO_ID Column:BKHeader AS CHARACTER.

 

Total errors: 3. Total warnings: 0.

when building it. Any ideas?

Originally posted by: dtx_user

Try this

=IF (DBLOOKUP("SELECT DECK_IND FROM cargo_details WHERE bl_no_id CAST( " + TEXT(BOOKING_NO_ID Column:BKHeader AS CHARACTER)+" ) and rownum=1","-DBType Oracle %IQSHIP_CONN% %IQSHIP_PASS%") = "U", "UN", IF (DBLOOKUP("SELECT DECK_IND FROM cargo_details WHERE bl_no_id=CAST("+ TEXT(BOOKING_NO_ID Column:BKHeader AS CHARACTER)+") and rownum=1","-DBType Oracle %IQSHIP_CONN% %IQSHIP_PASS%") = "O", "OD", ""))

Originally posted by: Edward_chan4

Thanks. I tried your codes but there're still problems.
How to correct these
M113 ERROR:

Map: f_cargo_remarks Output: TextFunctCd Element:FTX2

Argument #1 for function NUMBERTOTEXT is invalid.

M105 ERROR:

Map: f_cargo_remarks Output: TextFunctCd Element:FTX2

Rule references unknown type: BOOKING_NO_ID Column:Row:BKHeader.

 

Total errors: 2. Total warnings: 0.

due to this?
=IF (DBLOOKUP("SELECT DECK_IND FROM cargo_details WHERE bl_no_id="+NUMBERTOTEXT(BOOKING_NO_ID Column:Row:BKHeader)+" and rownum=1","-DBType Oracle %IQSHIP_CONN% %IQSHIP_PASS%") = "U", "UN", IF (DBLOOKUP("SELECT DECK_IND FROM cargo_details WHERE bl_no_id="+NUMBERTOTEXT(BOOKING_NO_ID Column:Row:BKHeader)+" and rownum=1","-DBType Oracle %IQSHIP_CONN% %IQSHIP_PASS%") = "O", "OD", ""))

Many Thanks & Best Regards,
Edward

Originally posted by: Edward_chan4

Any help please?