Datatable
|
Name |
Description |
|
DAvg |
Calculates the average of the values in the specified column |
|
DAvgIf |
Calculates the average of the values in the specified column, where the rows meet the criteria in the expression |
|
DColumnCount |
Return the number of columns in the table |
|
DContains |
Determine whether or not the table contains the specified value in the key column |
|
DContains |
Determine whether or not the table contains the specified values in the key columns |
|
DCount |
Return the number of records in the specified table |
|
DCountIf |
Return the number of records in the specified table, where the rows meet the criteria in the expression |
|
DEqual |
Return a boolean that indicates whether ot not the specified datatables are equal |
|
DExists |
Determine whether or not the table exists |
|
DFirst |
Get the first value of the specified table and column |
|
DFirstIf |
Get the first value of the specified table and column, where the rows meet the criteria in the expression |
|
DLast |
Get the last value of the specified table and column |
|
DLastIf |
Get the last value of the specified table and column, where the rows meet the criteria in the expression |
|
DLookup |
Single key lookup in datatable |
|
DLookup |
Multi key lookup in datatable |
|
DLookupExists |
Determine whether or not the specified lookup column exists in the table |
|
DLookupExists |
Determine whether or not the specified lookup column exists in the table |
|
DMax |
Get the maximum value of the specified table and column |
|
DMaxIf |
Get the maximum value of the specified table and column, where the rows meet the criteria in the expression |
|
DMedian |
Calculates the Median of the values in the specified column |
|
DMedianIf |
Calculates the Median of the values in the specified column, where the rows meet the criteria in the expression |
|
DMin |
Get the minimum value of the specified table and column |
|
DMinIf |
Get the minimum value of the specified table and column, where the rows meet the criteria in the expression |
|
DRowCount |
Return the number of rows in the table |
|
DStdev |
Calculates the Stdev of the values in the specified column |
|
DStdevIf |
Calculates the Stdev of the values in the specified column, where the rows meet the criteria in the expression |
|
DStdevP |
Calculates the StdevP of the values in the specified column |
|
DStdevPIf |
Calculates the StdevP of the values in the specified column, where the rows meet the criteria in the expression |
|
DSum |
Calculates the sum of the values in the specified column |
|
DSumIf |
Calculates the sum of the values in the specified column, where the rows meet the criteria in the expression |
|
DVar |
Calculates the Var of the values in the specified column |
|
DVarIf |
Calculates the Var of the values in the specified column, where the rows meet the criteria in the expression |
|
DVarP |
Calculates the VarP of the values in the specified column |
|
DVarPIf |
Calculates the VarP of the values in the specified column, where the rows meet the criteria in the expression |
|
IfDBNull |
Replace a testval by replaceVal if testval is DBNull |
|
IsDBNull |
Returns a Boolean indicating whether the specified value is DBNull (True) or not (False) |