Board index » delphi » Sql Server 2000 and tdbimage.

Sql Server 2000 and tdbimage.

Hi
How to use an sql server 2000 database with Tdbimage Component.

i try to store and retreive bmp and jpeg file.

Thanks

 

Re:Sql Server 2000 and tdbimage.


In article <3C56AA86.A2BE...@gameone.net>, lmadjar...@gameone.net
says...

Quote
> How to use an sql server 2000 database with Tdbimage Component.

> i try to store and retreive bmp and jpeg file.

        TDBImage works with BMPs only.  It cannot be made to work with
JPEGs.  If you want to store a JPEG in the database view it in a regular
TImage (add JPEG to the uses clause of the form containing it) and then
manually save it to a stream and load up the Blob field from the stream
using the TBlobField.LoadFromStream method.

        HTH,

        -Craig

--
 Craig Stuntz (TeamB) Vertex Systems Corp. Columbus, OH
     Delphi/InterBase WebLog: http://delphi.weblogs.com
     InterBase PLANalyzer (Free IB optimization tool):
          http://delphi.weblogs.com/IBPLANalyzer

Re:Sql Server 2000 and tdbimage.


hi

actually
i have a paradox table with 70 fields.
i store in graphic field bmp or jpeg file.

it's work fine.

i just want to migrate a paradox table to sql2000 table format.
but i can't store any graphic file in any field type.

what Field type can be used for this and how ????

Thanks.

Other Threads