Home » Developer & Programmer » Forms » problems working with Program Manager through DDE components (10g Application Server win xp)
problems working with Program Manager through DDE components [message #341107] Sat, 16 August 2008 09:38 Go to next message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member
Hi,

The code below (WHEN_BUTTON_PRESSED trigger)is supposed to create a group of applications and display their short cuts on the screen but it does not seem to be working.

declare
	
	channel_id pls_integer;
	
begin
	if
		:global.channel_id is not null then
		channel_id := to_number(:global.channel_id);
		dde.execute(channel_id, '[creategroup(Chapter 27))]',1000);
		
		dde.execute(channel_id, '[additem(winword c:\Program Files\Microsoft Office\
		office11\template.doc, Letter Template,c:\Program Files\Microsoft Office\
		office11\winword.exe, ,30, ,c:\Program Files\Microsoft Office\office11\]',1000);
		
		dde.execute(channel_id, '[additem(f50run32.exe e:\inv_sys\test.fmb, Forms & Excel,f50run32.exe
		, ,110, ,e:\Oracle_developer_suit\bin]',1000) ;
		
		dde.execute(channel_id, '[additem(f50run32.exe e:\inv_sys\test1.fmb, Forms & Word,f50run32.exe
		, ,190, ,e:\Oracle_developer_suit\bin]',1000) ;
		
		dde.execute(channel_id, '[showgroup(Chapter 27,1)]',1000);
		
	else
		message('A communication channel must be established first. ');
	end if;
	
end;


I can see this comment at the bottom

Quote:
FRM-40735 WHEN_BUTTON_PRESSED trigger raised unhandled exception ORA-106555


On searching the forum I got answers on using excel and encountering this error but nothing on PROGRAM MANAGER (windows shell program)

Can you figure out the reason why? I am also not aware what will be the substitute for the f50run32.exe this is supposed to be the icon source file but I could not find it in the developer home, please let me know if you have any idea.
Re: problems working with Program Manager through DDE components [message #341441 is a reply to message #341107] Mon, 18 August 2008 20:39 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Place 'message();pause;' pairs between each statement to determine which one is giving rise to the error.

David
Re: problems working with Program Manager through DDE components [message #341545 is a reply to message #341441] Tue, 19 August 2008 04:50 Go to previous messageGo to next message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member
Thanks for the response..

I tried putting message();pause; in between sentences but did not help.

message() must have a message to print and PAUSE suspends processing until the end user presses a function key. PAUSE might display an alert.

I tried message() which gave an error then tried message('') along with pause; but it did not display any alert or message that will give me an idea about the error.

Have I used it in a wrong way?

declare
	
	channel_id pls_integer;
	
begin
	if
		:global.channel_id is not null then
		channel_id := to_number(:global.channel_id);
		dde.execute(channel_id, '[creategroup(Chapter 27))]',1000);
           message('');
           pause;		

		dde.execute(channel_id, '[additem(winword c:\Program Files\Microsoft Office\
		office11\template.doc, Letter Template,c:\Program Files\Microsoft Office\
		office11\winword.exe, ,30, ,c:\Program Files\Microsoft Office\office11\]',1000);
		
           message('');
           pause;	

		dde.execute(channel_id, '[additem(f50run32.exe e:\inv_sys\test.fmb, Forms & Excel,f50run32.exe
		, ,110, ,e:\Oracle_developer_suit\bin]',1000) ;

           message('');
           pause;	
		
		dde.execute(channel_id, '[additem(f50run32.exe e:\inv_sys\test1.fmb, Forms & Word,f50run32.exe
		, ,190, ,e:\Oracle_developer_suit\bin]',1000) ;
		
           message('');
           pause;	

		dde.execute(channel_id, '[showgroup(Chapter 27,1)]',1000);
		
           message('');
           pause;	

	else
		message('A communication channel must be established first. ');
	end if;
	
end;
Re: problems working with Program Manager through DDE components [message #341657 is a reply to message #341545] Tue, 19 August 2008 17:23 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Aaahhh!!! Put a REAL piece of text in the message!!! For example, 'line 1', 'line 2', 'line 3', THEN you can see which line is about to be executed or has just been executed.

David
Previous Topic: New ER Diagramming Tool
Next Topic: Open Forms6i app. in Explorer
Goto Forum:
  


Current Time: Sat Dec 10 07:16:12 CST 2016

Total time taken to generate the page: 0.08805 seconds