OraFAQ Forum: Forms » Calling Form from Report

Home » Developer & Programmer » Forms » Calling Form from Report

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

Calling Form from Report [message #240179]

Thu, 24 May 2007 05:51

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.

Report message to a moderator

Re: Calling Form from Report [message #240638 is a reply to message #240179]

Fri, 25 May 2007 06:41

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 .........

Report message to a moderator

Re: Calling Form from Report [message #241053 is a reply to message #240179]

Mon, 28 May 2007 04:35

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.

Report message to a moderator

Previous Topic:	get error wilth DLL in forms and ora-06503 (merged)
Next Topic:	Mapping of Other Values property?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 23:42:17 CST 2025