Re: [sqlite] Trapping errors in the TCL interface to sqlite (libtclsqlite3.so)

On Fri, Jun 3, 2011 at 3:01 PM, Simon Slavin wrote: > However, there are ways to do many things the dot commands do.  For instance, > > http://www.sqlite.org/pragma.html#pragma_database_list Got it, Simon, this works: set dblist [db1 eval {pragma database_list;}] puts

Re: [sqlite] Trapping errors in the TCL interface to sqlite (libtclsqlite3.so)

On 3 Jun 2011, at 9:58pm, Keith Christian wrote: > I have another question about the TCL interface: What is the syntax > to execute the commands available at the sqlite> prompt? > > Suppose I want to run the ".databases" command, usually executed from > the sqlite> prompt. There is none. The

Re: [sqlite] Trapping errors in the TCL interface to sqlite (libtclsqlite3.so)

On Fri, Jun 3, 2011 at 2:42 PM, Simon Slavin wrote: > Use the form > > CREATE TABLE IF NOT EXISTS ... > > http://www.sqlite.org/lang_createtable.html Thank you, Simon. I have another question about the TCL interface: What is the syntax to execute the commands available

Re: [sqlite] Trapping errors in the TCL interface to sqlite (libtclsqlite3.so)

On 3 Jun 2011, at 9:26pm, Keith Christian wrote: > Problem - After the first pass, it obviously attempts to CREATE TABLE > again, even though the table already exists (Lines 22-25 below.) > > Is there a function provided by libtclslqite3.so that could either > list the existing tables, or trap

[sqlite] Trapping errors in the TCL interface to sqlite (libtclsqlite3.so)

I've successfully compiled libtclslqite3.so on CentOS 5.5 Linux and have run the example sqlite3 code from http://www.sqlite.org/tclsqlite.html. The TCL script below is almost verbatim from the above web page's examples. Problem - After the first pass, it obviously attempts to CREATE TABLE

[sqlite] libtclsqlite3.so

How do I build libtclsqlite3.so? The generated Makefile (on GNU/Linux) seems to have no targets for this. In general the tcl stuff seems suboptimal---tclsqlite3 seems to want to build against static versions of the tcl library, but who builds tcl statically?