OraFAQ Forum: Forms » Opening Picture

Home » Developer & Programmer » Forms » Opening Picture (Oracle Developer 6i)

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

Opening Picture [message #599376]

Thu, 24 October 2013 00:37

amjad_alahdal
Messages: 102
Registered: October 2013
Location: Saudi Arabia

Senior Member

Hello every one
I would like to ask a very small question. what is the code that should be written to open a picture inside the button.
I have already made the button, and the trigger is when push button, what I want is when I click the button it opens a picture in this directory
F:\Amjad\Amjad\amjad\1.jpg

the name of the picture is taken from table1 the colum serial_number

Thank you

Report message to a moderator

Re: Opening Picture [message #599377 is a reply to message #599376]

Thu, 24 October 2013 00:44

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Hi I've moved your thread to the Forms section.

Now, as for your question. So you want to invoke an OS command to show a picture My best bet (It's been a long time since I've used Forms) is to use WEB.SHOW_DOCUMENT(<full path to the image>). Note that the webserver running your Forms needs to be able to access this path.

MHE

Report message to a moderator

Re: Opening Picture [message #599378 is a reply to message #599377]

Thu, 24 October 2013 00:51

amjad_alahdal
Messages: 102
Registered: October 2013
Location: Saudi Arabia

Senior Member

Sorry
and thanks

well,
I'm sorry Sir,
Maybe I didn't explain my question well. So, I created a button in oracle 6i developer.
Created a trigger, when button pressed
so, what I want is, when I click the button, it opens a picture in this directory for example :
F:\Amjad\Amjad\amjad\1.jpg
look, the name of the image is taken from an item of the block , the block name is My_table1, the item is Serial Number
so it should be,
My_table1.serial_number that refers to the name of the picture

Report message to a moderator

Re: Opening Picture [message #599390 is a reply to message #599378]

Thu, 24 October 2013 02:44

Maaher
Messages: 7065
Registered: December 2001

Senior Member

What do you mean when you say "it opens a picture"? In an image item? In a browser? Most web browsers know how to handle images, so my guess is that web.show_document will work, although I'm not sure whether the path you provide should be known client side or on the IAS side. That is something I need to check.

MHE

Report message to a moderator

Re: Opening Picture [message #599399 is a reply to message #599390]

Thu, 24 October 2013 03:55

Littlefoot
Messages: 21811
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

As you use Forms 6i: is this a client-server application, or is it deployed to web? If client-server, maybe HOST built-in would do the job as well; try to specify image name only (as Maaher said - operating system (Windows, right?) *should* be able to open it that way).

For example (untested - I don't have Forms 6i at all and I don't have ANY Forms available at the moment):

declare
  l_image_name my_table1.serial_number%type;  
begin
  select serial_number
    into l_image_name
    from my_table1
    where rownum = 1;

  -- suppose it looks like "12345.jpg". If not, concatenate '.jpg' to serial number

  host (l_image_name);
end;

Report message to a moderator

Re: Opening Picture [message #599403 is a reply to message #599390]

Thu, 24 October 2013 04:05

mughals_king
Messages: 392
Registered: January 2012
Location: pakistan

Senior Member

do this---simple

READ_IMAGE_FILE('D:\'||:My_table1.serial_number ||'.JPG','JPEG','My_table1.IMAGE4');
------------------------------------------------------------------------------

if you wanna create serial number as well then create serial like this 

WHEN-NEW-BLOCK-INSTANCE 

declare
  a number(7) ;
begin
   select count(*)+1 into :my_table1.serial_number from my_table1;
   :global.a:=:serial_number;
 READ_IMAGE_FILE('D:\'||:My_table1.serial_number ||'.JPG','JPEG','My_table1.IMAGE4');
end;

WHEN-BUTTON-PRESSED

begin
 :global.a := :global.a+1;
    next_record;
 :serial_number := :global.a;
READ_IMAGE_FILE('D:\'||:My_table1.serial_number ||'.JPG','JPEG','My_table1.IMAGE4');
end;

and remember picture name should be 1,2,3... or change according to your requirment

Regard
Mughal Cool

Cool

[Updated on: Thu, 24 October 2013 04:07]

Report message to a moderator

Re: Opening Picture [message #599405 is a reply to message #599403]

Thu, 24 October 2013 04:22

mughals_king
Messages: 392
Registered: January 2012
Location: pakistan

Senior Member

better take fmb it will be more helpful for you Cool

Cool

Attachment: serial_picture.fmb
(Size: 48.00KB, Downloaded 1212 times)

Report message to a moderator

Re: Opening Picture [message #599484 is a reply to message #599405]

Thu, 24 October 2013 14:48

amjad_alahdal
Messages: 102
Registered: October 2013
Location: Saudi Arabia

Senior Member

Thanks you guys,
well, I am using the Oracle Developer 6i, form builder.
Thanks mughals_king.
But what I want is to open it in another thread not displaying it in an item. Just like when you double click the picture inside the folder. I mean I want it to be opened by the photo viewer of the windows

Report message to a moderator

Re: Opening Picture [message #599485 is a reply to message #599484]

Thu, 24 October 2013 14:51

Littlefoot
Messages: 21811
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

So, did you try HOST?

Report message to a moderator

Re: Opening Picture [message #599488 is a reply to message #599485]

Thu, 24 October 2013 15:05

amjad_alahdal
Messages: 102
Registered: October 2013
Location: Saudi Arabia

Senior Member

Yes, I did. But, it didn't work.

Report message to a moderator

Re: Opening Picture [message #599490 is a reply to message #599488]

Thu, 24 October 2013 15:09

Littlefoot
Messages: 21811
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

What happened? Any error? If so, which one?

Report message to a moderator

Re: Opening Picture [message #599491 is a reply to message #599490]

Thu, 24 October 2013 15:12

amjad_alahdal
Messages: 102
Registered: October 2013
Location: Saudi Arabia

Senior Member

I wrote this
host('F:\Amjad\Amjad\Amjad\'||:My_table1.serial_number ||'.JPG');
it opens the dos window and then closes it. it doesn't open the picture

Report message to a moderator

Re: Opening Picture [message #599495 is a reply to message #599491]

Thu, 24 October 2013 15:25

Littlefoot
Messages: 21811
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I see; how about (MS Windows, eh?)

host('mspaint F:\Amjad\Amjad\Amjad\'||:My_table1.serial_number ||'.JPG');

You might need to tweak it a little bit; I hope MS Paint will be started and - hopefully - open the image. If it does, try with some other image viewer, if you wish.

Report message to a moderator

Re: Opening Picture [message #599497 is a reply to message #599495]

Thu, 24 October 2013 15:42

amjad_alahdal
Messages: 102
Registered: October 2013
Location: Saudi Arabia

Senior Member

It tried this :

Declare
my_cmd varchar2(512);
Begin
my_cmd := 'rundll32 shell32,ShellExec_RunDLL '|| 'F:\Amjad\Amjad\amjad\'||:My_table1.serial_number ||'.JPG';
HOST(my_cmd, NO_SCREEN);
End;

and it worked
Thanks to you all

Report message to a moderator

Re: Opening Picture [message #599513 is a reply to message #599497]

Fri, 25 October 2013 00:17

Littlefoot
Messages: 21811
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Now that's something! Cool, I'm glad you found the solution and shared it with us.

Report message to a moderator

Previous Topic:	How to convert Oracle 10g Forms to Oracle 6i Forms
Next Topic:	Migration from oracle 10g 32 bit windows forms and reports to 11g linux forms and reports

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jun 13 02:41:04 CDT 2024