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

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

Article #17

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

#17

From: Brigitte Spatz
Date: Wed, 31 Jan 2007 10:13

22 lines
1831 bytes

Craig wrote:
> 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"]);

It's working :-))))) Thank you so much. I'd trawled what feels like the 
whole of the Web but didn't find this one anywhere...

Brigitte

Technical Details

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

Path:

arc1-ca.pugleaf.net!g2news2.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> <45c0698f@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 11:13:39 +0100
From: Brigitte Spatz <brigitteNOSPAM.spatz@svenmahn.de>
Organization: Sven Mahn IT-Systementwicklungen
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> <45c0698f@newsgroups.borland.com>
In-Reply-To: <45c0698f@newsgroups.borland.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Antivirus: avast! (VPS 000709-0, 30/01/2007), Outbound message
X-Antivirus-Status: Clean
NNTP-Posting-Host: 89.54.114.95
Message-ID: <45c06b9e@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1170238366 89.54.114.95 (31 Jan 2007 02:12:46 -0800)
Lines: 22
Path: arc1-ca.pugleaf.net!g2news2.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