| Oracle Forms [message #81133] |
Tue, 14 January 2003 22:32  |
Lissy
Messages: 3
Registered: January 2003
|
Junior Member |
|
|
Can I retrieve data from the any row(not first row) say second row of the datablock when the data block is displayed in tabular style?
The problem I am facing I have a master- detail relations. In the detail data block say there is a field 'Id'. The description of the field say 'Name'..
are in another table. I like to display the corresponding description of the Ids when all the Ids are shown.I have placed them in a tabular style. I am using cursors to retrieve the name and place it in the data block(tabular form) Since there are more than one Ids the name was overwritten and last Id is displayed in the tabular style data block.
Is there any other option?
Thank you.
|
|
|
|
| Re: Oracle Forms [message #81183 is a reply to message #81133] |
Tue, 21 January 2003 04:27  |
magnetic
Messages: 324
Registered: January 2003
|
Senior Member |
|
|
Add to your plsql code
and rownum=n where n is a number and shows the n-th record of name/description
Example
and rownum=1 show the first found record
Good luck.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
