I tried:
ON TABLE HOLD COMT
ON TABLE HOLD COMMA
ON TABLE HOLD LOTUS
ON TABLE PCHOLD LOTUS
(All from the information from helpfile)
And all result in a file of blank format with NO extension!

Is it actually banned to save in other format rather than xls, pdf, doc?

This message has been edited. Last edited by: minos4,

All are correct, the error is in the code, not the hold format.

post the code, between code tags if possible as it maitains the indentation(if you've used any)

Also try and repro with a standard IBI Focus DB such as car then we can all play.

I just did this:

APP HOLD mydirname
TABLE FILE CAR
SUM SALES
BY COUNTRY
ON TABLE HOLD AS COMTHOLD FORMAT COMT
END

Got this:

91 Nov 05 13:14 comthold.csv
187 Nov 05 13:14 comthold.mas

And this:

more comthold.csv
"COUNTRY","SALES"
"ENGLAND",12000
"FRANCE",0
"ITALY",30200
"JAPAN",78030
"W GERMANY",88190

minos4,

I believe the problem is that you left out the keyword FORMAT. It should be:

ON TABLE HOLD FORMAT COMT
ON TABLE HOLD FORMAT COMMA
ON TABLE HOLD FORMAT LOTUS
ON TABLE PCHOLD FORMAT LOTUS

This message has been edited. Last edited by: jgelona,

jgelona

That's why I asked to see the code, because I just assumed that was a typo.

It's not like me to be so in direct.

Yes JG, it was a typo. The XLS format does work, but not CSV.
Anyway, I found alternatives. Just saved the hold file onto harddisk forcefully named it *.CSV! And extract it later.