sqlexecute

A procedure for executing an arbitrary SQL statement and returning a single result set.

Arguments:

statement - the SQL statement to execute.

limit - the maximum number of rows to return ( optional - 0=unlimited ).

offset - an offset index into the result set ( optional - default 0 ).

Returns:

A list of data that represents the results of the query elements:

­    the number of rows of data returned

­    the number of columns of data returned

­    a Tcl list of the returned data column names

­    results by column then row. The first character of each result value is either 0 or 1 where 1 means that the value is NULL

Errors:

Any errors that occur are handled as Tcl errors and can be caught with the catch command.