Skip Headers

Oracle® Objects for OLE Developer's Guide
10g Release 1 (10.1)

Part Number B10118-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Feedback

Clone Method

See Also

Applies To

OraDynaset

Description

Returns a duplicate dynaset of the specified dynaset.

Usage

Set oradynaset2 = oradynaset1.Clone

Set oradynaset2 = oradynaset1.DbClone

Remarks

The method creates a duplicate dynaset of the one specified. The original and duplicate dynasets have their own current record. However, the new dynaset is not positioned on any row and has its EOF and BOF conditions set both to True. To change this, you must explicitly set a current row on the new duplicate with a Move or Find method.

Using Clone has no effect on the original dynaset. You cannot add, update, or remove records from a dynaset clone.

Use Clone to perform an operation on a dynaset that requires multiple current records.

A clone dynaset does not have all the properties set similar to a normal dynaset. The CacheBlock, CacheSliceSize, CacheSlicePerBlock, and FetchLimit are all set to Null.

Bookmarks of a dynaset and its clone are interchangeable; bookmarks of dynasets created with separate CreateDynaset methods are not interchangeable.