loading pictures in forms [message #81113] |
Wed, 08 January 2003 13:50 |
ray park
Messages: 7 Registered: September 2002
|
Junior Member |
|
|
i have several .bmp pictures that i would like to load when the student name record appears in forms. is there any way i can do this, the pictures are stored on the c: hard drive.
|
|
|
Re: loading pictures in forms [message #81121 is a reply to message #81113] |
Fri, 10 January 2003 08:47 |
anam
Messages: 14 Registered: December 2002
|
Junior Member |
|
|
for this you have to make fire a trigger at form level
when-new-record-instance on block(name)
declare
filename varchar2(20);
begin
filename :=get_image(:block.itemname);
if filename='No file' then
null;
else
read_image_file(filename,'format of image<specify>',':block.itemname');
end if;
end;
get_image function is
function get_image(stu_no in number) return varchar2 is
v_filename varchar2(20);
begin
select image_name into v_filename
from table of images,stu
where joining condition
and image_id=stu_id;
if v_filename is null then
v_filename := 'No file';
end if;
return v_filename;
exception
when no_data_found then return ('no file');
end;
hope this will solve ur problem. do tell me if any more prob.
|
|
|