Oracle Objects for OLE
Release 9.0.1

Part Number A90173-01

Home

Book List

Contents

Master Index

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.


 
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.

Home

Book List

Contents