×
Menu
Index

3.6.1.6. ChronoExtDBViewer

v1.0.2.61 or greater
 
The ChronoExtDBViewer object allows you to control the External Data Viewer Panel.
 
Methods:
 
Type
Method
Description
 
CloseCurrentView
Description:
   Closes the current view on display on the External Data Viewer Panel. The panel will become blank.
 
short
DeleteSelectedRows
Description:
   Deletes the currently selected row on the External Data Viewer Panel.
 
Parameters:
   ViewName -  The name of the view as setup inside the External Data Viewer Panel Configuration
 
short
ExecuteInsert
Description:
   This runs the Insert statement set inside the External Data Viewer Panel Configuration.
   Make sure to fill in all of the required parameters for your desired view.
 
Parameters:
   ViewName - The name of the view as setup inside the External Data Viewer Panel Configuration
   INPUTPARAM - Up to 9 input parameters can be set. Those will correspond to the parameters set inside the Insert Statement configuration for the selected view
 
short
ExecuteUpdate
Since v.1.0.2.96
Description:
   This runs the Insert statement set inside the External Data Viewer Panel Configuration.
   Make sure to fill in all of the required parameters for your desired view.
 
Parameters:
   ViewName - The name of the view as setup inside the External Data Viewer Panel Configuration
   INPUTPARAM - Up to 10 input parameters can be set.
 
Returns:
   short: number of affected rows
 
 
string
GetLastError
Description:
   Return the last error message.
 
 
 
OpenView
Description:
   This runs the Select statement set inside the External Data Viewer Panel Configuration.
   Make sure to fill in all of the required parameters for your desired view.
   The result of the statement will show up on the External Data Viewer Panel.
 
Parameters:
   ViewName - The name of the view as setup inside the External Data Viewer Panel Configuration
   INPUTPARAM - Up to 8 input parameters can be set. Those will correspond to the parameters set inside the Select Statement configuration for the selected view
 
 
CurrentSelectedGetFieldValue
Since v.1.0.2.69
Description:
  Returns the value of a specified column from the selected row of the external data viewer
  INPUTPARAM - string: column_name
 
 
string
Input1GetValue
Since v.1.0.2.74
Description:
    Returns the value of the external data viewer input1 text field
 
void
Input1SetValue
Since v.1.0.2.74
Description:
  Sets the value for the the external data viewer input1 text field
 
Parameters:
  INPUTPARAM - string: value
 
 
ClearCurrentView
Since v.1.0.2.92
 
Description:
   Clear the data on the current view displaying on the External Data Viewer Panel.
long
GetRowCount()
Since v.1.0.2.95
Description:
   Returns the number of rows of the external data viewer table.
 
 
long
GetColCount()
Since v.1.0.2.95
Description:
   Returns the number of columns of the exteran data viewer table.
 
 
string
GetColType(<int> column)
Since v.1.0.2.95
 
Descriptions:
   Returns the specified column type
 
Parameters:
   column index : int
 
Output:
   column type; either "numeric", "string", "No data" or "" : string
 
 
long
GetColIndex(<string> colname)
Since v.1.0.2.96
Descriptions:
   Returns the specified column index (zero based)
 
Parameters:
   column name: string
 
Output:
   -1: no column found
   Number <integer> : column index
 
string
GetColName(<int> column)
Since v.1.0.2.95
Descriptions:
   Returns the specified column name
 
Parameters:
   column index : int
 
Output:
   column name or "No data" : string
 
 
double
GetCellValueNumeric(<int> row, <int> column)
Since v.1.0.2.95
Descriptions:
   Returns the specified cell value as a numeric double
 
Parameters:
   row index: int
   column index : int
 
Output:
   cell value : double
 
* specified cell must be a numeric value, otherwise it will return 0
 
 
string
GetCellValueString(<int> row, <int> column)
Since v.1.0.2.95
 
Descriptions:
   Returns the specified cell value as a string
 
Parameters:
   row index: int
   column index : int
 
Output:
   cell value : double
 
*It returns "" for NULL values
 
 
short
AddStyleClass(<int> row, <int> column, <string> styleclass)
Since v.1.0.2.95
 
Descriptions:
   Adds a style class to the specified cell by row and column indexes
 
Parameters:
   row index: int
   column index : int
   style class: string
            *style class must be one of these: default | primary | success | info | warning | danger
 
Output:
   1 for success
   0 for not success
 
 
short
RemoveStyleClass(<int> row, <int> column)
Since v.1.0.2.95
 
Descriptions:
   Removes any style class a cell has
 
Parameters:
   row index: int
   column index : int
 
Output:
   1 for success
   0 for not success