Class

# DBKit.Container

<div class="rst-class">

forsearch

</div>

DBKit.Container

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

## Description

Used to display other DBKit controls with data from the current row of a database table to which it's assigned.

Only the members declared by <span class="title-ref">DBKit.Container</span> itself are described here; for the inherited members, see `the parent class<dbkit.container.seealso>`.

## Properties

<div class="rst-class">

table-centered_columns_3_and_4

</div>

| Name                                                                         | Type                                  | Read-Only | Shared |
|------------------------------------------------------------------------------|---------------------------------------|-----------|--------|
| `AutomaticHints<dbkit.container.automatichints>`                             | `Boolean</api/data_types/boolean>`    |           |        |
| `ConfirmCancelButtonCaption<dbkit.container.confirmcancelbuttoncaption>`     | `String</api/data_types/string>`      |           |        |
| `ConfirmContinueButtonCaption<dbkit.container.confirmcontinuebuttoncaption>` | `String</api/data_types/string>`      |           |        |
| `CurrentRow<dbkit.container.currentrow>`                                     | `DBKit.Row</api/databases/dbkit/row>` |           |        |
| `Database<dbkit.container.database>`                                         | `Database</api/databases/database>`   |           |        |
| `DeleteConfirmExplanation<dbkit.container.deleteconfirmexplanation>`         | `String</api/data_types/string>`      |           |        |
| `DeleteConfirmMessage<dbkit.container.deleteconfirmmessage>`                 | `String</api/data_types/string>`      |           |        |
| `DeleteConfirmTitle<dbkit.container.deleteconfirmtitle>`                     | `String</api/data_types/string>`      |           |        |
| `OrderBy<dbkit.container.orderby>`                                           | `String</api/data_types/string>`      |           |        |
| `SelectedRowIndex<dbkit.container.selectedrowindex>`                         | `Integer</api/data_types/integer>`    |           |        |
| `TableName<dbkit.container.tablename>`                                       | `String</api/data_types/string>`      |           |        |
| `TableRelationships<dbkit.container.tablerelationships>`                     | `String</api/data_types/string>`      |           |        |
| `UnsavedChangesExplanation<dbkit.container.unsavedchangesexplanation>`       | `String</api/data_types/string>`      |           |        |
| `UnsavedChangesMessage<dbkit.container.unsavedchangesmessage>`               | `String</api/data_types/string>`      |           |        |
| `UnsavedChangesTitle<dbkit.container.unsavedchangestitle>`                   | `String</api/data_types/string>`      |           |        |
| `Where<dbkit.container.where>`                                               | `String</api/data_types/string>`      |           |        |

## Methods

<div class="rst-class">

table-centered_column_4

</div>

| Name                                       | Parameters                                                                                       | Returns | Shared |
|--------------------------------------------|--------------------------------------------------------------------------------------------------|---------|--------|
| `Close<dbkit.container.close-method>`      |                                                                                                  |         |        |
| `Constructor<dbkit.container.constructor>` | theRowsSource As `DBKit.SDK.RowsListControl`, createNewRow As `Boolean</api/data_types/boolean>` |         |        |

## Events

<div class="rst-class">

table-centered_column_4

</div>

| Name                                             | Parameters                                                    | Returns |
|--------------------------------------------------|---------------------------------------------------------------|---------|
| `Error<dbkit.container.error>`                   | error As `RuntimeException</api/exceptions/runtimeexception>` |         |
| `RowChanged<dbkit.container.rowchanged>`         | row As `DBKit.Row</api/databases/dbkit/row>`                  |         |
| `RowCreated<dbkit.container.rowcreated>`         | row As `DBKit.Row</api/databases/dbkit/row>`                  |         |
| `RowDeleted<dbkit.container.rowdeleted>`         | row As `DBKit.Row</api/databases/dbkit/row>`                  |         |
| `RowEditing<dbkit.container.rowediting>`         | row As `DBKit.Row</api/databases/dbkit/row>`                  |         |
| `RowLoaded<dbkit.container.rowloaded>`           | row As `DBKit.Row</api/databases/dbkit/row>`                  |         |
| `RowNotSelected<dbkit.container.rownotselected>` |                                                               |         |
| `RowSaved<dbkit.container.rowsaved>`             | row As `DBKit.Row</api/databases/dbkit/row>`                  |         |
| `RowSaving<dbkit.container.rowsaving>`           | row As `DBKit.Row</api/databases/dbkit/row>`                  |         |
| `RowUndone<dbkit.container.rowundone>`           | row As `DBKit.Row</api/databases/dbkit/row>`                  |         |

## Property descriptions

<div id="dbkit.container.automatichints">

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

</div>

<div class="rst-class">

forsearch

</div>

DBKit.Container.AutomaticHints

**AutomaticHints** As `Boolean</api/data_types/boolean>`

> Whether the controls on this container automatically set their Hint from the database column's display name when no Hint is set.
>
> The default is True.

<div id="dbkit.container.confirmcancelbuttoncaption">

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

</div>

<div class="rst-class">

forsearch

</div>

DBKit.Container.ConfirmCancelButtonCaption

**ConfirmCancelButtonCaption** As `String</api/data_types/string>`

> The caption of the Cancel button in the unsaved-changes confirmation dialog.
>
> The default is "Cancel".

<div id="dbkit.container.confirmcontinuebuttoncaption">

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

</div>

<div class="rst-class">

forsearch

</div>

DBKit.Container.ConfirmContinueButtonCaption

**ConfirmContinueButtonCaption** As `String</api/data_types/string>`

> The caption of the Continue button in the unsaved-changes confirmation dialog.
>
> The default is "Continue".

<div id="dbkit.container.currentrow">

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

</div>

<div class="rst-class">

forsearch

</div>

DBKit.Container.CurrentRow

**CurrentRow** As `DBKit.Row</api/databases/dbkit/row>`

> The current row of the database table this container operates on.

<div id="dbkit.container.database">

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

</div>

<div class="rst-class">

forsearch

</div>

DBKit.Container.Database

**Database** As `Database</api/databases/database>`

> The database this container operates on.

<div id="dbkit.container.deleteconfirmexplanation">

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

</div>

<div class="rst-class">

forsearch

</div>

DBKit.Container.DeleteConfirmExplanation

**DeleteConfirmExplanation** As `String</api/data_types/string>`

> The explanation text of the delete confirmation dialog.
>
> The default is "This action cannot be undone."

<div id="dbkit.container.deleteconfirmmessage">

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

</div>

<div class="rst-class">

forsearch

</div>

DBKit.Container.DeleteConfirmMessage

**DeleteConfirmMessage** As `String</api/data_types/string>`

> The message text of the delete confirmation dialog.
>
> The default is "Are you sure you want to delete this record?".

<div id="dbkit.container.deleteconfirmtitle">

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

</div>

<div class="rst-class">

forsearch

</div>

DBKit.Container.DeleteConfirmTitle

**DeleteConfirmTitle** As `String</api/data_types/string>`

> The title of the delete confirmation dialog.
>
> The default is "Delete Record".

<div id="dbkit.container.orderby">

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

</div>

<div class="rst-class">

forsearch

</div>

DBKit.Container.OrderBy

**OrderBy** As `String</api/data_types/string>`

> The sort order used when loading rows from the database table.

<div id="dbkit.container.selectedrowindex">

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

</div>

<div class="rst-class">

forsearch

</div>

DBKit.Container.SelectedRowIndex

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

> The index of the currently selected row in the list control.

<div id="dbkit.container.tablename">

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

</div>

<div class="rst-class">

forsearch

</div>

DBKit.Container.TableName

**TableName** As `String</api/data_types/string>`

> The name of the database table this container operates on.

<div id="dbkit.container.tablerelationships">

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

</div>

<div class="rst-class">

forsearch

</div>

DBKit.Container.TableRelationships

**TableRelationships** As `String</api/data_types/string>`

> The relationships between this container's table and other tables, with one relationship per line in the format childTableName.childColumnName = parentTableName.parentColumnName. Appending = viaColumnName is optional and specifies the via column, which identifies which relationship to use when the child table has more than one foreign key to the same parent table.
>
> The child column is the foreign key and the parent column is the primary key it refers to. The relationships are loaded when the container opens and are used to find related rows.

<div id="dbkit.container.unsavedchangesexplanation">

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

</div>

<div class="rst-class">

forsearch

</div>

DBKit.Container.UnsavedChangesExplanation

**UnsavedChangesExplanation** As `String</api/data_types/string>`

> The explanation text of the unsaved-changes confirmation dialog.
>
> The default is "If you continue, your changes will not be saved.".

<div id="dbkit.container.unsavedchangesmessage">

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

</div>

<div class="rst-class">

forsearch

</div>

DBKit.Container.UnsavedChangesMessage

**UnsavedChangesMessage** As `String</api/data_types/string>`

> The message text of the unsaved-changes confirmation dialog.
>
> The default is "You have unsaved changes.".

<div id="dbkit.container.unsavedchangestitle">

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

</div>

<div class="rst-class">

forsearch

</div>

DBKit.Container.UnsavedChangesTitle

**UnsavedChangesTitle** As `String</api/data_types/string>`

> The title of the unsaved-changes confirmation dialog.
>
> The default is "Unsaved Changes".

<div id="dbkit.container.where">

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

</div>

<div class="rst-class">

forsearch

</div>

DBKit.Container.Where

**Where** As `String</api/data_types/string>`

> The filter used when loading rows from the database table.

## Method descriptions

<div id="dbkit.container.close-method">

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

</div>

<div class="rst-class">

forsearch

</div>

DBKit.Container.Close

**Close**()

> Closes the container.
>
> <div class="important">
>
> <div class="title">
>
> Important
>
> </div>
>
> This method is only available in desktop projects.
>
> </div>

<div id="dbkit.container.constructor">

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

</div>

<div class="rst-class">

forsearch

</div>

DBKit.Container.Constructor

**Constructor**(theRowsSource As `DBKit.SDK.RowsListControl`, createNewRow As `Boolean</api/data_types/boolean>`)

> Called when the container is created. Sets up the container's layout and optionally creates a new row. *theRowsSource* is the rows list control the container is associated with; pass Nil for none. *createNewRow* is True to create a new row when the container opens.

## Event descriptions

<div id="dbkit.container.error">

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

</div>

<div class="rst-class">

forsearch

</div>

DBKit.Container.Error

**Error**(error As `RuntimeException</api/exceptions/runtimeexception>`)

> The error passed to this event has occurred.

<div id="dbkit.container.rowchanged">

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

</div>

<div class="rst-class">

forsearch

</div>

DBKit.Container.RowChanged

**RowChanged**(row As `DBKit.Row</api/databases/dbkit/row>`)

> The current row (passed to the event) has been changed.

<div id="dbkit.container.rowcreated">

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

</div>

<div class="rst-class">

forsearch

</div>

DBKit.Container.RowCreated

**RowCreated**(row As `DBKit.Row</api/databases/dbkit/row>`)

> A new row (passed to the event) was just created and is now the current row.

<div id="dbkit.container.rowdeleted">

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

</div>

<div class="rst-class">

forsearch

</div>

DBKit.Container.RowDeleted

**RowDeleted**(row As `DBKit.Row</api/databases/dbkit/row>`)

> The current row (passed to the event) has been deleted.

<div id="dbkit.container.rowediting">

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

</div>

<div class="rst-class">

forsearch

</div>

DBKit.Container.RowEditing

**RowEditing**(row As `DBKit.Row</api/databases/dbkit/row>`)

> The current row (passed to the event) is being edited by the user.

<div id="dbkit.container.rowloaded">

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

</div>

<div class="rst-class">

forsearch

</div>

DBKit.Container.RowLoaded

**RowLoaded**(row As `DBKit.Row</api/databases/dbkit/row>`)

> The current row (passed to the event) has been loaded.

<div id="dbkit.container.rownotselected">

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

</div>

<div class="rst-class">

forsearch

</div>

DBKit.Container.RowNotSelected

**RowNotSelected**

> There is no row currently selected.

<div id="dbkit.container.rowsaved">

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

</div>

<div class="rst-class">

forsearch

</div>

DBKit.Container.RowSaved

**RowSaved**(row As `DBKit.Row</api/databases/dbkit/row>`)

> The current row (passed to the event) has been saved.

<div id="dbkit.container.rowsaving">

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

</div>

<div class="rst-class">

forsearch

</div>

DBKit.Container.RowSaving

**RowSaving**(row As `DBKit.Row</api/databases/dbkit/row>`)

> The current row (passed to this event) is about to be saved.

<div id="dbkit.container.rowundone">

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

</div>

<div class="rst-class">

forsearch

</div>

DBKit.Container.RowUndone

**RowUndone**(row As `DBKit.Row</api/databases/dbkit/row>`)

> The changes made to the current row (passed to this event) have been undone.

## Notes

### Containers do not need a DBKit layout

A `DBKit.Container</api/databases/dbkit/container>` does not have to be placed on a `DBKit.Window</api/databases/dbkit/window>`. It is a layout in its own right: place it on any window, set its Database and TableName, and add DBKit controls to it.

### Connecting the layout to a database

Add a DatabaseConnection object to your project and assign it to the `Database<dbkit.container.database>` property in the Layout Editor. That is how the layout knows which database connection to use.

### How controls find their columns

If a control's ColumnName is blank, the control's own name is used as the column name. You only need to set ColumnName if you want a different column or cannot name the control the same as the column.

### Loading related rows

Use the `TableRelationships<dbkit.container.tablerelationships>` property to tell the layout about the relationships between its table and other tables. The relationships are loaded when the layout opens, allowing DBKit to automatically load related rows.

### Filtering and sorting rows

Use `Where<dbkit.container.where>` to filter which rows are loaded and `OrderBy<dbkit.container.orderby>` to sort them. Provide just the expression in each case, not the SQL keywords: set Where to `Country = 'USA'` rather than `WHERE Country = 'USA'`, and OrderBy to `LastName` rather than `ORDER BY LastName`.

### Localization

Localize the layout's user-facing text (the delete-confirmation and unsaved-changes dialog text and the confirmation button captions) the standard Xojo way: assign a dynamic constant to each property and provide translations for as many languages as you need, or localize the property values directly.

## Compatibility

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

<div id="dbkit.container.seealso">

<div class="seealso">

`DesktopContainer</api/user_interface/desktop/desktopcontainer>` parent class; `DBKit.Row</api/databases/dbkit/row>` class.

</div>

</div>