storing graphics in database
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: storing graphics in database

  1. #1
    Join Date
    Jul 2000
    Location
    India
    Posts
    60
    hi ,

    i use crystal reports( a seagate product) and i have a logo of my company using this product is displayed in the report. but the problem is that this logo changes frequently as we have diff companies using it. can i store the image in a table and put it dynamically in the crystal reports report ? has anyone done something like this before ? thanks .

    satishpc

  2. #2
    Join Date
    Dec 2000
    Posts
    1
    hi ,
    step 1:
    Create a dir using the following command and give the directory name where your logo is stored.

    Example : Asssuming that your logo is stored in /tmp/logo.bmp

    CREATE DIRECTORY LOGO_DIR AS '/tmp';

    step 2:
    Create a table with column of BFILE type

    example :
    Create table Logo_tab ( logo_id number, logo BFILE):

    step 3:
    use insert comand to load image into table. Give the logo file name ( may be .bmp or .gif etc)

    insert into map_tab
    values ( 1, BFILENAME('LOGO_DIR','logo.bmp') );
    ----

    If you have any question reply back!

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