1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

  2. Anuncie Aqui ! Entre em contato fdantas@4each.com.br

Progress Database 4GL - Display Result Isssue

Discussão em 'StackOverflow' iniciado por fdantas, Janeiro 8, 2018.

  1. fdantas

    fdantas Administrator Moderador

    I run the statement below. However, the result did not display in one row. It automatically puts the result in several rows. It is too difficult to read.

    Can someone advise how to put the result in one row? I have same issue when I export the result to a .csv file.

    enter image description here

    FOR EACH r4_wms.wShipmentDet NO-LOCK,
    FIRST r4_wms.wShipment OF r4_wms.wShipmentDet NO-LOCK where wShipment.shipmentNO>5000,
    FIRST r4_wms.wOrder OF r4_wms.wShipmentDet NO-LOCK,
    FIRST r4_wms.wOrderline OF r4_wms.wShipmentDet NO-LOCK
    BY wShipment.ShipmentNo DESC:


    Display
    wOrder.OrderNo
    wOrder.OrderDate
    wShipment.ShippedDate
    wOrder.CustID
    wOrder.sourceDoc
    wOrder.srcPO
    wShipmentDet.ShipStatus
    wShipment.appointmentdate
    wShipment.Appointmentno
    wOrder.shiptoName
    wShipment.carrierID
    wShipmentDet.ItemID
    worderline.qtyorder
    worderline.QtyShipped
    wShipment.Volume
    wShipment.Weight SKIP
    wOrder.Remarks.

    END.

    Continue reading...

Compartilhe esta Página