Normal usage would be to create a connection via connect , select a database via selectdb , query or execute sql commands via query and exec , close the query via endquery , and close the connection using disconnect . Returns the handle from that connection. Takes two optional arguments, the userid and password. After doing a connect you must selectdb . Use with fetchrow and endquery .
Returns handle to result set, to be used when fetching rows with fetchrow .
Must be called once the query is completed and the results have been fetched. Must be executed after a query statement. The row is returned as a tcl list. If there are no more rows available an empty string is returned. In previous versions query returned the number of rows.