ADO Clone Method
 Complete Recordset Object Reference
The Clone method allows you to create a duplicate Recordset from an existing Recordset.
You can use this method to create multiple, duplicate Recordset, particularly if
you want to edit more than one current record in a set of records. This method
is much more efficient than creating, opening, and closing a new Recordset equal
to the original.
When you clone a Recordset you actually just create a new pointer to the same
Recordset, therefore any changes you make to one Recordset will be visible in all of its clones. However,
if you execute a Requery on the original Recordset, the clones will no longer be synchronized to the original.
The provider must support bookmarks on the Recordset object to create clones. Bookmarks are interchangeable;
a bookmark reference from one Recordset object refers to the same record in any of its clones.
Note: The filter of the original Recordset will not be applied to the clone.
To copy an existing filter: objRecordsetNew.Filter=objRecordsetOriginal.Filter
Note: When you close the original Recordset none of the copies will be
closed. You will have to close the clones one by one.
Syntax
Set objRecordsetClone=objRecordset.Clone(locktype)
|
| Parameter |
Description |
| objRecordsetClone |
The clone Recordset to be created |
| objRecordset |
The Recordset to be cloned |
| locktype |
Optional. A LockTypeEnum
value that specifies the lock type |
LockTypeEnum Values
| Constant |
Value |
Description |
| adLockUnspecified |
-1 |
The clone is created with
the same lock type as the original Recordset |
| adLockReadOnly |
1 |
The clone is a read-only Recordset |
Complete Recordset Object Reference
The Ektron Intranet
lets you do everything you need to do on your corporate intranet and everything you want to do... all with just one application.
What can you do with the Ektron Intranet? |
|
Navigate through content, documents, assets, colleagues and workgroups quickly and intuitively with enterprise search |
|
Communicate with friends and colleagues with forums, message boards and corporate blogging using the new Social Networking Platform |
|
Promote collaboration among coworkers in your organization through project workspaces where others can efficiently find information and work together |
|
Personalize your company profile by bookmarking and organizing favorite content, uploading assets, posting photos, blogging, and more |
|
Interact with features like tagging, flagging, wikis and ratings found in the Web 2.0 Toolbox |
 |
Author/edit content, manage navigation, menus, audit trails, workflow and approvals with the best in breed Content Management |
|
|
|
|
See why there are 20,000+ Ektron integrations worldwide.
Request an
INSTANT DEMO or download a
FREE TRIAL today. |
|
HOME
Printer friendly page
