> For the complete documentation index, see [llms.txt](https://doc.sysdevmobile.com/kalipso5/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://doc.sysdevmobile.com/kalipso5/developing/form/actions/actions-list/group-database.md).

# Group Database

| **Subgroup**  | **Action**                                                                                                                       | **Description**                                                                                     |
| ------------- | -------------------------------------------------------------------------------------------------------------------------------- | --------------------------------------------------------------------------------------------------- |
| SQL Statement | [Kill Table](/kalipso5/developing/form/actions/actions-description/group-database/kill-table.md)                                 | Deletes all records on a specified table according to specified conditions.                         |
| SQL Statement | [Insert](/kalipso5/developing/form/actions/actions-description/group-database/insert.md)                                         | Inserts a record on a specified table.                                                              |
| SQL Statement | [Update](/kalipso5/developing/form/actions/actions-description/group-database/update.md)                                         | Updates a record on specified table.                                                                |
| SQL Statement | [Select](/kalipso5/developing/form/actions/actions-description/group-database/select.md)                                         | Selects records from specified table.                                                               |
| SQL Statement | [Delete](/kalipso5/developing/form/actions/actions-description/group-database/delete.md)                                         | Deletes record/records on specified table.                                                          |
| SQL Statement | [Exec. Procedure](/kalipso5/developing/form/actions/actions-description/group-database/exec.-procedure.md)                       | Executes Remote Stored Procedure.                                                                   |
| SQL Statement | [SQL Advanced](/kalipso5/developing/form/actions/actions-description/group-database/sql-advanced.md)                             | This action specifies an SQL Statement manually created to be executed on a database connection.    |
|               |                                                                                                                                  |                                                                                                     |
| Connection    | [Set DB Profile parameter](/kalipso5/developing/form/actions/actions-description/group-database/set-db-profile-parameter.md)     | Modify Database connection parameters.                                                              |
| Connection    | [Set Synchronization Status](/kalipso5/developing/form/actions/actions-description/group-database/set-synchronization-status.md) | <p>Modify the synchronizations status of specified records.<br></p>                                 |
| Connection    | [Close All ODBC Connection](/kalipso5/developing/form/actions/actions-description/group-database/close-all-odbc-connections.md)  | Close all open ODBC connections on MIS Communicator.                                                |
| Connection    | [Get DB Profile Parameter](/kalipso5/developing/form/actions/actions-description/group-database/get-db-profile-parameter.md)     | Gets the Database connections parameters.                                                           |
|               |                                                                                                                                  |                                                                                                     |
| Data Link     | [Create/Update record](/kalipso5/developing/form/actions/actions-description/group-database/create-update-record.md)             | Create or Update a record at specified table based on controls links according to the primary key.  |
| Data Link     | [Create record](/kalipso5/developing/form/actions/actions-description/group-database/create-record.md)                           | Insert a record at specified table based on controls links.                                         |
| Data Link     | [Update Record](/kalipso5/developing/form/actions/actions-description/group-database/update-record.md)                           | <p>Update a record at specified table based on controls links according to the primary key.<br></p> |
| Data Link     | [Delete Record](/kalipso5/developing/form/actions/actions-description/group-database/delete-record.md)                           | Delete a record at specified table based on controls links according to the primary key.            |
| Data Link     | [Next Record](/kalipso5/developing/form/actions/actions-description/group-database/next-record.md)                               | Moves to next record on a specified table on the current form.                                      |
| Data Link     | [Previous Record](/kalipso5/developing/form/actions/actions-description/group-database/previous-record.md)                       | Moves to previous record on a specified table on the current form.                                  |
| Data Link     | [First Record](/kalipso5/developing/form/actions/actions-description/group-database/first-record.md)                             | <p>Moves to first record on a specified table on the current form.<br></p>                          |
| Data Link     | [Last Record](/kalipso5/developing/form/actions/actions-description/group-database/last-record.md)                               | Moves to last record on a specified table on the current form.                                      |
| Data Link     | [Go To Record](/kalipso5/developing/form/actions/actions-description/group-database/go-to-record.md)                             | This action moves to the specified record in a table.                                               |
|               |                                                                                                                                  |                                                                                                     |
| Transaction   | [Begin Transaction](/kalipso5/developing/form/actions/actions-description/group-database/begin-transaction.md)                   | Begin specified transaction on local database.                                                      |
| Transaction   | [Commit Transaction](/kalipso5/developing/form/actions/actions-description/group-database/commit-transaction.md)                 | <p>Commit specified transaction on local database.<br></p>                                          |
| Transaction   | [Rollback Transaction](/kalipso5/developing/form/actions/actions-description/group-database/rollback-transaction.md)             | <p>Rollback specified transaction on local database.<br></p>                                        |
|               |                                                                                                                                  |                                                                                                     |
| SQLite        | [Connect to SQLite](/kalipso5/developing/form/actions/actions-description/group-database/connect-to-sqlite.md)                   | Connect to specified local SQLite database.                                                         |
| SQLite        | [Disconnect from SQLite](/kalipso5/developing/form/actions/actions-description/group-database/disconnect-sqlite.md)              | Disconnect from specified local SQLite database.                                                    |