On Thu, 2005-04-28 at 11:23 -0500, Dinsmore, Jeff wrote: > Running on Windows Server2003, Tcl 8.4.6, Sqlite 2.x (if I knew how to > determine my exact rev of Sqlite, I'd tell you that too) >
There are no known crashing issues with the latest version of SQLite 2.8.16. I do not recall any crashing issues in prior versions, but that just might be because my memory is failing :-) Check the change logs to verify. http://www.sqlite.org/changes.html > > I can update to Sqlite 3 if this will fix the problem, but I'd like some > indication that this will fix these crashes before I put in the time to > upgrade. > Even without crashes, I think you will be much happier with version 3, especially if you are using the Tcl interface. You can now include Tcl variables as part of your query and the Tcl interface will automatically reach in and pull out the appropriate values for you. For example: db eval {INSERT INTO table1 VALUES($value1,$value2,$value3)} Note that the SQL statement is in {...} and that you do not need to quote or escape the values in $value1, $value2, or $value3. SQLite reaches in and grabs the content of the variables and uses that content without making unnecessary copies or conversions. The technique above runs much faster faster. And, the latest Tcl interface caches prepared statements, making it faster still if the same statement is run multiple times. -- D. Richard Hipp <[EMAIL PROTECTED]>
