OraFAQ Forum: Forms » Download ( Call a form from a Report)

Home » Developer & Programmer » Forms » Download ( Call a form from a Report)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Download ( Call a form from a Report) [message #244805]

Thu, 14 June 2007 02:51

zafarkarachi
Messages: 29
Registered: November 2006
Location: Karachi Pakistan

Junior Member

AOA,

I with my friend Majid Niazi have tried different methods to call a form with values passed from a report.

Here is the simple solution to update the desired record.
Please download the files.

Zafar Iqbal
Karachi
0321-2876518

Attachment: Report_Run_Form.zip
(Size: 20.82KB, Downloaded 23389 times)

Report message to a moderator

Re: Download ( Call a form from a Report) [message #245039 is a reply to message #244805]

Fri, 15 June 2007 01:09

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

I just hope that two people don't try to go from the report to the form at the same time.

David

Report message to a moderator

Re: Download ( Call a form from a Report) [message #245152 is a reply to message #244805]

Fri, 15 June 2007 05:49

zafarkarachi
Messages: 29
Registered: November 2006
Location: Karachi Pakistan

Junior Member

Interesting!!! David

Please download this one as user can update record.

Zafar IQbal

Attachment: invoke_emp.zip
(Size: 35.83KB, Downloaded 23206 times)

Report message to a moderator

Re: Download ( Call a form from a Report) [message #245182 is a reply to message #245152]

Fri, 15 June 2007 07:19

kamran.it
Messages: 265
Registered: September 2005
Location: Karachi

Senior Member

Dear Zafar
ASA

Thank your for sharing the Knowledge

are u sure this is working without any error.

Kamran

Report message to a moderator

Re: Download ( Call a form from a Report) [message #245327 is a reply to message #244805]

Sat, 16 June 2007 00:59

zafarkarachi
Messages: 29
Registered: November 2006
Location: Karachi Pakistan

Junior Member

AOA,

Yes Dear Kamran i am sure but download the second one.

Zafar Iqbal
Remember my in your prays.
0321-2876518

Report message to a moderator

Re: Download ( Call a form from a Report) [message #245497 is a reply to message #245327]

Sun, 17 June 2007 21:34

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Same problem.

You have

procedure U_1ButtonAction is
appID PLS_INTEGER;
v_1 number;
begin
  v_1 := :empno;
  SRW.DO_SQL('DELETE FROM DX10');
  SRW.DO_SQL('COMMIT');   
  SRW.DO_SQL('INSERT INTO DX10 VALUES(:empno)');  
  SRW.DO_SQL('COMMIT');   
 
  AppId:= DDE.App_Begin ('D:\oradev6i\BIN\ifrun60.EXE c:\invoke_form\invoke_emp.fmx scott/tiger', dde.app_mode_normal);

end;

If two people run this code at the same time there exists the chance that the first person will get the second 'empno' or nothing.

David

Report message to a moderator

Re: Download ( Call a form from a Report) [message #245895 is a reply to message #244805]

Tue, 19 June 2007 03:13

zafarkarachi
Messages: 29
Registered: November 2006
Location: Karachi Pakistan

Junior Member

Dear David,

if one person call a record to update then it will be
locked for other user unless first user commit it.

if any thing new in your mind please share it with me.

Thanks

Zafar Iqbal
Karachi

Report message to a moderator

Re: Download ( Call a form from a Report) [message #246167 is a reply to message #245895]

Wed, 20 June 2007 02:53

kamran.it
Messages: 265
Registered: September 2005
Location: Karachi

Senior Member

ASA Zafar

Plz see attached file (error)

Attachment: New Picture.JPG
(Size: 106.66KB, Downloaded 1104 times)

Report message to a moderator

Re: Download ( Call a form from a Report) [message #246473 is a reply to message #246167]

Thu, 21 June 2007 01:22

zafarkarachi
Messages: 29
Registered: November 2006
Location: Karachi Pakistan

Junior Member

Dear Kamran,

Please open form and see the insert into sql where one
value is passed like empno and stored in a table with a single field so you have to create a table with the name mentioned in srw.do_sql('insert into <tablename> ....'). Then run the form.

SRW.DO_SQL('INSERT INTO DX10 VALUES(:empno)');

Zafar Iqbal

Report message to a moderator

Re: Download ( Call a form from a Report) [message #246584 is a reply to message #246473]

Thu, 21 June 2007 07:08

lakshmi surya ram
Messages: 188
Registered: June 2006
Location: HYDERABAD

Senior Member

Hi Zafar,
Document looks great.
Its working fine.
1)how do we call the .fmx file from the navigator?
2)In which trigger do we need to write the trigger?
3)can we eliminate the lines on the LHS of the tree.Means,should appear like the same in oracle applications navigator individually.

Its bit urgent.Please light on this staff.
thanks in advance,
Surya

Report message to a moderator

Re: Download ( Call a form from a Report) [message #247031 is a reply to message #246584]

Sat, 23 June 2007 00:39

zafarkarachi
Messages: 29
Registered: November 2006
Location: Karachi Pakistan

Junior Member

Dear Surya,

Please look the property of tree item and under functional node
set show lines to NO

Regards
Zafar Iqbal
Needs ur prayers

Report message to a moderator

Re: Download ( Call a form from a Report) [message #247164 is a reply to message #244805]

Sun, 24 June 2007 21:51

lakshmi surya ram
Messages: 188
Registered: June 2006
Location: HYDERABAD

Senior Member

Hi Zafar,
I found that.
Problem is when I click on one of the names in the menu, a form is called. Suppose If I have two forms then obviously I need to have two names in the navigator.
when I click on the names in the navigator,two different forms has to open.How do we acheive this?
Please send me an fmb file If you have one for menu.

thanks in advance,
Surya

Report message to a moderator

Re: Download ( Call a form from a Report) [message #247288 is a reply to message #244805]

Mon, 25 June 2007 06:50

zafarkarachi
Messages: 29
Registered: November 2006
Location: Karachi Pakistan

Junior Member

Dear Surya

Please Check the attached form example

Hope this example helps you.

Zafar

Attachment: HTREE_EXAMPLE_FORM_MENU.fmb
(Size: 48.00KB, Downloaded 1763 times)

Report message to a moderator

Re: Download ( Call a form from a Report) [message #247296 is a reply to message #247288]

Mon, 25 June 2007 07:36

lakshmi surya ram
Messages: 188
Registered: June 2006
Location: HYDERABAD

Senior Member

thanks a lot zafar
what is that when I open the fmb in forms 6i its throwing unknown format? how can I avoid that?
thanks,
Surya

Report message to a moderator

Re: Download ( Call a form from a Report) [message #247436 is a reply to message #247296]

Mon, 25 June 2007 21:40

lakshmi surya ram
Messages: 188
Registered: June 2006
Location: HYDERABAD

Senior Member

Hi folks,
iam able to create tree but it calls only one form.
I want you people to guide me to call the second form also.
Its the third day I am asking you experts.
please throw light on this staff.

thanks in advance,
Surya

Report message to a moderator