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
|
