Home » Developer & Programmer » Forms » Oracle Forms - calling a form from a form
Oracle Forms - calling a form from a form [message #350668] Thu, 25 September 2008 18:59 Go to next message
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 Go to previous messageGo to next message
rajy_salim
Messages: 204
Registered: January 2008
Location: Beirut - Lebanon
Senior Member
Dear,

  1. 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.
  2. 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
Re: Oracle Forms - Calling a form from a form [message #350853 is a reply to message #350758] Fri, 26 September 2008 13:29 Go to previous messageGo to next message
cool_coder
Messages: 17
Registered: September 2008
Junior Member
Thanks much for your response. I wil try your advise but have one limiations though , that FORM-B do not want to chncge if it can be avoided.

Thanks Again
Re: Oracle forms help -- calling another form after execute query [message #350877 is a reply to message #350668] Fri, 26 September 2008 16:19 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Use a parameter (or a global variable), transfer its value from Form_A into Form_B, set the data block's DEFAULT_WHERE property to a new value (using this parameter or global variable) and THEN execute a query.

[EDIT] Sorry, didn't see the Rayj's answer as @cool_coder had created two topics with the same question.

[Updated on: Fri, 26 September 2008 16:37]

Report message to a moderator

Previous Topic: Run Report Without Report Engaine
Next Topic: Install form developer 10 g on Vista
Goto Forum:
  


Current Time: Fri Dec 09 04:19:24 CST 2016

Total time taken to generate the page: 0.08856 seconds