Hi,
When creating a new table with:
CREATE TABLE chk (businessmode CHAR(14),"first name" char(16),"last name" char(18), company char(50),trade CHAR(35), address char(30), address2 char(30), city char(19), flag char(2),ID char(7),serialNO numeric(6,0),_CSV_Separator char(1) default ',', _CSV_Quoter char(1) default '"',_CSV_Header boolean default true)
I see no header line in the created CSV file.
I also set the property
Properties props=new Properties();
props.put("_CSV_Header","true");
props.put("_CSV_Separator ", ",");
props.put("_CSV_Quoter ", "\"");
prior to creating the table with same effect.
Regards
|
Dear Rodolfo,
The main usage of _CSV_Header is used to read header row and data rows from other applications' CSV files. HXTT Text won't add a CSV header when it create new CSV table, so that the preferable value for _CSV_Header is false. If you wish HXTT Text to add a header row into the new CSV table, please let us know. Your suggestion is welcome.
With best regards,
Dai Wei
|
Thank you for so fast response. I was afraid of that, but also might missed something.
best regards
|
Main
webmaster@hxtt.com