| Oracle Forms - calling a form from a form [message #350668] |
Thu, 25 September 2008 18:59  |
cool_coder
Messages: 17
Registered: September 2008
|
Junior Member |
|
|
Hi,
FORM-A has customer orders and in the order detail it lists out all the associated items to that order.
In the list of item screen , there is click to get item details and that one takes to another form FORM-B.
The problem is : If there are 4 items liste ( FORM-A) and if any of the item is highlited and clicked to go to item-detail screen (FORM-B) the form B shows always the details of the first item of FORM-A.
Reason I found is - when call to FORM B happens, before that there is logic
Clear_Block(No_validate);
Execute_Query;
and this statment fluses out the block.
How to retain the focus on the desired item using after these
execcute_query?
Please advise.
Thanks in advance
|
|
|
|
| Re: Oracle Forms - Calling a form from a form [message #350758 is a reply to message #350668] |
Fri, 26 September 2008 03:51  |
rajy_salim
Messages: 204
Registered: January 2008
Location: Beirut - Lebanon
|
Senior Member |
|
|
Dear,
- Create a parameter, assign the value of the identifier of the item in FORM-A to it, and pass it to FORM-B when calling it.
- In the WHERE-CLAUSE of the data block in FORM-B, you add the filter on the foreign key field (it must be equal to the paramater passed), and then you execute query. Then only the detail of the chosen item in FORM-A will be retrieved in FORM-B.
P.S. if the identifier of the item in FORM-A is composed of several columns, you must create as many paramaters as these columns to pass all of them in your call.
Rajy
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
