Re: Load picture from LONG to forms

Make a master-detail form.
Pics should be de detail, you should have a join between the two tables using emp-pic-id and pic-id.
Make the detail table-based.
(This only works if you have filled the pics table using forms eg. after feeding the pic_data using read_image_file).

Peter Koch <koch_at_math.uni-duisburg.de> schreef in berichtnieuws 7rvlip$1uk$2_at_news-hrz.uni-duisburg.de...
> Dear readers:
>
> I would like to load a picture stored in a LONG RAW column
> into a non basetable picture-item of a forms application.
>
> Here's an example for what I want to do:
>
> EMP: emp_id number(10) not null
> emp_name varchar2(50) not null
> emp_pic_id number(10) null
>
> PICS: pic_id number(10) not null
> pic_data long raw
>
> What do I have to do in the post-query trigger of the EMP-block to
> show the employees picture from the PICS-table?
>
> IF :emp.emp_pic_id IS NOT NULL THEN
> SELECT pic_data INTO :emp.dsp_picture_item
> FROM pics
> WHERE pic_id = :emp.emp_pic_id;
> END IF;
>
> does NOT work as one cannot select LONG fields into picture-items.
>
> Thanks
>
> Peter Koch
>
> --
> Peter Koch <Koch_at_Math.Uni-Duisburg.DE> phone: 49 203 379-2698
> Department of Mathematics fax: 49 203 379-3139
> University of Duisburg, Lotharstrasse 65, 47048 Duisburg - Germany
Received on Sun Sep 19 1999 - 20:26:27 CEST