Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Pulling images from database onto form
This should take care
HTH
Arvind
Brian Howard wrote in message <37B32F74.742CFA08_at_creditwatch-inc.com>...
>I have what I would have thought to be a simple problem, but I am fast
>wanting to pull my hair out. I have a table:
>PS_PICS (table)
>name varchar2
>pic long raw
>
>I have a form
>CLIENTS (form)
>
>All I want to do, is when the form comes up, it pulls the picture from
>PS_PICS with the name 'WORLD' and places this picture on the form.
>Sounds simple but cannot get it to work. I have tried several
>suggestions but none work. Should I create a data block on the form
>based on this table? Should I make the form field a display field or
>image field? If it needs to be an image field, what should the data type
>be (it doesn't have long raw)? Do I use a When-new-form-instance trigger
>to populate the field? Do I attempt to fetch this picture into the field
>using a cursor? Please help? Please give a step-by-step including code.
>Thanks.
>
>
Received on Thu Aug 12 1999 - 19:58:48 CDT