# 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.                                                    |


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://doc.sysdevmobile.com/kalipso5/developing/form/actions/actions-list/group-database.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.