Re: [Firebird-net-provider] BLOB?

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

Hello:

> how do I update a blob field (text) ?
>  
> UPDATE myTABLE SET text = "TEST"
>  
> result in error:
> BLOB and array data types are not supported for move operation

Using parametrized querys:

...

string sql = "UPDATE myTABLE SET text = @text";
FbCommand update = new FbCommand(sql, connection, transaction);

update.Parameters.Add("@text", FbDbType.Text).Value = "TEST";

int rowsAffected = update.ExecuteNonQuery();

...



--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain