|
|
|
Re: Save Images in Database From Forms - Download it Here [message #478301 is a reply to message #220286] |
Thu, 07 October 2010 13:58 |
niteenshrivastava
Messages: 12 Registered: September 2010 Location: IND
|
Junior Member |
|
|
Dear Sir,
I have to download ImageSolution10g.rar.
but both the form GET_FILE_NAME & LOAD_IMAGE_IN_10G trigger is not showing the code.
please give me all the code.
I have used Oracle 9i database,forms 10g, Windows Xp sp2,32 bit processor.
LOAD_IMAGE_IN_10G--Browse Button--When Button Pressed trigger
GET_FILE_NAME--WHEN-NEW-FORM-INSTANCE trigger
--PRE-FORM trigger
--LECTEURS List item--WHEN-LIST-CHANGED trigger
--REPS List item--WHEN-LIST-ACTIVATED trigger
--WHEN-LIST-CHANGED trigger
--FILTRE Text item--WHEN-VALIDATE-ITEM trigger
--SELECT Button--WHEN-BUTTON-PRESSED trigger
--ANNULE Button--WHEN-BUTTON-PRESSED trigger
all this trigger coding is not show..
|
|
|
Re: Save Images in Database From Forms - Download it Here [message #487700 is a reply to message #163347] |
Thu, 30 December 2010 02:47 |
|
forms 6i.
filed data type = long raw
well i have a form, it can save(f10) and show(f8) pictures in the form ,
but on some other form, i want to fetch that longraw pic into an image filed (on when validate item trigger, provided on the PK of table).
but form builder dose not allow to directly use image item in sql/plsql....
any guidline ?
|
|
|
|
|
|
Re: Save Images in Database From Forms - Download it Here [message #529847 is a reply to message #426667] |
Thu, 03 November 2011 06:16 |
meena.g
Messages: 14 Registered: February 2010 Location: Hyderabad (A.P)
|
Junior Member |
|
|
Dear Sir,
I am using oracle forms 10g .I am trying to insert images in database through oracle froms but I am not problem.please can you help me on that...
i want to display different images from drives......
i can disply single image by using this code..
READ_IMAGE_FILE(''c:\temp\hplogo.jpg', 'tiff', 'BLOCK2.im1');
but i want to select different images from c drive for every id..
by this code I'm getting error like this
when-mouse-click trigger on image item:
DECLARE
gif_image_dir VARCHAR2(80) := 'c:\temp\';
photo_filename VARCHAR2(80);
BEGIN
photo_filename := gif_image_dir||'*.tiff';
READ_IMAGE_FILE(photo_filename, 'tiff', 'BLOCK2.im1');
END;
error :FRM-47109:cannot locate image file c:\temp\*.tiff like this
I tried one more method also please find the below code: when-mouse-click trigger on image item
declare
file_path varchar2(1000);
begin
file_path := get_file_name('C:\',file_filter =>'All Files(*.*)|*.*|');
READ_IMAGE_FILE (file_path , 'jpg' , 'CALC_C.IM' );
end;
error :FRM-47105:no images name specified.
3rd method :when-mouse-click trigger on image item
declare
file_path varchar2(1000);
a varchar2(1000);
begin
a:='C:\Food Picture for BIFF\';
File_path := get_file_name(a,file_filter =>'All Files(*.*)|*.*|');
READ_IMAGE_FILE (a||'*.jpg' , 'jpg' , 'CALC_C.PICTURES' );
end;
FRM-47109:FRM-47109:cannot locate image file c:\food picture for biff\*.jpg
so please can you help me how to do ..
i am anot able to see the get_file_name form..can you help me on that.....
thanks in advacne......
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|