Tiff file not open in oracle forms 6i [message #626235] |
Thu, 23 October 2014 03:25 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
|
Hi,
please help me very urgent
i am using orcale 6i forms application i want to open to pdf and tiff format document but pdf file only open while
clicking the button using when button pressed trigger .
i can't open tiff format file..
i have attched query.
declare
filename VARCHAR2(200);
filename1 VARCHAR2(200);
V_path varchar(100) :='E:\';
fpath varchar2(100);
--file_path varchar2(100);
image varchar2(100);
begin
--SELECT PATH_DESC INTO file_path FROM IMAGE_PATH where image_type='SCANNED';
select path into fpath from image_folder
where scan_year =substr(:b010.job_no,1,4) and from_no<=substr(:b010.job_no,6,9)
and to_no>=substr(:b010.job_no,6,9);
select image_type into image from image_path where image_type='.PDF' or image_type='.tif' ;
filename := V_path||substr(:b010.job_no,1,4)||'\'||fpath||'\'||:b010.job_no||'\'||:b010.job_no||image;
host('start '||filename);
end;
|
|
|
Re: Tiff file not open in oracle forms 6i [message #626248 is a reply to message #626235] |
Thu, 23 October 2014 08:51 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](//www.gravatar.com/avatar/6f539f43889b4b3e3fcb6c591073de8f?s=64&d=mm&r=g) |
CraigB
Messages: 386 Registered: August 2014 Location: Utah, USA
|
Senior Member |
|
|
Quote:i can't open tiff format file..
What happens when you try to open a tiff? If we don't know what happens, we have to guess.
So, my guess is that you don't have a default application associated with the .tiff extension.
Craig...
|
|
|