Example to update BLOB type column

[nitishrana28]

Could you share an example for updating BLOB type. I could not find one.
Here is what I am doing :

// ImageData data type is Data
let statement = try db.prepare("Update SpecialityModule SET ImageData = ? where ServerId = ?")
try statement.run(module.ImageData as! Binding?, module.ServerId)

Error received on statement.run :

Could not cast value of type 'Foundation.Data' (0xd0fad8) to 'SQLite.Binding' (0x2bd6058).

[iNoles]

What happens if you remove as! Binding?

[nitishrana28]

Complie time error of type casting.

[jberkel]

Data needs to be converted to Blob using datatypeValue:

try statement.run(module.ImageData.datatypeValue, module.ServerId)

Also see #142 (comment)

[nitishrana28]

This saves the value as BLOB. So we can close this.