Is there a reason you don't want to use a begin transaction, then insert everything, then end the transaction? It is extremely efficient to do this.
Shawn -----Original Message----- From: Xuer [mailto:[EMAIL PROTECTED] Sent: Monday, June 14, 2004 11:56 PM To: [EMAIL PROTECTED] Subject: [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 PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
