DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Show Image in Form

  1. #1
    Join Date
    Apr 2001
    Location
    indonesia
    Posts
    52

    Question Show Image in Form

    Hi,

    I have some picture stored in a table,
    table t_picture
    id, picture
    1 pic1.jpg
    2 pic2.jpg
    3 pic3.jpg

    I want to show these picture in form (image item) after I enter the id. I do this in next_item_trigger
    exp : select picture into :block.picture from t_picture
    where id = :block.id;

    it show an error : bad bind variable.....

    Anybody can help me, please?

    Regards,

    Ching
    ching

  2. #2
    Join Date
    Sep 2000
    Location
    Sao Paulo,SP,Brazil, Earth, Milky Way
    Posts
    350
    Nope, PL/SQL has ** NO ** datatype to deal with images. In Forms, you MUST have an Image Item inside some block, and your code will be NOT a SELECT, but a READ_IMAGE_ITEM into that :block.imageItem, see in the Form Builder on-line help the complete syntax for READ_IMAGE_ITEM.

    Regards,

    Chiappa

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width