Oracle® Objects for OLE Developer's Guide 10g Release 1 (10.1) Part Number B10118-01 |
|
Applies To
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.