csv and temp-table !!!

[make]

Hi,
i use the follwoing code, to make a csv-output from my temp-table.

OUTPUT TO "c:\test.csv".

FOR EACH mytable NO-LOCK:

EXPORT DELIMITER ',' mytable.

END. /* End for each */

OUTPUT CLOSE.

But i dont to give out any field of my temp-table, only field1, fiele3,field9.

Is that possible ?

Can anyone give me a tip ?

Please !

Greets
make

 

[Unregistered]

DEFINE STREAM RPT.

OUTPUT TO "c:\test.csv".

EXPORT DELIMITER ','
'Field 1'
'Field 3'
'Field 9'.

FOR EACH mytable NO-LOCK:

EXPORT DELIMITER ',' mytable
mytable.field1
mytable.field3
mytable.field9.

END. /* End for each */

OUTPUT STREAM rpt CLOSE.

Hope this is what you are asking for? :->

 

[Olivier_Desmars]

Another way to do it :



OUTPUT TO VALUE("c:\test.csv").

FOR EACH mytable NO-LOCK:

MESSAGE Mytable.field1 ";" Mytable.field3 ";" Mytable.field6.

END. /* End for each */

OUTPUT CLOSE.



If your MESSAGE statement has no 'VIEW-AS' option, it's redirected to your current OUTPUT file. I always export CSV like this and it works great for me.