Skip to content

Database

Database object. Use it to read and write ADO data sources.

Action Summary

Action Description
DoAttach Attaches to a Database with given ADO connection string and SQL query.
DoMoveToRow Moves to a given row.
DoRandom Selects random row and column in the recordset.
DoSequential Advances to the next row in the table.
GetColumnCount Gets columns count.
GetColumnName Gets column name.
GetColumnNames Gets column names.
GetCurrentRowIndex Get zero based current row index.
GetRowCount Gets rows count.
GetValue Gets value by column name, and, optionally, row number.

Action Detail

DoAttach

Attaches to a Database with given ADO connection string and SQL query.

Database.DoAttach(connection_string, sql)

Parameters:

Name Type Description
connection_string string ADO connection string.
sql SQL Query (i.e. 'select * from Customers')
Optional.

Returns:

true, if successful

DoMoveToRow

Moves to a given row.

Database.DoMoveToRow(rowInd)

Parameters:

Name Type Description
rowInd number Row index to set active.

DoRandom

Selects random row and column in the recordset.

Database.DoRandom()

Returns:

'false' if the the DB is is not connected, 'true' - otherwise.

DoSequential

Advances to the next row in the table. When the end of the range is reached DoSequential returns 'false'.

Database.DoSequential()

Returns:

'false' if being called when active row is the last row or the recordset is not attached, 'true' - otherwise.

GetColumnCount

Gets columns count.

Database.GetColumnCount()

Returns:

Number of Columns in the result set.

GetColumnName

Gets column name.

Database.GetColumnName(ind)

Parameters:

Name Type Description
ind number Column index.

Returns:

Name of column in the spreadsheet.

GetColumnNames

Gets column names.

Database.GetColumnNames()

Returns:

Array of column names in the table.

GetCurrentRowIndex

Get zero based current row index.

Database.GetCurrentRowIndex()

GetRowCount

Gets rows count.

Database.GetRowCount()

Returns:

Number of rows in the result set.

GetValue

Gets value by column name, and, optionally, row number. Returns current cell value after DoSequential or DoRandom if params not set.

Database.GetValue(columnId, rowId)

Parameters:

Name Type Description
columnId Number | String Column index or name. If not set 1st column is used.
Optional.
rowId number Row index. If not set current row is used.
Optional.