Type
|
Method
|
Description
|
|
CloseCurrentView
|
Description:
|
short
|
DeleteSelectedRows
|
Description:
Parameters:
|
short
|
ExecuteInsert
|
Description:
Make sure to fill in all of the required parameters for your desired view.
Parameters:
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:
Make sure to fill in all of the required parameters for your desired view.
Parameters:
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:
Make sure to fill in all of the required parameters for your desired view.
Parameters:
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:
|
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
|