DatabaseRow

From Xojo Documentation

Class (inherits from Object)


New in 2019r2

Used to create new Database rows (records). The methods are used to populate the columns in a row (record).

Methods
Column ColumnAt ColumnCount

Sample Code

Creates a new row in the team table:

Var row As New DatabaseRow

row.Column("Name").StringValue = "Penguins"
row.Column("Coach").StringValue = "Bob Roberts"
row.Column("City").StringValue = "Boston"
row.Column("StartTime").DateTimeValue = New DateTime(1, 1, 1, 6, 0, 0) // 6AM - no specific date

Try
myDB.AddRow("Team", row)
Catch error As DatabaseException
MessageBox("DB Error: " + error.Message)
End Try

See Also

Database, DatabaseColumn, MySQLCommunityServer, ODBCDatabase, OracleDatabase, PostgreSQLDatabase, RowSet classes.