Re: Retrieving an image/varbinary(MAX) from database?

Article View: borland.public.delphi.database.dotnet

Article #16

Back to borland.public.delphi.database.dotnet Previous Next

#16

From: Craig
Date: Wed, 31 Jan 2007 10:03

15 lines
1472 bytes

Brigitte Spatz wrote:
> On the Web I've found a C# example of how to retrieve an image stored as 
> varbinary(MAX) from SQL Server:
> byteBLOBData = (Byte[])(ds.Tables["BLOBTest"].Rows[c - 1]["BLOBData"]);
> but I can't find what the Delphi equivalent of the (Byte[]) conversion is.
> 

of the top of my head I think i did something like this

type
   ByteArray = array of byte;
var
   byteBlobData: ByteArray;
begin
   byteBlobData := ByteArray(ds.Tables["BLOBTest"].Rows[c - 1]["BLOBData"]);

Technical Details

Message-ID: <45c0698f@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!news3.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <45c04d53@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 1effe6,3ecc195b7011d529
X-Google-Attributes: gid1effe6,public
X-Google-Language: ENGLISH,ASCII-7-bit
Date: Wed, 31 Jan 2007 21:03:05 +1100
From: Craig <craigvn@gmail.com>
User-Agent: Thunderbird 1.5.0.9 (Windows/20061207)
MIME-Version: 1.0
Newsgroups: borland.public.delphi.database.dotnet
Subject: Re: Retrieving an image/varbinary(MAX) from database?
References: <45c04d53@newsgroups.borland.com>
In-Reply-To: <45c04d53@newsgroups.borland.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 150.101.166.193
Message-ID: <45c0698f@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1170237839 150.101.166.193 (31 Jan 2007 02:03:59 -0800)
Lines: 15
Path: arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!news3.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message