Group Database

Kalipso - Developing - Form - Actions - Actions List - Group Database

Subgroup	Action	Description
SQL Statement	Kill Table	Deletes all records on a specified table according to specified conditions.
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	Exec. Procedure	Executes Remote Stored Procedure.
SQL Statement	SQL Advanced	This action specifies an SQL Statement manually created to be executed on a database connection.
Connection	Set DB Profile parameter	Modify Database connection 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.
Connection	Get DB Profile Parameter	Gets the Database connections parameters.
Data Link	Create/Update record	Create or Update a record at specified table based on controls links according to the primary key.
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	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.