Board index MS SQL Server

?: How to use the IMAGE-Datatype for a picture database

?: How to use the IMAGE-Datatype for a picture database

Post by Heiko R?bk » Sun, 19 Jul 1998 04:00:00



Hello All,

I've to develop a picture-database using the MS SQL-Server 6.5 and an VB5
Enterprise Edition frontend.
Now, there are some Problems:

- How can I insert as grapic-file (file.jpg) into an datafield in an
image-formated SQL-Server Table through an SQL-query?

A query like "Insert into tbl_demo(field1) values ("C:\temp\file.jpg");"
doens't work...

- How can I get a graphic-file from an sql-server table in a VB5
picture-box? Which steps are nessesary to do that?

H.R.

(Sorry for my bad english, I do my very best)

 
 
 
Top

1. Store image by using image datatype in SQL 7.0

Hi all,

     I have read the mail which the subject is HOW TO USE THE BINARY OR THE IMAGE
DATATYPE. I find the method which is provided by Neil Pike. Unfortunately I have
problems in getting the image from table. How can I get the image size or file
length in the table. I have used "GETCHUNK" method but I cannot locate the image
in the table.

Please help me to solve this problem

Regards,
CY

2. PreparedStatment INSERT fails due to varchar records too big

3. Image Datatype - binding datasource to a controls picture property

4. Probleme mit createobject("DAO.DBEngine")

5. record locking

6. Assigning a picture to an Image field in SQL server, using ADO

7. wordperfect.wordperfectscript?

8. using a dbedit field to load a picture in an image field

9. Assigning a picture to an Image field in SQL server, using ADO

10. using TEXT and IMAGE datatypes

11. OLE/Image Datatypes using in IDC and HTX

12. Using Image datatype in Postgres


All times are UTC
Board index