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]