B
Bharat
Guest
I am new to progress 4GL. I always use below query to export data from temp table as .csv file. To give header labels I have hard coded. Is it possible to get the labels from temp table fields itself? If yes pls help me by modifying the query.
Continue reading...
Code:
DEFINE TEMP-TABLE ttdata NO-UNDO
FIELD cCustomerName LIKE Customer.NAME
FIELD cAddress LIKE Customer.Address
.
OUTPUT TO VALUE(SESSION:TEMP-DIRECTORY + "temp.csv").
PUT UNFORMATTED "customer Name,Customer Address" SKIP.
FOR EACH ttdata NO-LOCK:
EXPORT DELIMITER "," ttdata.
END.
OUTPUT CLOSE.
Continue reading...