Re: [sqlite] what's the character limit of a single sql in sqlite?

- Original Message - From: "Xuer" <[EMAIL PROTECTED]> > 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? Hi, There is no limit using the current sqlite_exec() API fu

Re: [sqlite] what's the character limit of a single sql in sqlite?

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 wan

RE: [sqlite] what's the character limit of a single sql in sqlite?

bject: [sqlite] what's the character limit of a single sql in sqlite? 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

[sqlite] what's the character limit of a single sql in sqlite?

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 PROTECT