SQLite Forum

Novice question concerning tcl sqlite and eval options and reusing prepared statements
A partial response:

Nothing special is needed to re-use prepared statements. And no need to reset. By default 10 statements will be prepared and cached, and it is all automatic.

I had done a lot of stuff with Tcl and SQLite before TDBC came along, and I have not used it. If I did, it would probably be to be able to use the same code for SQLite and other DB systems. But it does look pretty neat.

Hope this helps, at least a little,

Gerry Snyder