Class JdbcResultSet

JdbcResultSet

A JDBC ResultSet. For documentation of this class, see java.sql.ResultSet .

Methods

MethodReturn typeBrief description
absolute(row)BooleanFor documentation of this method, see java.sql.ResultSet#absolute(int).
afterLast()voidFor documentation of this method, see java.sql.ResultSet#afterLast().
beforeFirst()voidFor documentation of this method, see java.sql.ResultSet#beforeFirst().
cancelRowUpdates()voidFor documentation of this method, see java.sql.ResultSet#cancelRowUpdates().
clearWarnings()voidFor documentation of this method, see java.sql.ResultSet#clearWarnings().
close()voidFor documentation of this method, see java.sql.ResultSet#close().
deleteRow()voidFor documentation of this method, see java.sql.ResultSet#deleteRow().
findColumn(columnLabel)IntegerFor documentation of this method, see java.sql.ResultSet#findColumn(String).
first()BooleanFor documentation of this method, see java.sql.ResultSet#first().
getArray(columnIndex)JdbcArrayFor documentation of this method, see java.sql.ResultSet#getArray(int).
getArray(columnLabel)JdbcArrayFor documentation of this method, see java.sql.ResultSet#getArray(String).
getBigDecimal(columnIndex)BigNumberFor documentation of this method, see java.sql.ResultSet#getBigDecimal(int).
getBigDecimal(columnLabel)BigNumberFor documentation of this method, see java.sql.ResultSet#getBigDecimal(String).
getBlob(columnIndex)JdbcBlobFor documentation of this method, see java.sql.ResultSet#getBlob(int).
getBlob(columnLabel)JdbcBlobFor documentation of this method, see java.sql.ResultSet#getBlob(String).
getBoolean(columnIndex)BooleanFor documentation of this method, see java.sql.ResultSet#getBoolean(int).
getBoolean(columnLabel)BooleanFor documentation of this method, see java.sql.ResultSet#getBoolean(String).
getByte(columnIndex)ByteFor documentation of this method, see java.sql.ResultSet#getByte(int).
getByte(columnLabel)ByteFor documentation of this method, see java.sql.ResultSet#getByte(String).
getBytes(columnIndex)Byte[]For documentation of this method, see java.sql.ResultSet#getBytes(int).
getBytes(columnLabel)Byte[]For documentation of this method, see java.sql.ResultSet#getBytes(String).
getClob(columnIndex)JdbcClobFor documentation of this method, see java.sql.ResultSet#getClob(int).
getClob(columnLabel)JdbcClobFor documentation of this method, see java.sql.ResultSet#getClob(String).
getConcurrency()IntegerFor documentation of this method, see java.sql.ResultSet#getConcurrency().
getCursorName()StringFor documentation of this method, see java.sql.ResultSet#getCursorName().
getDate(columnIndex)JdbcDateFor documentation of this method, see java.sql.ResultSet#getDate(int).
getDate(columnIndex, timeZone)JdbcDateFor documentation of this method, see java.sql.ResultSet#getDate(int, Calendar).
getDate(columnLabel)JdbcDateFor documentation of this method, see java.sql.ResultSet#getDate(String).
getDate(columnLabel, timeZone)JdbcDateFor documentation of this method, see java.sql.ResultSet#getDate(String, Calendar).
getDouble(columnIndex)NumberFor documentation of this method, see java.sql.ResultSet#getDouble(int).
getDouble(columnLabel)NumberFor documentation of this method, see java.sql.ResultSet#getDouble(String).
getFetchDirection()IntegerFor documentation of this method, see java.sql.ResultSet#getFetchDirection().
getFetchSize()IntegerFor documentation of this method, see java.sql.ResultSet#getFetchSize().
getFloat(columnIndex)NumberFor documentation of this method, see java.sql.ResultSet#getFloat(int).
getFloat(columnLabel)NumberFor documentation of this method, see java.sql.ResultSet#getFloat(String).
getHoldability()IntegerFor documentation of this method, see java.sql.ResultSet#getHoldability().
getInt(columnIndex)IntegerFor documentation of this method, see java.sql.ResultSet#getInt(int).
getInt(columnLabel)IntegerFor documentation of this method, see java.sql.ResultSet#getInt(String).
getLong(columnIndex)IntegerFor documentation of this method, see java.sql.ResultSet#getLong(int).
getLong(columnLabel)IntegerFor documentation of this method, see java.sql.ResultSet#getLong(String).
getMetaData()JdbcResultSetMetaDataFor documentation of this method, see java.sql.ResultSet#getMetaData().
getNClob(columnIndex)JdbcClobFor documentation of this method, see java.sql.ResultSet#getNClob(int).
getNClob(columnLabel)JdbcClobFor documentation of this method, see java.sql.ResultSet#getNClob(String).
getNString(columnIndex)StringFor documentation of this method, see java.sql.ResultSet#getNString(int).
getNString(columnLabel)StringFor documentation of this method, see java.sql.ResultSet#getNString(String).
getObject(columnIndex)ObjectFor documentation of this method, see java.sql.ResultSet#getObject(int).
getObject(columnLabel)ObjectFor documentation of this method, see java.sql.ResultSet#getObject(String).
getRef(columnIndex)JdbcRefFor documentation of this method, see java.sql.ResultSet#getRef(int).
getRef(columnLabel)JdbcRefFor documentation of this method, see java.sql.ResultSet#getRef(String).
getRow()IntegerFor documentation of this method, see java.sql.ResultSet#getRow().
getRowId(columnIndex)JdbcRowIdFor documentation of this method, see java.sql.ResultSet#getRowId(int).
getRowId(columnLabel)JdbcRowIdFor documentation of this method, see java.sql.ResultSet#getRowId(String).
getSQLXML(columnIndex)JdbcSQLXMLFor documentation of this method, see java.sql.ResultSet#getSQLXML(int).
getSQLXML(columnLabel)JdbcSQLXMLFor documentation of this method, see java.sql.ResultSet#getSQLXML(String).
getShort(columnIndex)IntegerFor documentation of this method, see java.sql.ResultSet#getShort(int).
getShort(columnLabel)IntegerFor documentation of this method, see java.sql.ResultSet#getShort(String).
getStatement()JdbcStatementFor documentation of this method, see java.sql.ResultSet#getStatement().
getString(columnIndex)StringFor documentation of this method, see java.sql.ResultSet#getString(int).
getString(columnLabel)StringFor documentation of this method, see java.sql.ResultSet#getString(String).
getTime(columnIndex)JdbcTimeFor documentation of this method, see java.sql.ResultSet#getTime(int).
getTime(columnIndex, timeZone)JdbcTimeFor documentation of this method, see java.sql.ResultSet#getTime(int, Calendar).
getTime(columnLabel)JdbcTimeFor documentation of this method, see java.sql.ResultSet#getTime(String).
getTime(columnLabel, timeZone)JdbcTimeFor documentation of this method, see java.sql.ResultSet#getTime(String, Calendar).
getTimestamp(columnIndex)JdbcTimestampFor documentation of this method, see java.sql.ResultSet#getTimestamp(int).
getTimestamp(columnIndex, timeZone)JdbcTimestampFor documentation of this method, see java.sql.ResultSet#getTimestamp(int, Calendar).
getTimestamp(columnLabel)JdbcTimestampFor documentation of this method, see java.sql.ResultSet#getTimestamp(String).
getTimestamp(columnLabel, timeZone)JdbcTimestampFor documentation of this method, see java.sql.ResultSet#getTimestamp(String, Calendar).
getType()IntegerFor documentation of this method, see java.sql.ResultSet#getType().
getURL(columnIndex)StringFor documentation of this method, see java.sql.ResultSet#getURL(int).
getURL(columnLabel)StringFor documentation of this method, see java.sql.ResultSet#getURL(String).
getWarnings()String[]Returns the current set of warnings reported by the driver.
insertRow()voidFor documentation of this method, see java.sql.ResultSet#insertRow().
isAfterLast()BooleanFor documentation of this method, see java.sql.ResultSet#isAfterLast().
isBeforeFirst()BooleanFor documentation of this method, see java.sql.ResultSet#isBeforeFirst().
isClosed()BooleanFor documentation of this method, see java.sql.ResultSet#isClosed().
isFirst()BooleanFor documentation of this method, see java.sql.ResultSet#isFirst().
isLast()BooleanFor documentation of this method, see java.sql.ResultSet#isLast().
last()BooleanFor documentation of this method, see java.sql.ResultSet#first().
moveToCurrentRow()voidFor documentation of this method, see java.sql.ResultSet#moveToCurrentRow().
moveToInsertRow()voidFor documentation of this method, see java.sql.ResultSet#moveToInsertRow().
next()BooleanFor documentation of this method, see java.sql.ResultSet#next().
previous()BooleanFor documentation of this method, see java.sql.ResultSet#previous().
refreshRow()voidFor documentation of this method, see java.sql.ResultSet#refreshRow().
relative(rows)BooleanFor documentation of this method, see java.sql.ResultSet#relative(int).
rowDeleted()BooleanFor documentation of this method, see java.sql.ResultSet#rowDeleted().
rowInserted()BooleanFor documentation of this method, see java.sql.ResultSet#rowInserted().
rowUpdated()BooleanFor documentation of this method, see java.sql.ResultSet#rowUpdated().
setFetchDirection(direction)voidFor documentation of this method, see java.sql.ResultSet#setFetchDirection(int).
setFetchSize(rows)voidFor documentation of this method, see java.sql.ResultSet#setFetchSize(int).
updateArray(columnIndex, x)voidFor documentation of this method, see java.sql.ResultSet#updateArray(int, Array).
updateArray(columnLabel, x)voidFor documentation of this method, see java.sql.ResultSet#updateArray(String, Array).
updateBigDecimal(columnIndex, x)voidFor documentation of this method, see java.sql.ResultSet#updateBigDecimal(int, BigDecimal).
updateBigDecimal(columnLabel, x)voidFor documentation of this method, see java.sql.ResultSet#updateBigDecimal(String, BigDecimal).
updateBlob(columnIndex, x)voidFor documentation of this method, see java.sql.ResultSet#updateBlob(int, Blob).
updateBlob(columnLabel, x)voidFor documentation of this method, see java.sql.ResultSet#updateRef(String, Blob).
updateBoolean(columnIndex, x)voidFor documentation of this method, see java.sql.ResultSet#updateBoolean(int, boolean).
updateBoolean(columnLabel, x)voidFor documentation of this method, see java.sql.ResultSet#updateBoolean(String, boolean).
updateByte(columnIndex, x)voidFor documentation of this method, see java.sql.ResultSet#updateByte(int, byte).
updateByte(columnLabel, x)voidFor documentation of this method, see java.sql.ResultSet#updateByte(String, byte).
updateBytes(columnIndex, x)voidFor documentation of this method, see java.sql.ResultSet#updateBytes(int, byte[]).
updateBytes(columnLabel, x)voidFor documentation of this method, see java.sql.ResultSet#updateBytes(String, byte[]).
updateClob(columnIndex, x)voidFor documentation of this method, see java.sql.ResultSet#updateClob(int, Clob).
updateClob(columnLabel, x)voidFor documentation of this method, see java.sql.ResultSet#updateClob(String, Clob).
updateDate(columnIndex, x)voidFor documentation of this method, see java.sql.ResultSet#updateDate(int, Date).
updateDate(columnLabel, x)voidFor documentation of this method, see java.sql.ResultSet#updateDate(String, Date).
updateDouble(columnIndex, x)voidFor documentation of this method, see java.sql.ResultSet#updateDouble(int, double).
updateDouble(columnLabel, x)voidFor documentation of this method, see java.sql.ResultSet#updateDouble(String, double).
updateFloat(columnIndex, x)voidFor documentation of this method, see java.sql.ResultSet#updateFloat(int, float).
updateFloat(columnLabel, x)voidFor documentation of this method, see java.sql.ResultSet#updateFloat(String, float).
updateInt(columnIndex, x)voidFor documentation of this method, see java.sql.ResultSet#updateInt(int, int).
updateInt(columnLabel, x)voidFor documentation of this method, see java.sql.ResultSet#updateInt(String, int).
updateLong(columnIndex, x)voidFor documentation of this method, see java.sql.ResultSet#updateLong(int, long).
updateLong(columnLabel, x)voidFor documentation of this method, see java.sql.ResultSet#updateLong(String, long).
updateNClob(columnIndex, x)voidFor documentation of this method, see java.sql.ResultSet#updateNClob(int, NClob).
updateNClob(columnLabel, x)voidFor documentation of this method, see java.sql.ResultSet#updateNClob(String, NClob).
updateNString(columnIndex, x)voidFor documentation of this method, see java.sql.ResultSet#updateNString(int, String).
updateNString(columnLabel, x)voidFor documentation of this method, see java.sql.ResultSet#updateNString(String, String).
updateNull(columnIndex)voidFor documentation of this method, see java.sql.ResultSet#updateNull(int).
updateNull(columnLabel)voidFor documentation of this method, see java.sql.ResultSet#updateNull(String).
updateObject(columnIndex, x)voidFor documentation of this method, see java.sql.ResultSet#updateObject(int, Object).
updateObject(columnIndex, x, scaleOrLength)voidFor documentation of this method, see java.sql.ResultSet#updateObject(int, Object, int).
updateObject(columnLabel, x)voidFor documentation of this method, see java.sql.ResultSet#updateObject(String, Object).
updateObject(columnLabel, x, scaleOrLength)voidFor documentation of this method, see java.sql.ResultSet#updateObject(String, Object, int).
updateRef(columnIndex, x)voidFor documentation of this method, see java.sql.ResultSet#updateRef(int, Ref).
updateRef(columnLabel, x)voidFor documentation of this method, see java.sql.ResultSet#updateRef(String, Ref).
updateRow()voidFor documentation of this method, see java.sql.ResultSet#updateRow().
updateRowId(columnIndex, x)voidFor documentation of this method, see java.sql.ResultSet#updateRowId(int, RowId).
updateRowId(columnLabel, x)voidFor documentation of this method, see java.sql.ResultSet#updateRowId(String, RowId).
updateSQLXML(columnIndex, x)voidFor documentation of this method, see java.sql.ResultSet#updateSQLXML(int, SQLXML).
updateSQLXML(columnLabel, x)voidFor documentation of this method, see java.sql.ResultSet#updateSQLXML(String, SQLXML).
updateShort(columnIndex, x)voidFor documentation of this method, see java.sql.ResultSet#updateShort(int, short).
updateShort(columnLabel, x)voidFor documentation of this method, see java.sql.ResultSet#updateShort(String, short).
updateString(columnIndex, x)voidFor documentation of this method, see java.sql.ResultSet#updateString(int, String).
updateString(columnLabel, x)voidFor documentation of this method, see java.sql.ResultSet#updateString(String, String).
updateTime(columnIndex, x)voidFor documentation of this method, see java.sql.ResultSet#updateTime(int, Time).
updateTime(columnLabel, x)voidFor documentation of this method, see java.sql.ResultSet#updateTime(String, Time).
updateTimestamp(columnIndex, x)voidFor documentation of this method, see java.sql.ResultSet#updateTimestamp(int, Timestamp).
updateTimestamp(columnLabel, x)voidFor documentation of this method, see java.sql.ResultSet#updateTimestamp(String, Timestamp).
wasNull()BooleanFor documentation of this method, see java.sql.ResultSet#wasNull().

Detailed documentation

absolute(row)

For documentation of this method, see java.sql.ResultSet#absolute(int).

Parameters

NameTypeDescription
rowIntegerThe number of the row to which the cursor moves to. A positive number indicates the row number counting from the start of the result set, while a negative number indicates the counting from the end of the result set.

Return

Booleantrue if the cursor is moved to a position in this result set; false if the cursor is before the first row or after the last row.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

afterLast()

For documentation of this method, see java.sql.ResultSet#afterLast().

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

beforeFirst()

For documentation of this method, see java.sql.ResultSet#beforeFirst().

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

cancelRowUpdates()

For documentation of this method, see java.sql.ResultSet#cancelRowUpdates().

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

clearWarnings()

For documentation of this method, see java.sql.ResultSet#clearWarnings().

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

close()

For documentation of this method, see java.sql.ResultSet#close().


deleteRow()

For documentation of this method, see java.sql.ResultSet#deleteRow().

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

findColumn(columnLabel)

For documentation of this method, see java.sql.ResultSet#findColumn(String).

Parameters

NameTypeDescription
columnLabelStringThe label for the column, specified with the SQL AS clause. If the AS clause wasn't specified, then the label is the name of the column.

Return

Integer — The column index of the specified column.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

first()

For documentation of this method, see java.sql.ResultSet#first().

Return

Booleantrue if the cursor is on a valid row; false if there are no rows in the result set.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getArray(columnIndex)

For documentation of this method, see java.sql.ResultSet#getArray(int).

Parameters

NameTypeDescription
columnIndexIntegerThe index of the column to retrieve the data from (the first column is 1, the second is 2, and so on).

Return

JdbcArray — The value of the designated column in the current row of this result set as an array.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getArray(columnLabel)

For documentation of this method, see java.sql.ResultSet#getArray(String).

Parameters

NameTypeDescription
columnLabelStringThe label for the column, specified with the SQL AS clause. If the AS clause wasn't specified, then the label is the name of the column.

Return

JdbcArray — The value of the designated column in the current row of this result set as an array.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getBigDecimal(columnIndex)

For documentation of this method, see java.sql.ResultSet#getBigDecimal(int).

Parameters

NameTypeDescription
columnIndexIntegerThe index of the column to retrieve the data from (the first column is 1, the second is 2, and so on).

Return

BigNumber — The column value; null if the value was SQL NULL.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getBigDecimal(columnLabel)

For documentation of this method, see java.sql.ResultSet#getBigDecimal(String).

Parameters

NameTypeDescription
columnLabelStringThe label for the column, specified with the SQL AS clause. If the AS clause wasn't specified, then the label is the name of the column.

Return

BigNumber — The column value; null if the value was SQL NULL.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getBlob(columnIndex)

For documentation of this method, see java.sql.ResultSet#getBlob(int).

Parameters

NameTypeDescription
columnIndexIntegerThe index of the column to retrieve the data from (the first column is 1, the second is 2, and so on).

Return

JdbcBlob — The value of the designated column in the current row of this result set as a blob.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getBlob(columnLabel)

For documentation of this method, see java.sql.ResultSet#getBlob(String).

Parameters

NameTypeDescription
columnLabelStringThe label for the column, specified with the SQL AS clause. If the AS clause wasn't specified, then the label is the name of the column.

Return

JdbcBlob — The value of the designated column in the current row of this result set as a blob.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getBoolean(columnIndex)

For documentation of this method, see java.sql.ResultSet#getBoolean(int).

Parameters

NameTypeDescription
columnIndexIntegerThe index of the column to retrieve (the first column is 1, the second is 2, and so on).

Return

Boolean — The column value; false if the value was SQL NULL.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getBoolean(columnLabel)

For documentation of this method, see java.sql.ResultSet#getBoolean(String).

Parameters

NameTypeDescription
columnLabelStringThe label for the column, specified with the SQL AS clause. If the AS clause wasn't specified, then the label is the name of the column.

Return

Boolean — The column value; false if the value was SQL NULL.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getByte(columnIndex)

For documentation of this method, see java.sql.ResultSet#getByte(int).

Parameters

NameTypeDescription
columnIndexIntegerThe index of the column to retrieve (the first column is 1, the second is 2, and so on).

Return

Byte — The column value; 0 if the value was SQL NULL.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getByte(columnLabel)

For documentation of this method, see java.sql.ResultSet#getByte(String).

Parameters

NameTypeDescription
columnLabelStringThe label for the column, specified with the SQL AS clause. If the AS clause wasn't specified, then the label is the name of the column.

Return

Byte — The column value; 0 if the value was SQL NULL.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getBytes(columnIndex)

For documentation of this method, see java.sql.ResultSet#getBytes(int).

Parameters

NameTypeDescription
columnIndexIntegerThe index of the column to retrieve (the first column is 1, the second is 2, and so on).

Return

Byte[] — The column value; null if the value was SQL NULL.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getBytes(columnLabel)

For documentation of this method, see java.sql.ResultSet#getBytes(String).

Parameters

NameTypeDescription
columnLabelStringThe label for the column, specified with the SQL AS clause. If the AS clause wasn't specified, then the label is the name of the column.

Return

Byte[] — The column value; null if the value was SQL NULL.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getClob(columnIndex)

For documentation of this method, see java.sql.ResultSet#getClob(int).

Parameters

NameTypeDescription
columnIndexIntegerThe index of the column to retrieve the data from (the first column is 1, the second is 2, and so on).

Return

JdbcClob — The value of the designated column in the current row of this result set as a clob.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getClob(columnLabel)

For documentation of this method, see java.sql.ResultSet#getClob(String).

Parameters

NameTypeDescription
columnLabelStringThe label for the column, specified with the SQL AS clause. If the AS clause wasn't specified, then the label is the name of the column.

Return

JdbcClob — The value of the designated column in the current row of this result set as a clob.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getConcurrency()

For documentation of this method, see java.sql.ResultSet#getConcurrency().

Return

Integer — The concurrency type, which is either Jdbc.ResultSet.CONCUR_READ_ONLY or Jdbc.ResultSet.CONCUR_UPDATABLE.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getCursorName()

For documentation of this method, see java.sql.ResultSet#getCursorName().

Return

String — The SQL name for this result set's cursor.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getDate(columnIndex)

For documentation of this method, see java.sql.ResultSet#getDate(int).

Parameters

NameTypeDescription
columnIndexIntegerThe index of the column to retrieve (the first column is 1, the second is 2, and so on).

Return

JdbcDate — The column value; null if the value was SQL NULL.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getDate(columnIndex, timeZone)

For documentation of this method, see java.sql.ResultSet#getDate(int, Calendar).

Parameters

NameTypeDescription
columnIndexIntegerThe index of the column to retrieve (the first column is 1, the second is 2, and so on).
timeZoneStringA time zone string used to construct java.lang.Calendar instance, which in turn is used to build the date. Several formats of time zone strings are recognized: short IDs (such as PST, EST, and GMT), long IDs (such as US/Pacific and America/Los_Angeles), and offsets (such as GMT+6:30).

Return

JdbcDate — The column value; null if the value was SQL NULL.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getDate(columnLabel)

For documentation of this method, see java.sql.ResultSet#getDate(String).

Parameters

NameTypeDescription
columnLabelStringThe label for the column, specified with the SQL AS clause. If the AS clause wasn't specified, then the label is the name of the column.

Return

JdbcDate — The column value; null if the value was SQL NULL.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getDate(columnLabel, timeZone)

For documentation of this method, see java.sql.ResultSet#getDate(String, Calendar).

Parameters

NameTypeDescription
columnLabelStringThe label for the column, specified with the SQL AS clause. If the AS clause wasn't specified, then the label is the name of the column.
timeZoneStringA time zone string used to construct java.lang.Calendar instance, which in turn is used to build the date. Several formats of time zone strings are recognized: short IDs (such as PST, EST, and GMT), long IDs (such as US/Pacific and America/Los_Angeles), and offsets (such as GMT+6:30).

Return

JdbcDate — The column value; null if the value was SQL NULL.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getDouble(columnIndex)

For documentation of this method, see java.sql.ResultSet#getDouble(int).

Parameters

NameTypeDescription
columnIndexIntegerThe index of the column to retrieve (the first column is 1, the second is 2, and so on).

Return

Number — The column value; 0 if the value was SQL NULL.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getDouble(columnLabel)

For documentation of this method, see java.sql.ResultSet#getDouble(String).

Parameters

NameTypeDescription
columnLabelStringThe label for the column, specified with the SQL AS clause. If the AS clause wasn't specified, then the label is the name of the column.

Return

Number — The column value; 0 if the value was SQL NULL.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getFetchDirection()

For documentation of this method, see java.sql.ResultSet#getFetchDirection().

Return

Integer — The specified direction to set, which is either Jdbc.ResultSet.FETCH_FORWARD or Jdbc.ResultSet.FETCH_REVERSE.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getFetchSize()

For documentation of this method, see java.sql.ResultSet#getFetchSize().

Return

Integer — The current fetch size for this result set.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getFloat(columnIndex)

For documentation of this method, see java.sql.ResultSet#getFloat(int).

Parameters

NameTypeDescription
columnIndexIntegerThe index of the column to retrieve (the first column is 1, the second is 2, and so on).

Return

Number — The column value; 0 if the value was SQL NULL.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getFloat(columnLabel)

For documentation of this method, see java.sql.ResultSet#getFloat(String).

Parameters

NameTypeDescription
columnLabelStringThe label for the column, specified with the SQL AS clause. If the AS clause wasn't specified, then the label is the name of the column.

Return

Number — The column value; 0 if the value was SQL NULL.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getHoldability()

For documentation of this method, see java.sql.ResultSet#getHoldability().

Return

Integer — The holdability of this result set, which is either Jdbc.ResultSet.HOLD_CURSORS_OVER_COMMIT or Jdbc.ResultSet.CLOSE_CURSORS_AT_COMMIT.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getInt(columnIndex)

For documentation of this method, see java.sql.ResultSet#getInt(int).

Parameters

NameTypeDescription
columnIndexIntegerThe index of the column to retrieve (the first column is 1, the second is 2, and so on).

Return

Integer — The column value; 0 if the value was SQL NULL.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getInt(columnLabel)

For documentation of this method, see java.sql.ResultSet#getInt(String).

Parameters

NameTypeDescription
columnLabelStringThe label for the column, specified with the SQL AS clause. If the AS clause wasn't specified, then the label is the name of the column.

Return

Integer — The column value; 0 if the value was SQL NULL.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getLong(columnIndex)

For documentation of this method, see java.sql.ResultSet#getLong(int).

Parameters

NameTypeDescription
columnIndexIntegerThe index of the column to retrieve (the first column is 1, the second is 2, and so on).

Return

Integer — The column value; 0 if the value was SQL NULL.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getLong(columnLabel)

For documentation of this method, see java.sql.ResultSet#getLong(String).

Parameters

NameTypeDescription
columnLabelStringThe label for the column, specified with the SQL AS clause. If the AS clause wasn't specified, then the label is the name of the column.

Return

Integer — The column value; 0 if the value was SQL NULL.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getMetaData()

For documentation of this method, see java.sql.ResultSet#getMetaData().

Return

JdbcResultSetMetaData — The number, types, and properties of this result set's columns.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getNClob(columnIndex)

For documentation of this method, see java.sql.ResultSet#getNClob(int).

Parameters

NameTypeDescription
columnIndexIntegerThe index of the column to retrieve the data from (the first column is 1, the second is 2, and so on).

Return

JdbcClob — The column value of the current row.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getNClob(columnLabel)

For documentation of this method, see java.sql.ResultSet#getNClob(String).

Parameters

NameTypeDescription
columnLabelStringThe label for the column, specified with the SQL AS clause. If the AS clause wasn't specified, then the label is the name of the column.

Return

JdbcClob — The column value of the current row.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getNString(columnIndex)

For documentation of this method, see java.sql.ResultSet#getNString(int).

Parameters

NameTypeDescription
columnIndexIntegerThe index of the column to retrieve the data from (the first column is 1, the second is 2, and so on).

Return

String — The column value of the current row; null if the value is SQL NULL.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getNString(columnLabel)

For documentation of this method, see java.sql.ResultSet#getNString(String).

Parameters

NameTypeDescription
columnLabelStringThe label for the column, specified with the SQL AS clause. If the AS clause wasn't specified, then the label is the name of the column.

Return

String — The column value of the current row; null if the value is SQL NULL.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getObject(columnIndex)

For documentation of this method, see java.sql.ResultSet#getObject(int).

Parameters

NameTypeDescription
columnIndexIntegerThe index of the column to retrieve the data from (the first column is 1, the second is 2, and so on).

Return

Object — The value of the designated column in the current row of this result set.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getObject(columnLabel)

For documentation of this method, see java.sql.ResultSet#getObject(String).

Parameters

NameTypeDescription
columnLabelStringThe label for the column, specified with the SQL AS clause. If the AS clause wasn't specified, then the label is the name of the column.

Return

Object — The value of the designated column in the current row of this result set.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getRef(columnIndex)

For documentation of this method, see java.sql.ResultSet#getRef(int).

Parameters

NameTypeDescription
columnIndexIntegerThe index of the column to retrieve the data from (the first column is 1, the second is 2, and so on).

Return

JdbcRef — The value of the designated column in the current row of this result set as a reference.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getRef(columnLabel)

For documentation of this method, see java.sql.ResultSet#getRef(String).

Parameters

NameTypeDescription
columnLabelStringThe label for the column, specified with the SQL AS clause. If the AS clause wasn't specified, then the label is the name of the column.

Return

JdbcRef — The value of the designated column in the current row of this result set as a reference.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getRow()

For documentation of this method, see java.sql.ResultSet#getRow().

Return

Integer — The current row number, or 0 if there is no current row.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getRowId(columnIndex)

For documentation of this method, see java.sql.ResultSet#getRowId(int).

Parameters

NameTypeDescription
columnIndexIntegerThe index of the column to retrieve the data from (the first column is 1, the second is 2, and so on).

Return

JdbcRowId — The column row ID value; null if the value is SQL NULL.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getRowId(columnLabel)

For documentation of this method, see java.sql.ResultSet#getRowId(String).

Parameters

NameTypeDescription
columnLabelStringThe label for the column, specified with the SQL AS clause. If the AS clause wasn't specified, then the label is the name of the column.

Return

JdbcRowId — The column row ID value; null if the value is SQL NULL.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getSQLXML(columnIndex)

For documentation of this method, see java.sql.ResultSet#getSQLXML(int).

Parameters

NameTypeDescription
columnIndexIntegerThe index of the column to retrieve the data from (the first column is 1, the second is 2, and so on).

Return

JdbcSQLXML — The column value of the current row.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getSQLXML(columnLabel)

For documentation of this method, see java.sql.ResultSet#getSQLXML(String).

Parameters

NameTypeDescription
columnLabelStringThe label for the column, specified with the SQL AS clause. If the AS clause wasn't specified, then the label is the name of the column.

Return

JdbcSQLXML — The column value of the current row.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getShort(columnIndex)

For documentation of this method, see java.sql.ResultSet#getShort(int).

Parameters

NameTypeDescription
columnIndexIntegerThe index of the column to retrieve (the first column is 1, the second is 2, and so on).

Return

Integer — The column value; 0 if the value was SQL NULL.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getShort(columnLabel)

For documentation of this method, see java.sql.ResultSet#getShort(String).

Parameters

NameTypeDescription
columnLabelStringThe label for the column, specified with the SQL AS clause. If the AS clause wasn't specified, then the label is the name of the column.

Return

Integer — The column value; 0 if the value was SQL NULL.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getStatement()

For documentation of this method, see java.sql.ResultSet#getStatement().

Return

JdbcStatement — The statement that produced this result set, or null if the result set was produced some other way.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getString(columnIndex)

For documentation of this method, see java.sql.ResultSet#getString(int).

Parameters

NameTypeDescription
columnIndexIntegerThe index of the column to retrieve (the first column is 1, the second is 2, and so on).

Return

String — The column value; null if the value was SQL NULL.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getString(columnLabel)

For documentation of this method, see java.sql.ResultSet#getString(String).

Parameters

NameTypeDescription
columnLabelStringThe label for the column, specified with the SQL AS clause. If the AS clause wasn't specified, then the label is the name of the column.

Return

String — The column value; null if the value was SQL NULL.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getTime(columnIndex)

For documentation of this method, see java.sql.ResultSet#getTime(int).

Parameters

NameTypeDescription
columnIndexIntegerThe index of the column to retrieve (the first column is 1, the second is 2, and so on).

Return

JdbcTime — The column value; null if the value was SQL NULL.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getTime(columnIndex, timeZone)

For documentation of this method, see java.sql.ResultSet#getTime(int, Calendar).

Parameters

NameTypeDescription
columnIndexIntegerThe index of the column to retrieve (the first column is 1, the second is 2, and so on).
timeZoneStringA time zone string used to construct java.lang.Calendar instance, which in turn is used to build the date. Several formats of time zone strings are recognized: short IDs (such as PST, EST, and GMT), long IDs (such as US/Pacific and America/Los_Angeles), and offsets (such as GMT+6:30).

Return

JdbcTime — The column value; null if the value was SQL NULL.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getTime(columnLabel)

For documentation of this method, see java.sql.ResultSet#getTime(String).

Parameters

NameTypeDescription
columnLabelStringThe label for the column, specified with the SQL AS clause. If the AS clause wasn't specified, then the label is the name of the column.

Return

JdbcTime — The column value; null if the value was SQL NULL.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getTime(columnLabel, timeZone)

For documentation of this method, see java.sql.ResultSet#getTime(String, Calendar).

Parameters

NameTypeDescription
columnLabelStringThe label for the column, specified with the SQL AS clause. If the AS clause wasn't specified, then the label is the name of the column.
timeZoneStringA time zone string used to construct java.lang.Calendar instance, which in turn is used to build the date. Several formats of time zone strings are recognized: short IDs (such as PST, EST, and GMT), long IDs (such as US/Pacific and America/Los_Angeles), and offsets (such as GMT+6:30).

Return

JdbcTime — The column value; null if the value was SQL NULL.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getTimestamp(columnIndex)

For documentation of this method, see java.sql.ResultSet#getTimestamp(int).

Parameters

NameTypeDescription
columnIndexIntegerThe index of the column to retrieve (the first column is 1, the second is 2, and so on).

Return

JdbcTimestamp — The column value; null if the value was SQL NULL.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getTimestamp(columnIndex, timeZone)

For documentation of this method, see java.sql.ResultSet#getTimestamp(int, Calendar).

Parameters

NameTypeDescription
columnIndexIntegerThe index of the column to retrieve (the first column is 1, the second is 2, and so on).
timeZoneStringA time zone string used to construct java.lang.Calendar instance, which in turn is used to build the date. Several formats of time zone strings are recognized: short IDs (such as PST, EST, and GMT), long IDs (such as US/Pacific and America/Los_Angeles), and offsets (such as GMT+6:30).

Return

JdbcTimestamp — The column value; null if the value was SQL NULL.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getTimestamp(columnLabel)

For documentation of this method, see java.sql.ResultSet#getTimestamp(String).

Parameters

NameTypeDescription
columnLabelStringThe label for the column, specified with the SQL AS clause. If the AS clause wasn't specified, then the label is the name of the column.

Return

JdbcTimestamp — The column value; null if the value was SQL NULL.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getTimestamp(columnLabel, timeZone)

For documentation of this method, see java.sql.ResultSet#getTimestamp(String, Calendar).

Parameters

NameTypeDescription
columnLabelStringThe label for the column, specified with the SQL AS clause. If the AS clause wasn't specified, then the label is the name of the column.
timeZoneStringA time zone string used to construct java.lang.Calendar instance, which in turn is used to build the date. Several formats of time zone strings are recognized: short IDs (such as PST, EST, and GMT), long IDs (such as US/Pacific and America/Los_Angeles), and offsets (such as GMT+6:30).

Return

JdbcTimestamp — The column value; null if the value was SQL NULL.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getType()

For documentation of this method, see java.sql.ResultSet#getType().

Return

Integer — The type of this result set, which is one of Jdbc.ResultSet.TYPE_FORWARD_ONLY, Jdbc.ResultSet.TYPE_SCROLL_INSENSITIVE, or Jdbc.ResultSet.TYPE_SCROLL_INSENSITIVE.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getURL(columnIndex)

For documentation of this method, see java.sql.ResultSet#getURL(int).

Parameters

NameTypeDescription
columnIndexIntegerThe index of the column to retrieve the data from (the first column is 1, the second is 2, and so on).

Return

String — The URL value of the designated column in the current row of this result set.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getURL(columnLabel)

For documentation of this method, see java.sql.ResultSet#getURL(String).

Parameters

NameTypeDescription
columnLabelStringThe label for the column, specified with the SQL AS clause. If the AS clause wasn't specified, then the label is the name of the column.

Return

String — The URL value of the designated column in the current row of this result set.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

getWarnings()

Returns the current set of warnings reported by the driver.

Return

String[] — The current set of warnings.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

insertRow()

For documentation of this method, see java.sql.ResultSet#insertRow().

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

isAfterLast()

For documentation of this method, see java.sql.ResultSet#isAfterLast().

Return

Booleantrue if the cursor is after the last row; false if it is in any other position or if the result set contains no rows.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

isBeforeFirst()

For documentation of this method, see java.sql.ResultSet#isBeforeFirst().

Return

Booleantrue if the cursor is before the first row; false if it is in any other position or if the result set contains no rows.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

isClosed()

For documentation of this method, see java.sql.ResultSet#isClosed().

Return

Booleantrue if this result set is closed; false otherwise.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

isFirst()

For documentation of this method, see java.sql.ResultSet#isFirst().

Return

Booleantrue if the cursor is on the first row; false otherwise.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

isLast()

For documentation of this method, see java.sql.ResultSet#isLast().

Return

Booleantrue if the cursor is on the last row; false otherwise.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

last()

For documentation of this method, see java.sql.ResultSet#first().

Return

Booleantrue if the cursor is on a valid row; false if there are no rows in the result set.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

moveToCurrentRow()

For documentation of this method, see java.sql.ResultSet#moveToCurrentRow().

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

moveToInsertRow()

For documentation of this method, see java.sql.ResultSet#moveToInsertRow().

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

next()

For documentation of this method, see java.sql.ResultSet#next().

Return

Booleantrue if the new current row is valid; false otherwise.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

previous()

For documentation of this method, see java.sql.ResultSet#previous().

Return

Booleantrue if the cursor is on a valid row; false if the cursor is positioned before the first row.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

refreshRow()

For documentation of this method, see java.sql.ResultSet#refreshRow().

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

relative(rows)

For documentation of this method, see java.sql.ResultSet#relative(int).

Parameters

NameTypeDescription
rowsIntegerThe number row steps to move the cursor. A positive number moves the cursor forward, while a negative number moves the cursor backward.

Return

Booleantrue if the cursor is on a row; false otherwise.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

rowDeleted()

For documentation of this method, see java.sql.ResultSet#rowDeleted().

Return

Booleantrue if the current row was visibly deleted; false otherwise.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

rowInserted()

For documentation of this method, see java.sql.ResultSet#rowInserted().

Return

Booleantrue if the current row was visibly inserted; false otherwise.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

rowUpdated()

For documentation of this method, see java.sql.ResultSet#rowUpdated().

Return

Booleantrue if the current row was visibly updated; false otherwise.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

setFetchDirection(direction)

For documentation of this method, see java.sql.ResultSet#setFetchDirection(int).

Parameters

NameTypeDescription
directionIntegerThe specified direction to set, which is either Jdbc.ResultSet.FETCH_FORWARD or Jdbc.ResultSet.FETCH_REVERSE.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

setFetchSize(rows)

For documentation of this method, see java.sql.ResultSet#setFetchSize(int).

Parameters

NameTypeDescription
rowsIntegerThe number of rows to fetch.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

updateArray(columnIndex, x)

For documentation of this method, see java.sql.ResultSet#updateArray(int, Array).

Parameters

NameTypeDescription
columnIndexIntegerThe index of the column to update (the first column is 1, the second is 2, and so on).
xJdbcArrayThe new column value.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

updateArray(columnLabel, x)

For documentation of this method, see java.sql.ResultSet#updateArray(String, Array).

Parameters

NameTypeDescription
columnLabelStringThe label for the column, specified with the SQL AS clause. If the AS clause wasn't specified, then the label is the name of the column.
xJdbcArrayThe new column value.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

updateBigDecimal(columnIndex, x)

For documentation of this method, see java.sql.ResultSet#updateBigDecimal(int, BigDecimal).

Parameters

NameTypeDescription
columnIndexIntegerThe index of the column to update (the first column is 1, the second is 2, and so on).
xBigNumberThe new column value.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

updateBigDecimal(columnLabel, x)

For documentation of this method, see java.sql.ResultSet#updateBigDecimal(String, BigDecimal).

Parameters

NameTypeDescription
columnLabelStringThe label for the column, specified with the SQL AS clause. If the AS clause wasn't specified, then the label is the name of the column.
xBigNumberThe new column value.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

updateBlob(columnIndex, x)

For documentation of this method, see java.sql.ResultSet#updateBlob(int, Blob).

Parameters

NameTypeDescription
columnIndexIntegerThe index of the column to update (the first column is 1, the second is 2, and so on).
xJdbcBlobThe new column value.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

updateBlob(columnLabel, x)

For documentation of this method, see java.sql.ResultSet#updateRef(String, Blob).

Parameters

NameTypeDescription
columnLabelStringThe label for the column, specified with the SQL AS clause. If the AS clause wasn't specified, then the label is the name of the column.
xJdbcBlobThe new column value.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

updateBoolean(columnIndex, x)

For documentation of this method, see java.sql.ResultSet#updateBoolean(int, boolean).

Parameters

NameTypeDescription
columnIndexIntegerThe index of the column to update (the first column is 1, the second is 2, and so on).
xBooleanThe new column value.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

updateBoolean(columnLabel, x)

For documentation of this method, see java.sql.ResultSet#updateBoolean(String, boolean).

Parameters

NameTypeDescription
columnLabelStringThe label for the column, specified with the SQL AS clause. If the AS clause wasn't specified, then the label is the name of the column.
xBooleanThe new column value.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

updateByte(columnIndex, x)

For documentation of this method, see java.sql.ResultSet#updateByte(int, byte).

Parameters

NameTypeDescription
columnIndexIntegerThe index of the column to update (the first column is 1, the second is 2, and so on).
xByteThe new column value.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

updateByte(columnLabel, x)

For documentation of this method, see java.sql.ResultSet#updateByte(String, byte).

Parameters

NameTypeDescription
columnLabelStringThe label for the column, specified with the SQL AS clause. If the AS clause wasn't specified, then the label is the name of the column.
xByteThe new column value.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

updateBytes(columnIndex, x)

For documentation of this method, see java.sql.ResultSet#updateBytes(int, byte[]).

Parameters

NameTypeDescription
columnIndexIntegerThe index of the column to update (the first column is 1, the second is 2, and so on).
xByte[]The new column value.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

updateBytes(columnLabel, x)

For documentation of this method, see java.sql.ResultSet#updateBytes(String, byte[]).

Parameters

NameTypeDescription
columnLabelStringThe label for the column, specified with the SQL AS clause. If the AS clause wasn't specified, then the label is the name of the column.
xByte[]The new column value.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

updateClob(columnIndex, x)

For documentation of this method, see java.sql.ResultSet#updateClob(int, Clob).

Parameters

NameTypeDescription
columnIndexIntegerThe index of the column to update (the first column is 1, the second is 2, and so on).
xJdbcClobThe new column value.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

updateClob(columnLabel, x)

For documentation of this method, see java.sql.ResultSet#updateClob(String, Clob).

Parameters

NameTypeDescription
columnLabelStringThe label for the column, specified with the SQL AS clause. If the AS clause wasn't specified, then the label is the name of the column.
xJdbcClobThe new column value.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

updateDate(columnIndex, x)

For documentation of this method, see java.sql.ResultSet#updateDate(int, Date).

Parameters

NameTypeDescription
columnIndexIntegerThe index of the column to update (the first column is 1, the second is 2, and so on).
xJdbcDateThe new column value.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

updateDate(columnLabel, x)

For documentation of this method, see java.sql.ResultSet#updateDate(String, Date).

Parameters

NameTypeDescription
columnLabelStringThe label for the column, specified with the SQL AS clause. If the AS clause wasn't specified, then the label is the name of the column.
xJdbcDateThe new column value.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

updateDouble(columnIndex, x)

For documentation of this method, see java.sql.ResultSet#updateDouble(int, double).

Parameters

NameTypeDescription
columnIndexIntegerThe index of the column to update (the first column is 1, the second is 2, and so on).
xNumberThe new column value.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

updateDouble(columnLabel, x)

For documentation of this method, see java.sql.ResultSet#updateDouble(String, double).

Parameters

NameTypeDescription
columnLabelStringThe label for the column, specified with the SQL AS clause. If the AS clause wasn't specified, then the label is the name of the column.
xNumberThe new column value.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

updateFloat(columnIndex, x)

For documentation of this method, see java.sql.ResultSet#updateFloat(int, float).

Parameters

NameTypeDescription
columnIndexIntegerThe index of the column to update (the first column is 1, the second is 2, and so on).
xNumberThe new column value.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

updateFloat(columnLabel, x)

For documentation of this method, see java.sql.ResultSet#updateFloat(String, float).

Parameters

NameTypeDescription
columnLabelStringThe label for the column, specified with the SQL AS clause. If the AS clause wasn't specified, then the label is the name of the column.
xNumberThe new column value.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

updateInt(columnIndex, x)

For documentation of this method, see java.sql.ResultSet#updateInt(int, int).

Parameters

NameTypeDescription
columnIndexIntegerThe index of the column to update (the first column is 1, the second is 2, and so on).
xIntegerThe new column value.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

updateInt(columnLabel, x)

For documentation of this method, see java.sql.ResultSet#updateInt(String, int).

Parameters

NameTypeDescription
columnLabelStringThe label for the column, specified with the SQL AS clause. If the AS clause wasn't specified, then the label is the name of the column.
xIntegerThe new column value.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

updateLong(columnIndex, x)

For documentation of this method, see java.sql.ResultSet#updateLong(int, long).

Parameters

NameTypeDescription
columnIndexIntegerThe index of the column to update (the first column is 1, the second is 2, and so on).
xIntegerThe new column value.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

updateLong(columnLabel, x)

For documentation of this method, see java.sql.ResultSet#updateLong(String, long).

Parameters

NameTypeDescription
columnLabelStringThe label for the column, specified with the SQL AS clause. If the AS clause wasn't specified, then the label is the name of the column.
xIntegerThe new column value.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

updateNClob(columnIndex, x)

For documentation of this method, see java.sql.ResultSet#updateNClob(int, NClob).

Parameters

NameTypeDescription
columnIndexIntegerThe index of the column to update (the first column is 1, the second is 2, and so on).
xJdbcClobThe new column value.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

updateNClob(columnLabel, x)

For documentation of this method, see java.sql.ResultSet#updateNClob(String, NClob).

Parameters

NameTypeDescription
columnLabelStringThe label for the column, specified with the SQL AS clause. If the AS clause wasn't specified, then the label is the name of the column.
xJdbcClobThe new column value.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

updateNString(columnIndex, x)

For documentation of this method, see java.sql.ResultSet#updateNString(int, String).

Parameters

NameTypeDescription
columnIndexIntegerThe index of the column to update (the first column is 1, the second is 2, and so on).
xStringThe new column value.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

updateNString(columnLabel, x)

For documentation of this method, see java.sql.ResultSet#updateNString(String, String).

Parameters

NameTypeDescription
columnLabelStringThe label for the column, specified with the SQL AS clause. If the AS clause wasn't specified, then the label is the name of the column.
xStringThe new column value.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

updateNull(columnIndex)

For documentation of this method, see java.sql.ResultSet#updateNull(int).

Parameters

NameTypeDescription
columnIndexIntegerThe index of the column to update (the first column is 1, the second is 2, and so on).

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

updateNull(columnLabel)

For documentation of this method, see java.sql.ResultSet#updateNull(String).

Parameters

NameTypeDescription
columnLabelStringThe label for the column, specified with the SQL AS clause. If the AS clause wasn't specified, then the label is the name of the column.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

updateObject(columnIndex, x)

For documentation of this method, see java.sql.ResultSet#updateObject(int, Object).

Parameters

NameTypeDescription
columnIndexIntegerThe index of the column to update (the first column is 1, the second is 2, and so on).
xObjectThe new column value.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

updateObject(columnIndex, x, scaleOrLength)

For documentation of this method, see java.sql.ResultSet#updateObject(int, Object, int).

Parameters

NameTypeDescription
columnIndexIntegerThe index of the column to update (the first column is 1, the second is 2, and so on).
xObjectThe new column value.
scaleOrLengthIntegerThe number of digits after the decimal for BigDecimal types, or the length of data for InputStream or Reader types. Ignored for all other types.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

updateObject(columnLabel, x)

For documentation of this method, see java.sql.ResultSet#updateObject(String, Object).

Parameters

NameTypeDescription
columnLabelStringThe label for the column, specified with the SQL AS clause. If the AS clause wasn't specified, then the label is the name of the column.
xObjectThe new column value.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

updateObject(columnLabel, x, scaleOrLength)

For documentation of this method, see java.sql.ResultSet#updateObject(String, Object, int).

Parameters

NameTypeDescription
columnLabelStringThe label for the column, specified with the SQL AS clause. If the AS clause wasn't specified, then the label is the name of the column.
xObjectThe new column value.
scaleOrLengthIntegerThe number of digits after the decimal for BigDecimal types, or the length of data for InputStream or Reader types. Ignored for all other types.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

updateRef(columnIndex, x)

For documentation of this method, see java.sql.ResultSet#updateRef(int, Ref).

Parameters

NameTypeDescription
columnIndexIntegerThe index of the column to update (the first column is 1, the second is 2, and so on).
xJdbcRefThe new column value.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

updateRef(columnLabel, x)

For documentation of this method, see java.sql.ResultSet#updateRef(String, Ref).

Parameters

NameTypeDescription
columnLabelStringThe label for the column, specified with the SQL AS clause. If the AS clause wasn't specified, then the label is the name of the column.
xJdbcRefThe new column value.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

updateRow()

For documentation of this method, see java.sql.ResultSet#updateRow().

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

updateRowId(columnIndex, x)

For documentation of this method, see java.sql.ResultSet#updateRowId(int, RowId).

Parameters

NameTypeDescription
columnIndexIntegerThe index of the column to update (the first column is 1, the second is 2, and so on).
xJdbcRowIdThe new column value.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

updateRowId(columnLabel, x)

For documentation of this method, see java.sql.ResultSet#updateRowId(String, RowId).

Parameters

NameTypeDescription
columnLabelStringThe label for the column, specified with the SQL AS clause. If the AS clause wasn't specified, then the label is the name of the column.
xJdbcRowIdThe new column value.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

updateSQLXML(columnIndex, x)

For documentation of this method, see java.sql.ResultSet#updateSQLXML(int, SQLXML).

Parameters

NameTypeDescription
columnIndexIntegerThe index of the column to update (the first column is 1, the second is 2, and so on).
xJdbcSQLXMLThe new column value.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

updateSQLXML(columnLabel, x)

For documentation of this method, see java.sql.ResultSet#updateSQLXML(String, SQLXML).

Parameters

NameTypeDescription
columnLabelStringThe label for the column, specified with the SQL AS clause. If the AS clause wasn't specified, then the label is the name of the column.
xJdbcSQLXMLThe new column value.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

updateShort(columnIndex, x)

For documentation of this method, see java.sql.ResultSet#updateShort(int, short).

Parameters

NameTypeDescription
columnIndexIntegerThe index of the column to update (the first column is 1, the second is 2, and so on).
xIntegerThe new column value.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

updateShort(columnLabel, x)

For documentation of this method, see java.sql.ResultSet#updateShort(String, short).

Parameters

NameTypeDescription
columnLabelStringThe label for the column, specified with the SQL AS clause. If the AS clause wasn't specified, then the label is the name of the column.
xIntegerThe new column value.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

updateString(columnIndex, x)

For documentation of this method, see java.sql.ResultSet#updateString(int, String).

Parameters

NameTypeDescription
columnIndexIntegerThe index of the column to update (the first column is 1, the second is 2, and so on).
xStringThe new column value.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

updateString(columnLabel, x)

For documentation of this method, see java.sql.ResultSet#updateString(String, String).

Parameters

NameTypeDescription
columnLabelStringThe label for the column, specified with the SQL AS clause. If the AS clause wasn't specified, then the label is the name of the column.
xStringThe new column value.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

updateTime(columnIndex, x)

For documentation of this method, see java.sql.ResultSet#updateTime(int, Time).

Parameters

NameTypeDescription
columnIndexIntegerThe index of the column to update (the first column is 1, the second is 2, and so on).
xJdbcTimeThe new column value.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

updateTime(columnLabel, x)

For documentation of this method, see java.sql.ResultSet#updateTime(String, Time).

Parameters

NameTypeDescription
columnLabelStringThe label for the column, specified with the SQL AS clause. If the AS clause wasn't specified, then the label is the name of the column.
xJdbcTimeThe new column value.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

updateTimestamp(columnIndex, x)

For documentation of this method, see java.sql.ResultSet#updateTimestamp(int, Timestamp).

Parameters

NameTypeDescription
columnIndexIntegerThe index of the column to update (the first column is 1, the second is 2, and so on).
xJdbcTimestampThe new column value.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

updateTimestamp(columnLabel, x)

For documentation of this method, see java.sql.ResultSet#updateTimestamp(String, Timestamp).

Parameters

NameTypeDescription
columnLabelStringThe label for the column, specified with the SQL AS clause. If the AS clause wasn't specified, then the label is the name of the column.
xJdbcTimestampThe new column value.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request

wasNull()

For documentation of this method, see java.sql.ResultSet#wasNull().

Return

Booleantrue if the last column read was SQL NULL; false otherwise.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/script.external_request