Home » Developer & Programmer » Forms » LOV form errors when using objects
LOV form errors when using objects [message #219282] Tue, 13 February 2007 16:13 Go to next message
sophia_786
Messages: 13
Registered: February 2007
Location: manchester
Junior Member

Hi,

I am currently designing an object-relational databas on oracle 9i.

I am getting errors, early on in this project i was wondering if anyone can help.

I am creating a form using 6i, i want to link an LOV to a field.

the following code created the types and objects.


CREATE TYPE EmpStatus_objtyp AS OBJECT (
EMP_STATUS VARCHAR2(100)
);
/
CREATE OR REPLACE TYPE Employee_objtyp AS OBJECT (
EMP_ID VARCHAR2(9),
EMP_FNAME VARCHAR2(50),
EMP_SNAME VARCHAR2(50),
STATUS_REF REF EmpStatus_objtyp
);
/

CREATE TABLE EmpStatus_objtab OF EmpStatus_objtyp (
PRIMARY KEY (EMP_STATUS))
OBJECT IDENTIFIER IS PRIMARY KEY;

CREATE TABLE Employee_objtab OF Employee_objtyp (
PRIMARY KEY (EMP_ID),
FOREIGN KEY (STATUS_REF) REFERENCES EmpStatus_objtab)
OBJECT IDENTIFIER IS PRIMARY KEY;

INSERT INTO EmpStatus_objtab VALUES ('Permanent');
INSERT INTO EmpStatus_objtab VALUES ('Temporary');
INSERT INTO EmpStatus_objtab VALUES ('Contractor');

I am wanting the STATUS_REF field in the form to bring up an LOV to select a possible status.

thank u in advance






[Updated on: Tue, 13 February 2007 16:17]

Report message to a moderator

Re: LOV form errors when using objects [message #219408 is a reply to message #219282] Wed, 14 February 2007 04:47 Go to previous message
scorpio_biker
Messages: 154
Registered: November 2005
Location: Kent, England
Senior Member
What error are you getting from the LOV?
Previous Topic: Getting computer name from the network
Next Topic: same LOV can fetch differet record for different user ?
Goto Forum:
  


Current Time: Sun Dec 04 04:35:49 CST 2016

Total time taken to generate the page: 0.05823 seconds