Home » Developer & Programmer » Forms » Calling Form from Report
Calling Form from Report [message #240179] Thu, 24 May 2007 05:51 Go to next message
kamran.it
Messages: 265
Registered: September 2005
Location: Karachi
Senior Member
I have posted this post in report but I did not receive any reply.

using Report 6i I want to call a form from report.

I wrote code in PL/SQL of one Field
----------
function F_MAIL_REFFormatTrigger return boolean is
AppID PLS_INTEGER;
begin

AppID := dde.app_begin('D:\oracle6i\BIN\ifrun60.EXE D:\ORACLE\Costing\Forms\Costing-new-1 userid=kamran/ahmed',
DDE.App_Mode_Minimized);
return (TRUE);
end;
-----------------------
I have three record in report when report run it is opening desire Form @ 3 times I m near to solve this issue but I'd like to know proper trigger/logic that when I click on this record then it will open this record in form.
Re: Calling Form from Report [message #240638 is a reply to message #240179] Fri, 25 May 2007 06:41 Go to previous messageGo to next message
kamran.it
Messages: 265
Registered: September 2005
Location: Karachi
Senior Member
dear friend please solve this issue

I create a from and report on 6i my director use this form and report every thing is working fine.
he wants that
1. he entered the record
2. and run report @ runtime
3. @ runtime he found a mistake in record
4. now he wants that just click on this record @ runtime report form open and show this record.

No I m unable to understand that Is there any trigger like in form when-mouse-click etc so that i could write a code.

example

when-mouse-click -- trigger
Dee.aap_begin .........


Re: Calling Form from Report [message #241053 is a reply to message #240179] Mon, 28 May 2007 04:35 Go to previous message
wency
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member

It's hunted in the net since the first post regarding caaling form from reports. so far, the most we got is the use of DDE package, and thats what you are doing. Now, if you only want a mouse-click then make some tricks on reports button.
Previous Topic: get error wilth DLL in forms and ora-06503 (merged)
Next Topic: Mapping of Other Values property?
Goto Forum:
  


Current Time: Tue Dec 06 16:03:07 CST 2016

Total time taken to generate the page: 0.10890 seconds