Skip to Content
0
Former Member
Aug 12, 2009 at 10:09 AM

IF statement on Formatted search

82 Views

Dear experts,

Please help me on the syntax to use IF statement on a formatted search. Below is my logic but doesnt work

IF $[OITM.ItmsGrpCod ='133'] and $[OITM.ItemCode] = $[wor1.Itemcode]

BEGIN

SELECT STR((($[wor1.U_Colourant.Number] * 0.651 )/1000),8,6)

END

ELSE

SELECT $[wor1.Baseqty]

regards