Oracle Objects for OLE
Release 9.0.1

Part Number A90173-01

Home

Book List

Contents

Master Index

Feedback

Modifying Collection Elements

If the collection instance is retrieved using a dynaset object, element values can be modified between a Dynaset Edit/Update pair. The following example code modifies the second element value of an ENAMELIST collection instance.

set OO4OSession = CreateObject("OracleInProcServer.XOraSession")

set hrDb = OO4OSession.OpenDatabase("ExampleDb", "scott/tiger", 0)

Set OraDynaset = hrDb.CreateDynaset("select * from department", 0&)

Set EnameList = OraDynaset.Fields("ENAMES").Value

OraDynaset.Edit

EnameList(2) = "Chris"

OraDynaset.Update


 
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.

Home

Book List

Contents