Stefan Kuhr <[EMAIL PROTECTED]> wrote: > Hello everyone, > > this might be a real dumb question, but I am relatively new to database > programming and in particular to sqlite, so anyway, here it goes: > > Suppose I have a call to sqlite3_exec in my code and it calls into the > callback function passed as the third parameter to this sqlite3_exec call. > Is it possible to create another sqlite3 object with a sqlite3_open to the > same database file from within this callback? Or in other words: Can I fire > a query from within a callback of a query, ore more or less nested queries? > Is this supported or even a common pattern? >
Yes, this is it supported. SQLite does it itself internally when processing CREATE TABLE statements, among other places. -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------