CopyToClipboard Method

Example

Applies To

OraDynaset

Description

Copy the rows from the dynaset to the Clipboard in text format.

Usage

OraDynaset.CopyToClipboard(NumOfRows ,colsep [optional],rowsep [optional] )

Arguments

NumOfRows	Number of rows to be copied to the dynaset ,
colsep	Column separator in CHAR to be inserted between columns
rowsep	Row seperater in CHAR to be inserted between Rows

Remarks

This method is used to facilitate transfer of data between Oracle Object for OLE’s cache (dynaset) and Windows applications such as Excel or Word. CopyToClipboard copies data starting from current position of the dynaset up to the last row.

Default column separator is TAB (ASCII 9).

Default row separator is ENTER (ASCII 13).