OraFAQ Forum: Forms » Good Example for Dynamically populate third list based on first and Second

Home » Developer & Programmer » Forms » Good Example for Dynamically populate third list based on first and Second (XP, ORACLE 10G develop and XE db)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Good Example for Dynamically populate third list based on first and Second [message #414183]

Mon, 20 July 2009 14:50

gurusuryas
Messages: 49
Registered: March 2009
Location: Chennai

Member

Hi friends,

please follow below steps.

1.create countries, locations table:

CREATE TABLE "COUNTRIES"
( "COUNTRY_ID" CHAR(2) CONSTRAINT "COUNTRY_ID_NN" NOT NULL ENABLE,
"COUNTRY_NAME" VARCHAR2(40),

CONSTRAINT "COUNTRY_C_ID_PK" PRIMARY KEY ("COUNTRY_ID") ENABLE,

)
/

CREATE TABLE "LOCATIONS"
( "LOCATION_ID" NUMBER(4,0),
"STREET_ADDRESS" VARCHAR2(40),
"POSTAL_CODE" VARCHAR2(12),
"CITY" VARCHAR2(30) CONSTRAINT "LOC_CITY_NN" NOT NULL ENABLE,
"STATE_PROVINCE" VARCHAR2(25),
"COUNTRY_ID" CHAR(2),
CONSTRAINT "LOC_ID_PK" PRIMARY KEY ("LOCATION_ID") ENABLE,
CONSTRAINT "LOC_C_ID_FK" FOREIGN KEY ("COUNTRY_ID")
REFERENCES "COUNTRIES" ("COUNTRY_ID") ENABLE
)/

2. Insert data into Countries, Locations.

Locations table data :
LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID
"
1000,"1297 Via Cola di Rie","00989","Roma","","IT"
"
1100,"93091 Calle della Testa","10934","Venice","","IT"
"
1200,"2017 Shinjuku-ku","1689","Tokyo","Tokyo Prefecture","JP"
"
1300,"9450 Kamiya-cho","6823","Hiroshima","","JP"
"
1400,"2014 Jabberwocky Rd","26192","Southlake","Texas","US"
"
1500,"2011 Interiors Blvd","99236","South San Francisco","California","US"
"
1600,"2007 Zagora St","50090","South Brunswick","New Jersey","US"
"
1700,"2004 Charade Rd","98199","Seattle","Washington","US"
"
1800,"147 Spadina Ave","M5V 2L7","Toronto","Ontario","CA"
"
1900,"6092 Boxwood St","YSW 9T2","Whitehorse","Yukon","CA"
"
2000,"40-5-12 Laogianggen","190518","Beijing","","CN"
"
2100,"1298 Vileparle (E)","490231","Bombay","Maharashtra","IN"
"
2200,"12-98 Victoria Street","2901","Sydney","New South Wales","AU"
"
2300,"198 Clementi North","540198","Singapore","","SG"
"
2400,"8204 Arthur St","","London","","UK"
"
2500,"Magdalen Centre, The Oxford Science Park","OX9 9ZB","Oxford","Oxford","UK"
"
2600,"9702 Chester Road","09629850293","Stretford","Manchester","UK"
"
2700,"Schwanthalerstr. 7031","80925","Munich","Bavaria","DE"
"
2800,"Rua Frei Caneca 1360","01307-002","Sao Paulo","Sao Paulo","BR"
"
2900,"20 Rue des Corps-Saints","1730","Geneva","Geneve","CH"
"
3000,"Murtenstrasse 921","3095","Bern","BE","CH"
"
3100,"Pieter Breughelstraat 837,"3029SK","Utrecht","Utrecht","NL"
"
3200,"Mariano Escobedo 9991","11932","Mexico City","Distrito Federal,","MX"

3. Download form and compile and Run.

Please write your comments.

Thanks

Guru

Report message to a moderator