Home » Developer & Programmer » Forms » Form Problem
Form Problem [message #222934] Wed, 07 March 2007 00:28 Go to next message
u263066
Messages: 47
Registered: March 2007
Member
Guys,

I have 2 table a and b for master and details blocks.

Now on the master block, there is one non database feild called 'X' which is basically deptid of third table called Dept.

the details are in tabular form with number of records is set to 3.

The field X has LOV and based out of select deptid from dept. There is button called "" on pressing want to display data based by filter chossen in LOV.

2 column of the table b need to pupulated by the value from emp table based out of filter of dept LOV.

Lets say user has selected Dept 30 and in emp table there are 6 records for this department. I want to populate two of the field of B data elemnents.

I did by useing cursor but what it only display last row of the data set in first element of tabular row.

can anyone advice how to achive, this.
Thanks in advance
Re: Form Problem [message #223016 is a reply to message #222934] Wed, 07 March 2007 03:44 Go to previous messageGo to next message
scorpio_biker
Messages: 154
Registered: November 2005
Location: Kent, England
Senior Member
Hi,

Sounds like you might have missed a next_record in your cursor loop, meaning it's not moving onto the next record in your block b?



Re: Form Problem [message #225413 is a reply to message #223016] Mon, 19 March 2007 22:21 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Populate block using cursor
http://www.orafaq.com/forum/m/605/67467/?srch=populate+block+cursor+create_record#msg_605
and my feelings about it.
http://www.orafaq.com/forum/m/134237/67467/?srch=populate+block+cursor+create_record#msg_134237

David

Oops! I pasted the wrong links.

[Updated on: Mon, 19 March 2007 22:22]

Report message to a moderator

Previous Topic: URGENT!!! FORM BUILDER WITH REPORT BUILDER
Next Topic: MANY BLOCKS IN ONE FORM
Goto Forum:
  


Current Time: Sat Dec 10 16:50:08 CST 2016

Total time taken to generate the page: 0.04948 seconds