Re: [sqlite] sqlite3_exec - statement length limit?

"SQLiter" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > b. Is it better to recursively call Prepare, Step & Finalize from my > Delphi App It is better to call Prepare once (with a parameterized statement), then (bind, step, reset) multiple times in a loop, then Finalize at the

Re: [sqlite] sqlite3_exec - statement length limit?

Thanks. The issues regarding injection attacks are not relevant in my present context. What I wanted to know was this - a. I want to selectively discard N rows from a SQLite dB table. N could be 1 but again it could be, rarely, 10,000 b. Is it better to recursively call Prepare, Step &

Re: [sqlite] sqlite3_exec - statement length limit?

2008/11/25 SQLiter <[EMAIL PROTECTED]>: > > Is there a limit on the length of the SQL that can be executed using this > function. I mean stmt1;stmt2;...stmtn upto what length. Even if there is > no limit is it nevertheless prudent not to exceed a certain maximum length? > --

[sqlite] sqlite3_exec - statement length limit?

Is there a limit on the length of the SQL that can be executed using this function. I mean stmt1;stmt2;...stmtn upto what length. Even if there is no limit is it nevertheless prudent not to exceed a certain maximum length? -- View this message in context: