| Published By | Date | Version | Knowledge Level | Keywords |
|---|---|---|---|---|
| Sprezzatura Ltd | 01 NOV 1992 | 3.0+ | EXPERT | COPYROW_SUB, COPY, ROW |
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. |
| DestinationTableName | Destination table name. Leave blank for same table. |
| DestinationRowList | 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)