Hi,
just to clarify: it is sqlite, not the sqlite driver which does not
support newlines in SQL statements. Some other SQL engines like MySQL
do support newlines, so this appears to be a design decision (I don't
know what the standard says). To verify, use these SQL scripts:
-
select
On 13-Oct-08, at 7:15 AM, Markus Hoenicka wrote:
Hi,
just to clarify: it is sqlite, not the sqlite driver which does not
support newlines in SQL statements.
Wow, that's inconvenient. I imagine that must break very many ORM/SQL
generating layers.
--Toby
Some other SQL engines like MySQL
