To copy rows programmatically the subroutine CopyRow_Sub has been added. This takes five parameters, identical to the corresponding TCL command as follows - CopyRowSub(SourceTableName, SourceRowList, DestinationTableName, DestinationRowList, Options) where
SourceTableName Source table name.
SourceRowList Field mark delimited list of rows to copy. Use an asterisk
for all rows.
DestinationTable
Name Destination table name. Leave blank for same table.
DestinationRow
List Field mark delimited list of rows to copy to. Blank for
same row names.
Options As documented with two additional undocumented options, U
and B. U should be used as the last option and any text
following the U will be used in the progress message on the
statusline - E.G. "U%P%% through the table". B puts
transaction control on the target and treats the copy as a
single transaction. If any of the rows fail to copy the
transaction is rolled back, otherwise it is committed and
the transaction control removed. (Thanks to Alan Humphrey
for the B docs)
(Volume 4, Issue 6, Pages 10,11)
