There is a limit of 1MB per row. See description of the SQLITE_TOOBIG error
below. So if you have a SQL string which size is less than 1MB, it definitly
works. If your single INSERT is more than 1 MB, it definitly does not work.
But you can change this limit in source code and recompile, if you want to
store large text-files in a single row.
SQLITE_TOOBIG
SQLite will not store more than about 1 megabyte of data in a single row
of a single table. If you attempt to store more than 1 megabyte in a single
row, this is the return code you get.
> could i use a long,long sql sentence to insert many items into a table
> once without limit?
> or there IS a limit so i have to accomplish it by doing it for multi
> times?
>
> thanks in advance.:)
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
--
+++ Jetzt WLAN-Router f�r alle DSL-Einsteiger und Wechsler +++
GMX DSL-Powertarife zudem 3 Monate gratis* http://www.gmx.net/dsl
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
