Contents
Display Legacy Contents

 Print
    Group Database    
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.

See also
 
Updated: 11/5/2014 5:20 PM