Re: [sqlite] a bunch of questions about SQLite from new user

Vladimir, Thank you for your responses. One short followup: A. what happens to the zSql? Is it copied or it is assumed that this is a static text? Suppose I call sqlite3_prepare in one place and immediately release dynamically allocated text. sqlite3_prepare parses only the first statement. Then

Re: [sqlite] a bunch of questions about SQLite from new user

I can take a crack at some of these... On Tue, 26 Oct 2004 23:17:00 -0500, Tom <[EMAIL PROTECTED]> wrote: > 1. sqlite3_prepare( > sqlite3 *db, > const char *zSql, > int nBytes, > sqlite3_stmt **ppStmt, > const char

[sqlite] a bunch of questions about SQLite from new user

Hello, I am a new SQLite user. I look at the documentation and there are a couple of things which are not clear to me and I could not find info in documentation or google. I could probably write some code to test and find answers to the following questions but it actually might be better to