DatabaseRecord.PictureColumn

From Xojo Documentation

Revision as of 21:31, 23 January 2019 by PLefebvre (talk | contribs)
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