Hello,
ist there an alternative for this?
> In a script you can use this:
>
> insert into foo (test) values ('Hello
> world');
The reason is: I'm generating my "insert into"-lines in Excel. Once one of the
cells contains a linebreak, the copied value from Excel has an " at the
beginning and at the end, which breaks the SQL script.
I seem not to be able to find a solution in / for Excel, so I thought that
Firebird might have a solution for such a case.
I would try to replace the linebreaks in Excel with required chars etc., so
that the script still works and also the linebreaks don't get lost and get
inserted correctly.
--- In [email protected], "Dimitry Sibiryakov" <SD@...> wrote:
>
> On 24 Mar 2004 at 9:10, diwic2 wrote:
>
> >How do I insert linebreaks into a string with ISQL?
> >
> >I'm looking for something like this:
> >
> >insert into foo (test) values ("Hello"+#13#10+"world")
>
> In a script you can use this:
>
> insert into foo (test) values ('Hello
> world');
>
> SY, Dimitry Sibiryakov.
>
