Hi all,
I'm a newbie at 4GL and Progress and I have what is probably a very simple question to most of you. I would like to format a row of data to csv using the EXPORT function but still have it output to stdout. My understanding of EXPORT is that it creates a .csv file and we are trying to bypass that but still be able to use this function. Is this possible?
Here's my code:
Thanks,
Rick
I'm a newbie at 4GL and Progress and I have what is probably a very simple question to most of you. I would like to format a row of data to csv using the EXPORT function but still have it output to stdout. My understanding of EXPORT is that it creates a .csv file and we are trying to bypass that but still be able to use this function. Is this possible?
Here's my code:
Code:
define variable cParamList as character no-undo.
define variable pbuilding as character no-undo.
define variable punit as character no-undo.
define variable pcharge-date as date no-undo.
assign cParamList = session:parameter
pbuilding = entry(1,cParamList,"|")
punit = entry(2,cParamList,"|")
pcharge-date = 01/01/2007.
def temp-table tt
field t-bldg like rm-res.building
field t-unit like rm-res.unit
field t-res like rm-res.resident
field t-date as date.
for each rm-chg no-lock where
rm-chg.building = pbuilding AND
rm-chg.unit = punit AND
rm-chg.chg-date >= pcharge-date:
create tt.
assign t-bldg = rm-chg.building
t-unit = rm-chg.unit
t-res = rm-chg.resident
t-date = rm-chg.chg-date.
/* create csv of this row and send to stdout*/
display tt.
end.
Thanks,
Rick