Re: Pulling images from database onto form

1. open a new form
2. create a block(bk_pics) based on ps_pics table
3. change the pic items item type in the property sheet to image
4. in the when new-form-instance add the following code go_block('bk_pics'); execute_query;

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 Fri Aug 13 1999 - 02:58:48 CEST