Xojo Documentation Xojo Documentation

Method

DatabaseRecord.PictureColumn(Name As String) As Picture

Supported for all project types and targets.

Gets the Picture value for the column Name.

Method

DatabaseRecord.PictureColumn(Name As String, Assigns value As Picture)

Supported for all project types and targets.

Sets the Picture value for the column Name.

Method

DatabaseRecord.PictureColumn(Name As String, format As String=Picture.FormatPNG, quality As Integer = Picture.QualityDefault, Assigns value As Picture)

Supported for all project types and targets.

Sets the Picture value for the column Name with the specified format and quality.

Notes

For most databases using the BlobColumn method is preferred.

Sample Code

Creates a new row in the team table:

Dim row As New DatabaseRecord

row.Column("Name") = "Penguins"
row.Column("Coach") = "Bob Roberts"
row.Column("City") = "Boston"
row.PictureColumn("Logo") = Canvas1.Backdrop

myDB.InsertRecord("Team", row)

If myDB.Error Then
MsgBox("DB Error: " + myDB.ErrorMessage)
End If