Class

# DatabaseRow

<div class="rst-class">

forsearch

</div>

Database

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

## Description

Used to create new `Database</api/databases/database>` rows (records). The methods are used to populate the columns in a row (record).

## Methods

<div class="rst-class">

table-centered_column_4

</div>

| Name                                           | Parameters                                                                                                             | Returns                                         | Shared |
|------------------------------------------------|------------------------------------------------------------------------------------------------------------------------|-------------------------------------------------|--------|
| `Column<databaserow.column>`                   | name As `String</api/data_types/string>`                                                                               | `DatabaseColumn</api/databases/databasecolumn>` |        |
|                                                | name As `String</api/data_types/string>`, `Assigns</api/language/assigns>` value as `Variant</api/data_types/variant>` |                                                 |        |
| `ColumnAt<databaserow.columnat>`               | index As `Integer</api/data_types/integer>`                                                                            | `DatabaseColumn</api/databases/databasecolumn>` |        |
| `ColumnCount<databaserow.columncount>`         |                                                                                                                        | `Integer</api/data_types/integer>`              |        |
| `Constructor<databaserow.constructor>`         | row As `RowSet</api/databases/rowset>`                                                                                 |                                                 |        |
| `Iterator<databaserow.iterator>`               |                                                                                                                        | `Iterator</api/language/iterator>`              |        |
| `LastColumnIndex<databaserow.lastcolumnindex>` |                                                                                                                        | `Integer</api/data_types/integer>`              |        |

## Method descriptions

<div id="databaserow.column">

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

</div>

<div class="rst-class">

forsearch

</div>

DatabaseRow.Column

**Column**(name As `String</api/data_types/string>`) As `DatabaseColumn</api/databases/databasecolumn>`

> Gets the DatabaseColumn for column name.

**Column**(name As `String</api/data_types/string>`, `Assigns</api/language/assigns>` value as `Variant</api/data_types/variant>`)

> Sets a *value* for column *name*. This is more optimized than using DatabaseColumn.
>
> Creates a new row in the team table:
>
> ``` xojo
> Var row As New DatabaseRow
>
> row.Column("Name").StringValue = "Penguins"
> row.Column("Coach").StringValue = "Bob Roberts"
> row.Column("City").StringValue = "Boston"
> Try
>   myDB.AddRow("Team", row)
> Catch error As DatabaseException 
>   MessageBox("DB Error: " + error.Message)
> End Try
> ```
>
> Creates a new row in the team table:
>
> ``` xojo
> Var row As New DatabaseRow
>
> row.Column("Name") = "Penguins"
> row.Column("Coach") = "Bob Roberts"
> row.Column("City") = "Boston"
> Try
>   myDB.AddRow("Team", row)
> Catch error As DatabaseException 
>   MessageBox("DB Error: " + error.Message)
> End Try
> ```

<div id="databaserow.columnat">

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

</div>

<div class="rst-class">

forsearch

</div>

DatabaseRow.ColumnAt

**ColumnAt**(index As `Integer</api/data_types/integer>`) As `DatabaseColumn</api/databases/databasecolumn>`

> Returns the DatabaseColumn for the column at position *index*.
>
> Get the string value of a column in a \`DatabaseRow\`:
>
> ``` xojo
> ' row is a DatabaseRow
> Var productName As String
> productName = row.ColumnAt(0).StringValue
> ```

<div id="databaserow.columncount">

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

</div>

<div class="rst-class">

forsearch

</div>

DatabaseRow.ColumnCount

**ColumnCount** As `Integer</api/data_types/integer>`

> Returns the number of columns in the <span class="title-ref">DatabaseRow</span>.
>
> Sets the number of columns in a listbox (CustomersList) to the number of columns in a database row (row):
>
> ``` xojo
> CustomersList.ColumnCount = row.ColumnCount
> ```

<div id="databaserow.constructor">

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

</div>

<div class="rst-class">

forsearch

</div>

DatabaseRow.Constructor

**Constructor**(row As `RowSet</api/databases/rowset>`)

> Creates a new <span class="title-ref">DatabaseRow</span> that will be a copy of the first row of the *row* passed.

<div id="databaserow.iterator">

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

</div>

<div class="rst-class">

forsearch

</div>

DatabaseRow.Iterator

**Iterator** As `Iterator</api/language/iterator>`

> Allows iterating through all the columns in the <span class="title-ref">DatabaseRow</span> with `For...Each</api/language/loops/for_each...next>`.
>
> Creates a new row in the team table and then iterate through it:
>
> ``` xojo
> 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)
>
>   For Each column As DatabaseColumn In row
>     System.DebugLog(column.Name + " - " + column.Value)
>   Next
> Catch error As DatabaseException
>   MessageBox("DB Error: " + error.Message)
> End Try
> ```

<div id="databaserow.lastcolumnindex">

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

</div>

<div class="rst-class">

forsearch

</div>

DatabaseRow.LastColumnIndex

**LastColumnIndex** As `Integer</api/data_types/integer>`

> The index of the last column in the <span class="title-ref">DatabaseRow</span>.

## Interfaces

This class implements the `Iterable</api/language/iterable>` class interface.

## Compatibility

|                       |     |
|-----------------------|-----|
| **Project Types**     | All |
| **Operating Systems** | All |

<div class="seealso">

`Object</api/data_types/additional_types/object>` parent class; `Database</api/databases/database>`, `DatabaseColumn</api/databases/databasecolumn>`, `MySQLCommunityServer</api/databases/mysqlcommunityserver>`, `ODBCDatabase</api/databases/odbcdatabase>`, `PostgreSQLDatabase</api/databases/postgresqldatabase>`, `RowSet</api/databases/rowset>` classes.

</div>