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