Re: ora forms -> open picture in external program

I havent got Oracle Forms in front of me but....

You need to interrogate the registry to find where your picture viewing program location is. If you cannot find it, you can create your own registry key and put it in there yourself.

Look at WIN_API_ENVIRONMENT.read_registry function in the D2KWUTIL forms library package or on MetaLink. This should tell you how to read from the registry

Once you have your pathname from the registry, you can literally launch it using the HOST command

DECLARE   v_program_path VARCHAR2(2000);
  v_picture_name VARCHAR2(100) := 'd:\temp\1.jpg';

BEGIN   v_program_path := ???? (whatever you get from registry key)

• e.g v_program_path := 'c:\program files\pview\pic_view.exe';

  HOST(v_program_path|| ' ' || v_picture_name , NO_SCREEN);

END; Mark

ps Using DDE is old hat now, try using OLE2

"AR" <ar69ra_at_gmx.net> wrote in message news:<Nc1H9.1164$tQ1.79653_at_news.siol.net>...
> hi!
>
> thx for advice, but still have some problems
>
> here is a code:
> DECLARE
> AppID PLS_INTEGER;
> BEGIN
> AppID := DDE.App_Begin('C:\Program Files\ACD Systems\ACDSee\acdsee.exe
> d:\funny\pics\1.jpg',DDE.App_Mode_Normal);
> END;
>
> but how can i just open the picture, how to read program name from registry?
>
> and yes, i'm doing on client-server technology
>
> tnx, AR
>
>
> "SoulSurvivor" <markyg_7_at_yahoo.co.uk> wrote in message
> news:8d9c6fd.0212030025.5ff94225_at_posting.google.com...
> > You havent specified whether you are using Client server or web forms.
> >
> > Assuming client server, you could have image items which shows a
> > thumbnail of your picture. When the user clicks on the image item,
> > have code in the click trigger to look for the external file path of
> > your picture app from the registry (using ora_ffi or something
> > similar) and launch it using the HOST command.
> >
> > Viola :-)
> >
> > If using webforms, you could just launch another web browser window
> > with your image.
> >
> > M
> >
> >
> > "AR" <ar69ra_at_gmx.net> wrote in message
 news:<U5NG9.1136$tQ1.78091_at_news.siol.net>...
> > > Hello!
> > >
> > > I have an application made by Oracle Forms.
> > > Is there any possibility to open picture stored on file system in
 external
> > > viewer, which is selected in registry
> > >
> > > tnx for help
> > > AR
Received on Wed Dec 04 2002 - 09:23:11 CET