Version 3 Technical Highlights - Copying Rows Programmatically [Revelation On-Line Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== Version 3 Technical Highlights - Copying Rows Programmatically=====

^Published By^Date^Version^Knowledge Level^Keywords^
|Sprezzatura Ltd|01 NOV 1992|3.0+|EXPERT|COPYROW_SUB, COPY, ROW|

==== CopyRow_Sub ====

To copy rows programmatically the subroutine CopyRow_Sub has been added.
This takes five parameters, identical to the corresponding TCL command as
follows - 

<code>
CopyRowSub(SourceTableName, SourceRowList, DestinationTableName, DestinationRowList, Options)
</code>

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)