Subgroup |
Action |
Description |
SQL Statement |
Insert |
Inserts a record on a specified table. |
SQL Statement |
Update |
Updates a record on specified table. |
SQL Statement |
Select |
Selects records from specified table. |
SQL Statement |
Delete |
Deletes record/records on specified table. |
SQL Statement |
SQL Advanced |
This action specifies an SQL Statement manually created to be executed on a database connection.
|
SQL Statement |
Kill Table |
Deletes all records on a specified table according to specified conditions. |
SQL Statement |
Exec.Procedure |
Executes Remote Stored Procedure. |
Connection |
Set DB Profile parameter |
Modify Database connection parameters. |
Connection |
Get DB Profile Parameter |
Gets the Database connections parameters. |
Connection |
Set Synchronization Status |
Modify the synchronizations status of specified records.
|
Connection |
Close All ODBC Connection |
Close all open ODBC connections on MIS Communicator. |
Data Link |
Create record |
Insert a record at specified table based on controls links. |
Data Link |
Update Record |
Update a record at specified table based on controls links according to the primary key.
|
Data Link |
Delete Record |
Delete a record at specified table based on controls links according to the primary key. |
Data Link |
Create/Update record |
Create or Update a record at specified table based on controls links according to the primary key. |
Data Link |
Next Record |
Moves to next record on a specified table on the current form. |
Data Link |
Previous Record |
Moves to previous record on a specified table on the current form. |
Data Link |
First Record |
Moves to first record on a specified table on the current form.
|
Data Link |
Last Record |
Moves to last record on a specified table on the current form. |
Data Link |
Go To Record |
This action moves to the specified record in a table. |
Transaction |
Begin Transaction |
Begin specified transaction on local database. |
Transaction |
Commit Transaction |
Commit specified transaction on local database.
|
Transaction |
Rollback Transaction |
Rollback specified transaction on local database.
|
SQLite |
Connect to SQLite |
Connect to specified local SQLite database. |
SQLite |
Disconnect from SQLite |
Disconnect from specified local SQLite database. |