Re: Forms 4.5: Non-base-table Image-item

Peter,

[Quoted] You may want to try to select it into a variable.

SELECT logo INTO v_variable FROM logo_table WHERE id=:block1.logo_id; :block1.dsp_logo := v_variable;

Hope this works!!!

Don

Peter Koch <koch_at_math.uni-duisburg.de> wrote in article <7150g6$8a9$1_at_news-hrz.uni-duisburg.de>...
> Dear readers
>
> In a post-query-trigger I would like to select the image contained
> in a long raw column into a non-base-table image-item.
>
> SELECT logo INTO :block1.dsp_logo FROM logo_table WHERE
id=:block1.logo_id;
>
> does NOT work.
>
> READ_IMAGE_FILE will read images from files only.
>
> Do I really HAVE TO create a seperate block on logo_table with
> a base-table image-item, fetch one record into this block, write
> the image out into a temporary file with WRITE_IMAGE_FILE and
> then read it back into the non-base-table image-item with
READ_IMAGE_FILE.
>
> Besides the fact that this does not work in a post-query-trigger
> there must be a better solution to this problem.
>
> Thanks
>
> Peter
>
> --
> 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 Thu Oct 29 1998 - 14:06:52 CET