| Subject | Re: [firebird-support] external file table and CR/LF |
|---|---|
| Author | Ann Harrison |
| Post date | 2003-12-09T19:59:25Z |
Brian Schembri wrote:
CR/LF, create a table definition that maps to that table, including a
char(2) field for the CR/LF, then create a table in the database with a
char(2) field called CR_LF. Insert into the database table selecting
values from the external table. Now you have a CR/LF in the database
which you can include when you insert into your external file.
Regards,
Ann
>>... IWhat I've done when I need that is to create a text file containing a
>>cannot get to insert a CR/LF in the rows.
>>
CR/LF, create a table definition that maps to that table, including a
char(2) field for the CR/LF, then create a table in the database with a
char(2) field called CR_LF. Insert into the database table selecting
values from the external table. Now you have a CR/LF in the database
which you can include when you insert into your external file.
Regards,
Ann