I have successfully embedded sqlite and tcl inside my application, which has a database open at all times.
I use TCL as a "macro" language, so users can control the database. When processing a TCL script, I open a second copy of the same database file, run the script, then close the file. I am wondering if it is possible to use the same sqlite database handle in both the application and TCL scripting -- so I can eliminate the need to keep re-opening and closing the database in TCL every time I run a user script. The problem? In testing, I created a table (modified the schema) in a TCL script, and the next time I attempted to write to the database using the application's handle, I got an error -- schema modified. As a developer, I know reissuing the database write will work, but that is hard to explain to a user who sees a flakey program. Thanks Randall Fox
