Module: SQLite ()

Description:

This module lets you connect to a SQLite database. You can execute SQL statementes and retrieve the results using Tcl.

Connections:

Ports:

Filename

The path of the database.

Commands:

exec <SQL statement>
Returns the result of the SQL statement as a nested Tcl list. Inner list elements have the following form:

     { (<rowname> <value>)* }

You can iterate over the result with

    foreach row [SQLite exec "<statement"] {
        foreach {column value} $row {
            ...
        }
    }