[Firebird-net-provider] Convert BLOB to string

[Martin <mc...@we...>]

Hi,

I am retrieving a BLOB field from a firebird db via .net provider 1.5

I am using ExecuteScalar() to get the first single result from execution of
the stored procudure
I am trying to retrieve the value like so

Dim strDesciption As Byte
strDesciption = objCMD.ExecuteScalar()   <---  this line throws an
exception..

I am then trying to put the result into a string -- but execution does not
get this far so  don't know if it is correct

Return strDesciption.ToString()

I am getting a "System.InvalidCastException"  (produced by the
ExecuteScalar() line)

message "Cast from type 'Byte()' to type 'Byte' is not valid."

I would appreciate any advice on how to avoid this error and be able to
return the string from the blob field my dot net code as a string

many thanks in advance.

martin.