sqlcopy

A procedure for copying one row of data to another.

Arguments:

tablename - the name of the table to copy data within.

override_data - an associative array of column names and values to override in the copy.

where - a where clause that determines the records that are to be copied.

get_identity - set to 1 if you want the identity value of the last inserted value (optional).

exclude_columns - a list of columns to exclude from the copy (optional).

Returns:

if get_identity was set to 1, this command returns the identity value of the last row that was inserted. Otherwise, it returns 0.

Errors:

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