Re: [Firebird-net-provider] How to save images in Blobs ?

[<car...@te...>]

Hello:

>                         _cmdText = "INSERT INTO T_ARTICLE(A_ARTICLE_ID, 
> A_IDENT, A_NAME, A_DESCRIPTION,A_IMAGE) ";
>                         _cmdText += " 
> VALUES(@articleId,@articleIdent,@articleName,@articleDescription,@articleImage) 
> ";

The code seems to be ok (if A_IMAGE is a binary blob field)

> _command.Parameters.Add("@articleImage",FirebirdSql.Data.Firebird.FbDbType.Binary).Value 
> = articleImage.Image;

You need to set the parameter value as byte array.




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain