METHOD:

clone

DESCRIPTION:

PROPERTY OF:

ADORowset

SYNTAX:

<oRef>.clone()

<oRef>

The rowset object to be cloned.

DESCRIPTION:

You can use clone() method to create a duplicate rowset object from an existing rowset object. 

An important advantage of this method is that instead of creating two independent rowsets, it creates two rowset objects that point to the same source data.

This feature allows you to change the current row in the clone, while keeping the current record same in the original rowset object or vice versa. 

Using this method is more efficient than creating a new rowset with the same source definition.

It saves an extra trip to the database server. 

If you make changes to a rowset, then those changes will be visible in all clones. 

If you requery on the original rowset, the clones will no longer be synchronized to the original. 

Similarly if you close the original rowset then it won't close the clones or vice versa. 

You can only clone a ADORowset object that supports bookmarks.