Exactly urayoan, but for more specific this is a code that run in desktop program and needed a similar code with NT
CASE MESSAGE('Are you sure you want to Change Zip Code?, This Change Delivery Charge.','Alert',ICON:Question,+Button:Yes+Button:No,,1)
OF Button:Yes
PUT(BillofLadings)
History::Bil3:Record :=: Bil3:RECORD
SQL{prop:sql} ='select BillofladingId, isnull(ChargeId,0) as ChargeId, PaymentType,0 as ChargeTypeId, ChargeDescription from billofladingcharges where billofladingid= '&Bil3:BillofLadingId & ' AND ChargeDescription = <39>'& 'DELIVERY<39>'
LOOP
NEXT(SQL)
IF ERRORCODE() THEN BREAK.
CASE Bil3:PaymentZone
OF 'C'
Shipper{prop:sql} = 'CALL BolChargesByCharge('&Bil3:BillofLadingId &','&chr(39)&CLIP(SQL:C3)&CHR(39)&','&Bil3:CustomerId&','& 0 &','&CLIP(SQL:C2) & ',0)'
BREAK
OF 'P'
Shipper{prop:sql} = 'CALL BolChargesByCharge('&Bil3:BillofLadingId &','&chr(39)&CLIP(SQL:C3)&CHR(39)&','&Bil3:ShipperId&','& 0& ','&CLIP(SQL:C2) & ',0)'
BREAK
OF 'T'
Shipper{prop:sql} = 'CALL BolChargesByCharge('&Bil3:BillofLadingId &','&chr(39)&CLIP(SQL:C3)&CHR(39)&','&Bil3:PartyId&','& 0 &','&CLIP(SQL:C2) & ',0)'
BREAK
END
END
Charges.Load
Charges.Reset(1)
OF Button:No
Bil3:ShipToZipCode = History::Bil3:Record.Bil3:ShipToZipCode
Bil3:ShipToCity = History::Bil3:Record.Bil3:ShipToCity
Bil3:ShipToState = History::Bil3:Record.Bil3:ShipToState
SELECT(?Bil3:ShipToZipCode)
ThisWindow.Reset(1)
END
END