OraFAQ Forum: Forms » how to get data from a text item

Home » Developer & Programmer » Forms » how to get data from a text item

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

how to get data from a text item [message #261521]

Wed, 22 August 2007 23:04

fam_bila
Messages: 43
Registered: August 2007
Location: pakistan

Member

IN developer 6i ,there is two text item within a block in a canvas.

Fisrt one name as 'class' which have data through an LOV .
second one name as 'session' which should show list of session from table according to the first textitem.

e.g if class text item conttain 'MA'
then the all the session of 'MA' class should be displayed in a lov when i click on text item session

Tables are

class_code
Name Null? Type
------------------------------- -------- ----
SESSION_ID NOT NULL NUMBER
CLASS VARCHAR2(6)

sesion
Name Null? Type
------------------------------- -------- ----
DEGREE_PROG_CODE VARCHAR2(6)
SESSION_ID NUMBER
START_DATE NUMBER
END_DATE NUMBER
SESSION_DESCRIPTION VARCHAR2(30)
SESSION_NO NOT NULL NUMBER

what is code for this?
thanx

[Updated on: Thu, 23 August 2007 00:01]

Report message to a moderator

Re: how to get data from a text item [message #261543 is a reply to message #261521]

Thu, 23 August 2007 00:38

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I'd write a SELECT statement and JOIN 'class_code' and 'session' tables by 'session_id' column, with additional WHERE condition containing the 'class' column.

Report message to a moderator

Previous Topic:	appropriate trigger
Next Topic:	Want to know better reporting tool

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 04:30:29 CDT 2024