Hello,
I am using SQL Server 2005 with a table that looks like this:
create table dbo.Display_Images (
pk_Image_ID int Identity(1,1) primary key,
Description varchar(50) not null,
Picture varbinary(max) not null,
DateAdded datetime default getdate(),
FileName varchar(50) null
)
Using Borland Components I was able to upload jpegs to the "Picture" field, and I was also able to view the pictures by using a TTable component (linked to the table above). The problems start when I try to see the pictures from a dataset resulting from a Select Statement, for I only get a portion of the pictures.
At first I thought it was a Borland problem when using TQuery, so I created a view that uses the same SQL statement and I tried to access the view using a TTable Component, but the results were the same. Then, I used a "Select Into" statatement to copy some of the records into a new table and I still get partial pictures.
It looks to me that whenever I use a Select statment the lenght of the jpegs get shortened somehow. I tried to use
SET TEXTSIZE 50000
but it did not work.
my pictures are 47KB average.
Any help on this is highly appreciated.
Thanks
I am using SQL Server 2005 with a table that looks like this:
create table dbo.Display_Images (
pk_Image_ID int Identity(1,1) primary key,
Description varchar(50) not null,
Picture varbinary(max) not null,
DateAdded datetime default getdate(),
FileName varchar(50) null
)
Using Borland Components I was able to upload jpegs to the "Picture" field, and I was also able to view the pictures by using a TTable component (linked to the table above). The problems start when I try to see the pictures from a dataset resulting from a Select Statement, for I only get a portion of the pictures.
At first I thought it was a Borland problem when using TQuery, so I created a view that uses the same SQL statement and I tried to access the view using a TTable Component, but the results were the same. Then, I used a "Select Into" statatement to copy some of the records into a new table and I still get partial pictures.
It looks to me that whenever I use a Select statment the lenght of the jpegs get shortened somehow. I tried to use
SET TEXTSIZE 50000
but it did not work.
my pictures are 47KB average.
Any help on this is highly appreciated.
Thanks