Hi All,
I am using Open Edge 10.2B, Microsoft Windows XP Version 2002 SP3,
I need SQL Query for the below Piece of Progress Code if any Expert in SQL as Well as Progress Developer Can help me?
FOR EACH arm.loadheader NO-LOCK:
/* below customer can contain may customer for the single load-id so i need to get first record from the below arm.Cust TABLE */
FIND FIRST arm.cust
WHERE arm.cust.customer_nbr = arm.loadheader.cust_nbr
NO-LOCK NO-ERROR.
/* As loadheader contains freight code as well as Carrier code i am assigning below with 2 variables(pv_freight_code_desc, pv_code_desc) and finally displaying it in single shot */
FIND FIRST arm.usertable
WHERE arm.usertable.flag_active
AND arm.usertable.Codetype = "FREIGHT"
AND arm.usertable.codevalue = arm.loadheader.freightcode
NO-LOCK NO-ERROR.
pv_freight_code_desc = arm.usertable.codedesc.
FIND FIRST arm.usertable
WHERE arm.usertable.flag_active
AND arm.usertable.Codetype = "CARRIER"
AND arm.usertable.codevalue = arm.loadheader.carriercode
NO-LOCK NO-ERROR.
ASSIGN pv_code_desc = arm.usertable.codedesc.
DISP
arm.loadheader.load_id
arm.loadheader.cust_nbr
arm.cust.full_name
arm.loadheader.carriercode
pv_code_desc
arm.loadheader.freightcode
pv_freight_code_desc
WITH 2 COL.
END.
I need Equivalent SQL statement for the above Progress Query.
Please help me. Thanks in Advance
Regards,
Raj
(Jr.Developer)
I am using Open Edge 10.2B, Microsoft Windows XP Version 2002 SP3,
I need SQL Query for the below Piece of Progress Code if any Expert in SQL as Well as Progress Developer Can help me?
FOR EACH arm.loadheader NO-LOCK:
/* below customer can contain may customer for the single load-id so i need to get first record from the below arm.Cust TABLE */
FIND FIRST arm.cust
WHERE arm.cust.customer_nbr = arm.loadheader.cust_nbr
NO-LOCK NO-ERROR.
/* As loadheader contains freight code as well as Carrier code i am assigning below with 2 variables(pv_freight_code_desc, pv_code_desc) and finally displaying it in single shot */
FIND FIRST arm.usertable
WHERE arm.usertable.flag_active
AND arm.usertable.Codetype = "FREIGHT"
AND arm.usertable.codevalue = arm.loadheader.freightcode
NO-LOCK NO-ERROR.
pv_freight_code_desc = arm.usertable.codedesc.
FIND FIRST arm.usertable
WHERE arm.usertable.flag_active
AND arm.usertable.Codetype = "CARRIER"
AND arm.usertable.codevalue = arm.loadheader.carriercode
NO-LOCK NO-ERROR.
ASSIGN pv_code_desc = arm.usertable.codedesc.
DISP
arm.loadheader.load_id
arm.loadheader.cust_nbr
arm.cust.full_name
arm.loadheader.carriercode
pv_code_desc
arm.loadheader.freightcode
pv_freight_code_desc
WITH 2 COL.
END.
I need Equivalent SQL statement for the above Progress Query.
Please help me. Thanks in Advance
Regards,
Raj
(Jr.Developer)