SQLite BlobColumn example does not works

Databases
1

The example here does not works:

[code]Dim row As New DatabaseRecord

row.Column(“EmployeeID”) = “1”
row.Column(“FirstName”) = “Emile”
row.Column(“LastName”) = “Schwarz”
row.BlobColumn(“PhotoID”) = cImage.Backdrop

myDB.InsertRecord(“Team”, row)

If myDB.Error Then
MsgBox("DB Error: " + myDB.ErrorMessage)
End If[/code]

The flagged error is:
There is more than one item with this name and it’s not clear to which this refers.

the yellow background text is: row.BlobColumn("Logo"

The create string looks like what found here :

CREATE TABLE Team (EmployeeID INTEGER, FirstName TEXT, LastName TEXT, Photo BLOB, PRIMARY KEY (EmployeeID))
2

The example is wrong:

row.BlobColumn("PhotoID") =

awaits a string !

Not a Picture…

3

Thanks. I’ve updated that line in the example code to this:

row.BlobColumn("Logo") = Canvas1.Backdrop.GetData(Picture.FormatPNG)
4

Thanks Paul for the updated code: I was searching how to do that ! (and back)

It works fine, now (and Paul: you came at the right time: I was starting to try to reach a solution). Now, I have to write the reverse (load the image from the db).