Xref: alice comp.databases.oracle.tools:17973 From: "Don Miller" Subject: Re: Forms 4.5: Non-base-table Image-item Newsgroups: comp.databases.oracle.tools References: <7150g6$8a9$1@news-hrz.uni-duisburg.de> Organization: NSF International Message-ID: <01be033d$836252e0$ccd1a098@hynes.net.ic.net> X-Newsreader: Microsoft Internet News 4.70.1155 Date: 29 Oct 1998 08:06:52 -0500 X-Trace: 29 Oct 1998 08:06:52 -0500, 152.160.209.204 Lines: 43 Path: alice!news-feed.fnsi.net!news.idt.net!news-peer.gip.net!news.gsl.net!gip.net!news-peer.sprintlink.net!news-backup-east.sprintlink.net!news.sprintlink.net!204.42.224.2!news.ic.net!152.160.209.204 Peter, 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 wrote in article <7150g6$8a9$1@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 phone: 49 203 379-2698 > Department of Mathematics fax: 49 203 379-3139 > University of Duisburg, Lotharstrasse 65, 47048 Duisburg - Germany >