sqlinsert

A procedure for doing an SQL INSERT and optionally returning the identity column value.

Arguments:

tablename - the name of the table to insert data into.

data - a Tcl list of columnname-value pairs that define the data to be inserted.

get_identity - a boolean value that determines whether or not the function should retrieve and return the identity value.

Returns:

If the get_identity argument is set to ,1 then the identity column value for the new record will be returned. Otherwise, 0 will be returned.

Errors:

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