Home » Developer & Programmer » Forms » Download ( Call a form from a Report)
Download ( Call a form from a Report) [message #244805] Thu, 14 June 2007 02:51 Go to next message
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

Re: Download ( Call a form from a Report) [message #245039 is a reply to message #244805] Fri, 15 June 2007 01:09 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Re: Download ( Call a form from a Report) [message #245152 is a reply to message #244805] Fri, 15 June 2007 05:49 Go to previous messageGo to next message
zafarkarachi
Messages: 29
Registered: November 2006
Location: Karachi Pakistan
Junior Member
Interesting!!! David

Please download this one as user can update record.

Zafar IQbal



Re: Download ( Call a form from a Report) [message #245182 is a reply to message #245152] Fri, 15 June 2007 07:19 Go to previous messageGo to next message
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
Re: Download ( Call a form from a Report) [message #245327 is a reply to message #244805] Sat, 16 June 2007 00:59 Go to previous messageGo to next message
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
Re: Download ( Call a form from a Report) [message #245497 is a reply to message #245327] Sun, 17 June 2007 21:34 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Re: Download ( Call a form from a Report) [message #245895 is a reply to message #244805] Tue, 19 June 2007 03:13 Go to previous messageGo to next message
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
Re: Download ( Call a form from a Report) [message #246167 is a reply to message #245895] Wed, 20 June 2007 02:53 Go to previous messageGo to next message
kamran.it
Messages: 265
Registered: September 2005
Location: Karachi
Senior Member
ASA Zafar

Plz see attached file (error)
Re: Download ( Call a form from a Report) [message #246473 is a reply to message #246167] Thu, 21 June 2007 01:22 Go to previous messageGo to next message
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
Re: Download ( Call a form from a Report) [message #246584 is a reply to message #246473] Thu, 21 June 2007 07:08 Go to previous messageGo to next message
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
Re: Download ( Call a form from a Report) [message #247031 is a reply to message #246584] Sat, 23 June 2007 00:39 Go to previous messageGo to next message
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

Re: Download ( Call a form from a Report) [message #247164 is a reply to message #244805] Sun, 24 June 2007 21:51 Go to previous messageGo to next message
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
Re: Download ( Call a form from a Report) [message #247288 is a reply to message #244805] Mon, 25 June 2007 06:50 Go to previous messageGo to next message
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
Re: Download ( Call a form from a Report) [message #247296 is a reply to message #247288] Mon, 25 June 2007 07:36 Go to previous messageGo to next message
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
Re: Download ( Call a form from a Report) [message #247436 is a reply to message #247296] Mon, 25 June 2007 21:40 Go to previous messageGo to next message
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
Re: Download ( Call a form from a Report) [message #389333 is a reply to message #244805] Sat, 28 February 2009 12:39 Go to previous messageGo to next message
shahzaib_4vip@hotmail.com
Messages: 373
Registered: December 2008
Location: karachi
Senior Member
@ Above

How can i call a report from another report ?

Thanks


Shahzaib Ismail
Re: Download ( Call a form from a Report) [message #579896 is a reply to message #247288] Sat, 16 March 2013 23:43 Go to previous message
himacsoft
Messages: 11
Registered: May 2011
Junior Member
Dear Sir,
it cant be downloaded, I tried it many times.I am developing in forms 6i, can u upload it again correct format plz.
Thank you,
Varadharaj A

[Updated on: Sat, 16 March 2013 23:50]

Report message to a moderator

Previous Topic: read image from a directory
Next Topic: When-button-pressed button problem
Goto Forum:
  


Current Time: Fri Jul 25 22:51:06 CDT 2014

Total time taken to generate the page: 0.06549 seconds