| Cell
|
Returns the value from a column in the current row of the script data source. |
| CommitRecordsetRow
|
Adds a data row to the current recordset. |
| CreateRecordsetRow
|
Returns a new data row that can be populated and added to a recordset. |
| DeleteRecordsetRow
|
Deletes the current row from a recordset. |
FirstRow
|
Makes the first row in a recordset the active row. |
| GetDataSourceColumnNames
|
Returns an array of column names from the data source associated with the script. |
| GetRecordsetColumnNames
|
Returns an array of column names from a recordset or data row. |
| GetRowValue
|
Returns the column value from the current row of a recordset. |
| GetSQLScalar
|
Returns a value from a data source linked to an external datasheet based on a SQL scalar query. |
LastRow
|
Makes the last row in a recordset the active row. |
NextRow
|
Moves to the next row in a recordset. |
| OpenRecordset
|
Returns a recordset object opened from a datasheet. |
| OpenRecordsetQuery
|
Returns a recordset object from a data source linked to an external datasheet based on a SQL query. |
PrevRow
|
Moves to the previous row in a recordset. |
| RecordsetBOF
|
Returns True or False to indicate if the current recordset row index is before the beginning of the data. |
| RecordsetEOF
|
Returns True or False to indicate if the current recordset row index is past the end of the data. |
| RecordsetRowCount
|
Returns the total number of records in a recordset. |
| RunSQLCommand
|
Runs a SQL command on a data source linked to an external datasheet and returns the number of rows the command is performed on. |
| SetCell
|
Sets the column value in the current row of the script data source. |
SetRowValue
|
Sets a field value in a recordset or data row. |
