FYI: for those interested..
>> Re: Schema change error when using sqlite >> with TCL as a macro language inside an >> application that already has an open db I took a look at the code (tclsqlite.c) and saw I could easily change it to support passing in a pointer to an existing database connection (db already open). I didn't see anything on your website on how to submit changes. So, here is the file I changed. Diff it against 3.0.8. The changes were minimal, and in preliminary testing seems to work just fine. The TCL command line is still the same with one minor difference: sqlite3 db1 0x00000000 -use-existing-connection if the -use-existing-connection is present as above, it will assume 0x00000000 is a pointer to an already opened sqlite3 db. Otherwise the old behavior of opening the supplied filename is used. No testing is done on the open db to see if it is healthy. I assume the user is smart enough to know. If you feel it is worthy, use the changes in your next release. I would prefer if you did, since I won't have to maintain the code myself.. :) Randall Fox <CODE ATTACHMENT REMOVED>

