Oracle Objects for OLE
Release 9.2

Part Number A95895-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents

Master Index

Feedback

Modifying Attributes of an Embedded/Value Instance

If the object instance is retrieved using a dynaset object, it's attribute values can be modified between a Dynaset Edit/Update pair. The following example modifies the street and city attribute values of the ADDRESS object instance.

set OO4OSession = CreateObject("OracleInProcServer.XOraSession")

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

set Person = hrDb.CreateDynaset("select * from person", 0&)

set Address = Person.Fields("Addr").Value

Person.Edit

Address.Street = "Oracle Parkway"

Address.City = "Redwood shores"

Person.Update


 
Oracle
Copyright © 1994, 2002 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents

Master Index

Feedback