Home » Developer & Programmer » Forms » how to get data from a text item
how to get data from a text item [message #261521] Wed, 22 August 2007 23:04 Go to next message
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 Go to previous message
Littlefoot
Messages: 20901
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.
Previous Topic: appropriate trigger
Next Topic: Want to know better reporting tool
Goto Forum:
  


Current Time: Fri Dec 09 13:42:31 CST 2016

Total time taken to generate the page: 0.13014 seconds