Home » Developer & Programmer » Forms » displaying multiple rows retured from a query (oracle forms,6i,xp)
displaying multiple rows retured from a query [message #342720] Sun, 24 August 2008 11:11 Go to next message
yoonus.it@gmail.com
Messages: 109
Registered: June 2007
Location: kuwait
Senior Member
I have two tables EMP_HEAD,EMP_TIME_Sheet. on this one i have created a master detail relation. When a user enters an head_id i want to select all employeed under him from enother table called employees and display in the emp_time.name item.

I am fetching values from another table that doesnt have a master detail relation with this table.

if only one emplyee is there under the head i know i can just use select statment with and display value on emp_time_sheet.name. It will return more than one employee ids.

Looking forward to your supporting

Thank YOu Smile

Re: displaying multiple rows retured from a query [message #342804 is a reply to message #342720] Mon, 25 August 2008 03:09 Go to previous messageGo to next message
mudabbir
Messages: 235
Registered: April 2006
Location: Kuwait
Senior Member

Define a cursor to fetch all the employees for that Head_Id and display the employee names in a loop
Re: displaying multiple rows retured from a query [message #342962 is a reply to message #342720] Mon, 25 August 2008 11:43 Go to previous message
yoonus.it@gmail.com
Messages: 109
Registered: June 2007
Location: kuwait
Senior Member
Thank you very much mudabbir Smile
Previous Topic: webutil : Open Word.Application
Next Topic: client_host(, NO_SCREEN) still displays windows
Goto Forum:
  


Current Time: Sun Dec 11 08:05:13 CST 2016

Total time taken to generate the page: 0.04292 seconds