Re: Viewing a bitmap Oracle Blob without writing it to file



Hi,

Why don't you create the image using the image creating method:

Image extent: extentPoint depth: aDepth bitsPerPixel: aBitsPerPixel palette: aPalette usingBits: myBits

In this case you store the information required to recreate the image in the same table including the blob colum holding the the image bits.

Using the Image class allows you to read all compatible image file formats and then store them into your database.

You can then quite retrieve and review these inside your application avoiding calling external once.


Maarten,


mm a écrit :
I store bitmaps in blobs on an Oracle database and when I need to view the bitmap I read the database table, convert the blob to a stream, write it out to a file with a .bmp extension and then use ShellExecute to open that file.
However I now want to cut out the step of writing it to a file.
So what I want to do is read a blob from the database and view it.
Anyone got any ideas ?
Anyone know of an equivalent to ShellExecute which will take a stream instead of a filename ?

Thanks.


.



Relevant Pages

  • Re: Blobs and SQL Server
    ... When I'm inserting the blob into the database, ... Any way you could extract the textual content and store it in ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Insert file
    ... Access has no blob datatype. ... Depending on how you must handle the data from within the database, ... And I want to store this file in the database. ... >> Tom Ellison ...
    (microsoft.public.access.queries)
  • Re: compressing data stored in a database
    ... My application uses a database to store big blobs. ... a List of a class Sample that I store in a blob. ... The class Sample contains a lot of properties. ...
    (microsoft.public.dotnet.languages.csharp)
  • compressing data stored in a database
    ... My application uses a database to store big blobs. ... a List of a class Sample that I store in a blob. ... The class Sample contains a lot of properties. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: public and private mailboxes randomly dismounting
    ... When posting logs an important piece is the Event ID and Source. ... Information Store First Storage Group: An attempt to move the file ... An error occurred while writing to the database log file of storage group ...
    (microsoft.public.windows.server.sbs)