Stay organized with collections Save and categorize content based on your preferences.
Methods Method Return type Brief descriptionabsolute(row) Boolean For documentation of this method, see java.sql.ResultSet#absolute(int). afterLast() void For documentation of this method, see java.sql.ResultSet#afterLast(). beforeFirst() void For documentation of this method, see java.sql.ResultSet#beforeFirst(). cancelRowUpdates() void For documentation of this method, see java.sql.ResultSet#cancelRowUpdates(). clearWarnings() void For documentation of this method, see java.sql.ResultSet#clearWarnings(). close() void For documentation of this method, see java.sql.ResultSet#close(). deleteRow() void For documentation of this method, see java.sql.ResultSet#deleteRow(). findColumn(columnLabel) Integer For documentation of this method, see java.sql.ResultSet#findColumn(String). first() Boolean For documentation of this method, see java.sql.ResultSet#first(). getArray(columnIndex) JdbcArray For documentation of this method, see java.sql.ResultSet#getArray(int). getArray(columnLabel) JdbcArray For documentation of this method, see java.sql.ResultSet#getArray(String). getBigDecimal(columnIndex) BigNumber For documentation of this method, see java.sql.ResultSet#getBigDecimal(int). getBigDecimal(columnLabel) BigNumber For documentation of this method, see java.sql.ResultSet#getBigDecimal(String). getBlob(columnIndex) JdbcBlob For documentation of this method, see java.sql.ResultSet#getBlob(int). getBlob(columnLabel) JdbcBlob For documentation of this method, see java.sql.ResultSet#getBlob(String). getBoolean(columnIndex) Boolean For documentation of this method, see java.sql.ResultSet#getBoolean(int). getBoolean(columnLabel) Boolean For documentation of this method, see java.sql.ResultSet#getBoolean(String). getByte(columnIndex) Byte For documentation of this method, see java.sql.ResultSet#getByte(int). getByte(columnLabel) Byte For 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) JdbcClob For documentation of this method, see java.sql.ResultSet#getClob(int). getClob(columnLabel) JdbcClob For documentation of this method, see java.sql.ResultSet#getClob(String). getConcurrency() Integer For documentation of this method, see java.sql.ResultSet#getConcurrency(). getCursorName() String For documentation of this method, see java.sql.ResultSet#getCursorName(). getDate(columnIndex) JdbcDate For documentation of this method, see java.sql.ResultSet#getDate(int). getDate(columnIndex, timeZone) JdbcDate For documentation of this method, see java.sql.ResultSet#getDate(int, Calendar). getDate(columnLabel) JdbcDate For documentation of this method, see java.sql.ResultSet#getDate(String). getDate(columnLabel, timeZone) JdbcDate For documentation of this method, see java.sql.ResultSet#getDate(String, Calendar). getDouble(columnIndex) Number For documentation of this method, see java.sql.ResultSet#getDouble(int). getDouble(columnLabel) Number For documentation of this method, see java.sql.ResultSet#getDouble(String). getFetchDirection() Integer For documentation of this method, see java.sql.ResultSet#getFetchDirection(). getFetchSize() Integer For documentation of this method, see java.sql.ResultSet#getFetchSize(). getFloat(columnIndex) Number For documentation of this method, see java.sql.ResultSet#getFloat(int). getFloat(columnLabel) Number For documentation of this method, see java.sql.ResultSet#getFloat(String). getHoldability() Integer For documentation of this method, see java.sql.ResultSet#getHoldability(). getInt(columnIndex) Integer For documentation of this method, see java.sql.ResultSet#getInt(int). getInt(columnLabel) Integer For documentation of this method, see java.sql.ResultSet#getInt(String). getLong(columnIndex) Integer For documentation of this method, see java.sql.ResultSet#getLong(int). getLong(columnLabel) Integer For documentation of this method, see java.sql.ResultSet#getLong(String). getMetaData() JdbcResultSetMetaData For documentation of this method, see java.sql.ResultSet#getMetaData(). getNClob(columnIndex) JdbcClob For documentation of this method, see java.sql.ResultSet#getNClob(int). getNClob(columnLabel) JdbcClob For documentation of this method, see java.sql.ResultSet#getNClob(String). getNString(columnIndex) String For documentation of this method, see java.sql.ResultSet#getNString(int). getNString(columnLabel) String For documentation of this method, see java.sql.ResultSet#getNString(String). getObject(columnIndex) Object For documentation of this method, see java.sql.ResultSet#getObject(int). getObject(columnLabel) Object For documentation of this method, see java.sql.ResultSet#getObject(String). getRef(columnIndex) JdbcRef For documentation of this method, see java.sql.ResultSet#getRef(int). getRef(columnLabel) JdbcRef For documentation of this method, see java.sql.ResultSet#getRef(String). getRow() Integer For documentation of this method, see java.sql.ResultSet#getRow(). getRowId(columnIndex) JdbcRowId For documentation of this method, see java.sql.ResultSet#getRowId(int). getRowId(columnLabel) JdbcRowId For documentation of this method, see java.sql.ResultSet#getRowId(String). getSQLXML(columnIndex) JdbcSQLXML For documentation of this method, see java.sql.ResultSet#getSQLXML(int). getSQLXML(columnLabel) JdbcSQLXML For documentation of this method, see java.sql.ResultSet#getSQLXML(String). getShort(columnIndex) Integer For documentation of this method, see java.sql.ResultSet#getShort(int). getShort(columnLabel) Integer For documentation of this method, see java.sql.ResultSet#getShort(String). getStatement() JdbcStatement For documentation of this method, see java.sql.ResultSet#getStatement(). getString(columnIndex) String For documentation of this method, see java.sql.ResultSet#getString(int). getString(columnLabel) String For documentation of this method, see java.sql.ResultSet#getString(String). getTime(columnIndex) JdbcTime For documentation of this method, see java.sql.ResultSet#getTime(int). getTime(columnIndex, timeZone) JdbcTime For documentation of this method, see java.sql.ResultSet#getTime(int, Calendar). getTime(columnLabel) JdbcTime For documentation of this method, see java.sql.ResultSet#getTime(String). getTime(columnLabel, timeZone) JdbcTime For documentation of this method, see java.sql.ResultSet#getTime(String, Calendar). getTimestamp(columnIndex) JdbcTimestamp For documentation of this method, see java.sql.ResultSet#getTimestamp(int). getTimestamp(columnIndex, timeZone) JdbcTimestamp For documentation of this method, see java.sql.ResultSet#getTimestamp(int, Calendar). getTimestamp(columnLabel) JdbcTimestamp For documentation of this method, see java.sql.ResultSet#getTimestamp(String). getTimestamp(columnLabel, timeZone) JdbcTimestamp For documentation of this method, see java.sql.ResultSet#getTimestamp(String, Calendar). getType() Integer For documentation of this method, see java.sql.ResultSet#getType(). getURL(columnIndex) String For documentation of this method, see java.sql.ResultSet#getURL(int). getURL(columnLabel) String For documentation of this method, see java.sql.ResultSet#getURL(String). getWarnings() String[] Returns the current set of warnings reported by the driver. insertRow() void For documentation of this method, see java.sql.ResultSet#insertRow(). isAfterLast() Boolean For documentation of this method, see java.sql.ResultSet#isAfterLast(). isBeforeFirst() Boolean For documentation of this method, see java.sql.ResultSet#isBeforeFirst(). isClosed() Boolean For documentation of this method, see java.sql.ResultSet#isClosed(). isFirst() Boolean For documentation of this method, see java.sql.ResultSet#isFirst(). isLast() Boolean For documentation of this method, see java.sql.ResultSet#isLast(). last() Boolean For documentation of this method, see java.sql.ResultSet#first(). moveToCurrentRow() void For documentation of this method, see java.sql.ResultSet#moveToCurrentRow(). moveToInsertRow() void For documentation of this method, see java.sql.ResultSet#moveToInsertRow(). next() Boolean For documentation of this method, see java.sql.ResultSet#next(). previous() Boolean For documentation of this method, see java.sql.ResultSet#previous(). refreshRow() void For documentation of this method, see java.sql.ResultSet#refreshRow(). relative(rows) Boolean For documentation of this method, see java.sql.ResultSet#relative(int). rowDeleted() Boolean For documentation of this method, see java.sql.ResultSet#rowDeleted(). rowInserted() Boolean For documentation of this method, see java.sql.ResultSet#rowInserted(). rowUpdated() Boolean For documentation of this method, see java.sql.ResultSet#rowUpdated(). setFetchDirection(direction) void For documentation of this method, see java.sql.ResultSet#setFetchDirection(int). setFetchSize(rows) void For documentation of this method, see java.sql.ResultSet#setFetchSize(int). updateArray(columnIndex, x) void For documentation of this method, see java.sql.ResultSet#updateArray(int, Array). updateArray(columnLabel, x) void For documentation of this method, see java.sql.ResultSet#updateArray(String, Array). updateBigDecimal(columnIndex, x) void For documentation of this method, see java.sql.ResultSet#updateBigDecimal(int, BigDecimal). updateBigDecimal(columnLabel, x) void For documentation of this method, see java.sql.ResultSet#updateBigDecimal(String, BigDecimal). updateBlob(columnIndex, x) void For documentation of this method, see java.sql.ResultSet#updateBlob(int, Blob). updateBlob(columnLabel, x) void For documentation of this method, see java.sql.ResultSet#updateRef(String, Blob). updateBoolean(columnIndex, x) void For documentation of this method, see java.sql.ResultSet#updateBoolean(int, boolean). updateBoolean(columnLabel, x) void For documentation of this method, see java.sql.ResultSet#updateBoolean(String, boolean). updateByte(columnIndex, x) void For documentation of this method, see java.sql.ResultSet#updateByte(int, byte). updateByte(columnLabel, x) void For documentation of this method, see java.sql.ResultSet#updateByte(String, byte). updateBytes(columnIndex, x) void For documentation of this method, see java.sql.ResultSet#updateBytes(int, byte[]). updateBytes(columnLabel, x) void For documentation of this method, see java.sql.ResultSet#updateBytes(String, byte[]). updateClob(columnIndex, x) void For documentation of this method, see java.sql.ResultSet#updateClob(int, Clob). updateClob(columnLabel, x) void For documentation of this method, see java.sql.ResultSet#updateClob(String, Clob). updateDate(columnIndex, x) void For documentation of this method, see java.sql.ResultSet#updateDate(int, Date). updateDate(columnLabel, x) void For documentation of this method, see java.sql.ResultSet#updateDate(String, Date). updateDouble(columnIndex, x) void For documentation of this method, see java.sql.ResultSet#updateDouble(int, double). updateDouble(columnLabel, x) void For documentation of this method, see java.sql.ResultSet#updateDouble(String, double). updateFloat(columnIndex, x) void For documentation of this method, see java.sql.ResultSet#updateFloat(int, float). updateFloat(columnLabel, x) void For documentation of this method, see java.sql.ResultSet#updateFloat(String, float). updateInt(columnIndex, x) void For documentation of this method, see java.sql.ResultSet#updateInt(int, int). updateInt(columnLabel, x) void For documentation of this method, see java.sql.ResultSet#updateInt(String, int). updateLong(columnIndex, x) void For documentation of this method, see java.sql.ResultSet#updateLong(int, long). updateLong(columnLabel, x) void For documentation of this method, see java.sql.ResultSet#updateLong(String, long). updateNClob(columnIndex, x) void For documentation of this method, see java.sql.ResultSet#updateNClob(int, NClob). updateNClob(columnLabel, x) void For documentation of this method, see java.sql.ResultSet#updateNClob(String, NClob). updateNString(columnIndex, x) void For documentation of this method, see java.sql.ResultSet#updateNString(int, String). updateNString(columnLabel, x) void For documentation of this method, see java.sql.ResultSet#updateNString(String, String). updateNull(columnIndex) void For documentation of this method, see java.sql.ResultSet#updateNull(int). updateNull(columnLabel) void For documentation of this method, see java.sql.ResultSet#updateNull(String). updateObject(columnIndex, x) void For documentation of this method, see java.sql.ResultSet#updateObject(int, Object). updateObject(columnIndex, x, scaleOrLength) void For documentation of this method, see java.sql.ResultSet#updateObject(int, Object, int). updateObject(columnLabel, x) void For documentation of this method, see java.sql.ResultSet#updateObject(String, Object). updateObject(columnLabel, x, scaleOrLength) void For documentation of this method, see java.sql.ResultSet#updateObject(String, Object, int). updateRef(columnIndex, x) void For documentation of this method, see java.sql.ResultSet#updateRef(int, Ref). updateRef(columnLabel, x) void For documentation of this method, see java.sql.ResultSet#updateRef(String, Ref). updateRow() void For documentation of this method, see java.sql.ResultSet#updateRow(). updateRowId(columnIndex, x) void For documentation of this method, see java.sql.ResultSet#updateRowId(int, RowId). updateRowId(columnLabel, x) void For documentation of this method, see java.sql.ResultSet#updateRowId(String, RowId). updateSQLXML(columnIndex, x) void For documentation of this method, see java.sql.ResultSet#updateSQLXML(int, SQLXML). updateSQLXML(columnLabel, x) void For documentation of this method, see java.sql.ResultSet#updateSQLXML(String, SQLXML). updateShort(columnIndex, x) void For documentation of this method, see java.sql.ResultSet#updateShort(int, short). updateShort(columnLabel, x) void For documentation of this method, see java.sql.ResultSet#updateShort(String, short). updateString(columnIndex, x) void For documentation of this method, see java.sql.ResultSet#updateString(int, String). updateString(columnLabel, x) void For documentation of this method, see java.sql.ResultSet#updateString(String, String). updateTime(columnIndex, x) void For documentation of this method, see java.sql.ResultSet#updateTime(int, Time). updateTime(columnLabel, x) void For documentation of this method, see java.sql.ResultSet#updateTime(String, Time). updateTimestamp(columnIndex, x) void For documentation of this method, see java.sql.ResultSet#updateTimestamp(int, Timestamp). updateTimestamp(columnLabel, x) void For documentation of this method, see java.sql.ResultSet#updateTimestamp(String, Timestamp). wasNull() Boolean For documentation of this method, see java.sql.ResultSet#wasNull(). Detailed documentation absolute(row)
For documentation of this method, see java.sql.ResultSet#absolute(int).
row Integer The 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
Boolean — true 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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestafterLast()
For documentation of this method, see java.sql.ResultSet#afterLast().
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestbeforeFirst()
For documentation of this method, see java.sql.ResultSet#beforeFirst().
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestcancelRowUpdates()
For documentation of this method, see java.sql.ResultSet#cancelRowUpdates().
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestclearWarnings()
For documentation of this method, see java.sql.ResultSet#clearWarnings().
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestdeleteRow()
For documentation of this method, see java.sql.ResultSet#deleteRow().
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestfindColumn(columnLabel)
For documentation of this method, see java.sql.ResultSet#findColumn(String).
columnLabel String The 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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestfirst()
For documentation of this method, see java.sql.ResultSet#first().
Boolean — true if the cursor is on a valid row; false if there are no rows in the result set.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetArray(columnIndex)
For documentation of this method, see java.sql.ResultSet#getArray(int).
columnIndex Integer The 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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetArray(columnLabel)
For documentation of this method, see java.sql.ResultSet#getArray(String).
columnLabel String The 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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetBigDecimal(columnIndex)
For documentation of this method, see java.sql.ResultSet#getBigDecimal(int).
columnIndex Integer The 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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetBigDecimal(columnLabel)
For documentation of this method, see java.sql.ResultSet#getBigDecimal(String).
columnLabel String The 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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetBlob(columnIndex)
For documentation of this method, see java.sql.ResultSet#getBlob(int).
columnIndex Integer The 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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetBlob(columnLabel)
For documentation of this method, see java.sql.ResultSet#getBlob(String).
columnLabel String The 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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetBoolean(columnIndex)
For documentation of this method, see java.sql.ResultSet#getBoolean(int).
columnIndex Integer The 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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetBoolean(columnLabel)
For documentation of this method, see java.sql.ResultSet#getBoolean(String).
columnLabel String The 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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetByte(columnIndex)
For documentation of this method, see java.sql.ResultSet#getByte(int).
columnIndex Integer The 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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetByte(columnLabel)
For documentation of this method, see java.sql.ResultSet#getByte(String).
columnLabel String The 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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetBytes(columnIndex)
For documentation of this method, see java.sql.ResultSet#getBytes(int).
columnIndex Integer The 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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetBytes(columnLabel)
For documentation of this method, see java.sql.ResultSet#getBytes(String).
columnLabel String The 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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetClob(columnIndex)
For documentation of this method, see java.sql.ResultSet#getClob(int).
columnIndex Integer The 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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetClob(columnLabel)
For documentation of this method, see java.sql.ResultSet#getClob(String).
columnLabel String The 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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetConcurrency()
For documentation of this method, see java.sql.ResultSet#getConcurrency().
Integer — The concurrency type, which is either Jdbc.ResultSet.CONCUR_READ_ONLY or Jdbc.ResultSet.CONCUR_UPDATABLE.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetCursorName()
For documentation of this method, see java.sql.ResultSet#getCursorName().
String — The SQL name for this result set's cursor.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetDate(columnIndex)
For documentation of this method, see java.sql.ResultSet#getDate(int).
columnIndex Integer The 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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetDate(columnIndex, timeZone)
For documentation of this method, see java.sql.ResultSet#getDate(int, Calendar).
columnIndex Integer The index of the column to retrieve (the first column is 1, the second is 2, and so on). timeZone String A 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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetDate(columnLabel)
For documentation of this method, see java.sql.ResultSet#getDate(String).
columnLabel String The 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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetDate(columnLabel, timeZone)
For documentation of this method, see java.sql.ResultSet#getDate(String, Calendar).
columnLabel String The 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. timeZone String A 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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetDouble(columnIndex)
For documentation of this method, see java.sql.ResultSet#getDouble(int).
columnIndex Integer The 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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetDouble(columnLabel)
For documentation of this method, see java.sql.ResultSet#getDouble(String).
columnLabel String The 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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetFetchDirection()
For documentation of this method, see java.sql.ResultSet#getFetchDirection().
Integer — The specified direction to set, which is either Jdbc.ResultSet.FETCH_FORWARD or Jdbc.ResultSet.FETCH_REVERSE.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetFetchSize()
For documentation of this method, see java.sql.ResultSet#getFetchSize().
Integer — The current fetch size for this result set.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetFloat(columnIndex)
For documentation of this method, see java.sql.ResultSet#getFloat(int).
columnIndex Integer The 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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetFloat(columnLabel)
For documentation of this method, see java.sql.ResultSet#getFloat(String).
columnLabel String The 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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetHoldability()
For documentation of this method, see java.sql.ResultSet#getHoldability().
Integer — The holdability of this result set, which is either Jdbc.ResultSet.HOLD_CURSORS_OVER_COMMIT or Jdbc.ResultSet.CLOSE_CURSORS_AT_COMMIT.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetInt(columnIndex)
For documentation of this method, see java.sql.ResultSet#getInt(int).
columnIndex Integer The 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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetInt(columnLabel)
For documentation of this method, see java.sql.ResultSet#getInt(String).
columnLabel String The 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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetLong(columnIndex)
For documentation of this method, see java.sql.ResultSet#getLong(int).
columnIndex Integer The 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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetLong(columnLabel)
For documentation of this method, see java.sql.ResultSet#getLong(String).
columnLabel String The 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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetNClob(columnIndex)
For documentation of this method, see java.sql.ResultSet#getNClob(int).
columnIndex Integer The 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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetNClob(columnLabel)
For documentation of this method, see java.sql.ResultSet#getNClob(String).
columnLabel String The 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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetNString(columnIndex)
For documentation of this method, see java.sql.ResultSet#getNString(int).
columnIndex Integer The 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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetNString(columnLabel)
For documentation of this method, see java.sql.ResultSet#getNString(String).
columnLabel String The 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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetObject(columnIndex)
For documentation of this method, see java.sql.ResultSet#getObject(int).
columnIndex Integer The 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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetObject(columnLabel)
For documentation of this method, see java.sql.ResultSet#getObject(String).
columnLabel String The 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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetRef(columnIndex)
For documentation of this method, see java.sql.ResultSet#getRef(int).
columnIndex Integer The 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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetRef(columnLabel)
For documentation of this method, see java.sql.ResultSet#getRef(String).
columnLabel String The 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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetRow()
For documentation of this method, see java.sql.ResultSet#getRow().
Integer — The current row number, or 0 if there is no current row.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetRowId(columnIndex)
For documentation of this method, see java.sql.ResultSet#getRowId(int).
columnIndex Integer The 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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetRowId(columnLabel)
For documentation of this method, see java.sql.ResultSet#getRowId(String).
columnLabel String The 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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetSQLXML(columnIndex)
For documentation of this method, see java.sql.ResultSet#getSQLXML(int).
columnIndex Integer The 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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetSQLXML(columnLabel)
For documentation of this method, see java.sql.ResultSet#getSQLXML(String).
columnLabel String The 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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetShort(columnIndex)
For documentation of this method, see java.sql.ResultSet#getShort(int).
columnIndex Integer The 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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetShort(columnLabel)
For documentation of this method, see java.sql.ResultSet#getShort(String).
columnLabel String The 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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetStatement()
For documentation of this method, see java.sql.ResultSet#getStatement().
JdbcStatement — The statement that produced this result set, or null if the result set was produced some other way.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetString(columnIndex)
For documentation of this method, see java.sql.ResultSet#getString(int).
columnIndex Integer The 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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetString(columnLabel)
For documentation of this method, see java.sql.ResultSet#getString(String).
columnLabel String The 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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetTime(columnIndex)
For documentation of this method, see java.sql.ResultSet#getTime(int).
columnIndex Integer The 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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetTime(columnIndex, timeZone)
For documentation of this method, see java.sql.ResultSet#getTime(int, Calendar).
columnIndex Integer The index of the column to retrieve (the first column is 1, the second is 2, and so on). timeZone String A 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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetTime(columnLabel)
For documentation of this method, see java.sql.ResultSet#getTime(String).
columnLabel String The 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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetTime(columnLabel, timeZone)
For documentation of this method, see java.sql.ResultSet#getTime(String, Calendar).
columnLabel String The 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. timeZone String A 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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetTimestamp(columnIndex)
For documentation of this method, see java.sql.ResultSet#getTimestamp(int).
columnIndex Integer The 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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetTimestamp(columnIndex, timeZone)
For documentation of this method, see java.sql.ResultSet#getTimestamp(int, Calendar).
columnIndex Integer The index of the column to retrieve (the first column is 1, the second is 2, and so on). timeZone String A 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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetTimestamp(columnLabel)
For documentation of this method, see java.sql.ResultSet#getTimestamp(String).
columnLabel String The 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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetTimestamp(columnLabel, timeZone)
For documentation of this method, see java.sql.ResultSet#getTimestamp(String, Calendar).
columnLabel String The 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. timeZone String A 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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetType()
For documentation of this method, see java.sql.ResultSet#getType().
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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetURL(columnIndex)
For documentation of this method, see java.sql.ResultSet#getURL(int).
columnIndex Integer The 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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetURL(columnLabel)
For documentation of this method, see java.sql.ResultSet#getURL(String).
columnLabel String The 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.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestgetWarnings()
Returns the current set of warnings reported by the driver.
ReturnString[] — The current set of warnings.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestinsertRow()
For documentation of this method, see java.sql.ResultSet#insertRow().
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestisAfterLast()
For documentation of this method, see java.sql.ResultSet#isAfterLast().
Boolean — true if the cursor is after the last row; false if it is in any other position or if the result set contains no rows.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestisBeforeFirst()
For documentation of this method, see java.sql.ResultSet#isBeforeFirst().
Boolean — true if the cursor is before the first row; false if it is in any other position or if the result set contains no rows.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestisClosed()
For documentation of this method, see java.sql.ResultSet#isClosed().
Boolean — true if this result set is closed; false otherwise.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestisFirst()
For documentation of this method, see java.sql.ResultSet#isFirst().
Boolean — true if the cursor is on the first row; false otherwise.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestisLast()
For documentation of this method, see java.sql.ResultSet#isLast().
Boolean — true if the cursor is on the last row; false otherwise.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestlast()
For documentation of this method, see java.sql.ResultSet#first().
Boolean — true if the cursor is on a valid row; false if there are no rows in the result set.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestmoveToCurrentRow()
For documentation of this method, see java.sql.ResultSet#moveToCurrentRow().
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestmoveToInsertRow()
For documentation of this method, see java.sql.ResultSet#moveToInsertRow().
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestnext()
For documentation of this method, see java.sql.ResultSet#next().
Boolean — true if the new current row is valid; false otherwise.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestprevious()
For documentation of this method, see java.sql.ResultSet#previous().
Boolean — true if the cursor is on a valid row; false if the cursor is positioned before the first row.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestrefreshRow()
For documentation of this method, see java.sql.ResultSet#refreshRow().
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestrelative(rows)
For documentation of this method, see java.sql.ResultSet#relative(int).
rows Integer The number row steps to move the cursor. A positive number moves the cursor forward, while a negative number moves the cursor backward. Return
Boolean — true if the cursor is on a row; false otherwise.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestrowDeleted()
For documentation of this method, see java.sql.ResultSet#rowDeleted().
Boolean — true if the current row was visibly deleted; false otherwise.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestrowInserted()
For documentation of this method, see java.sql.ResultSet#rowInserted().
Boolean — true if the current row was visibly inserted; false otherwise.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestrowUpdated()
For documentation of this method, see java.sql.ResultSet#rowUpdated().
Boolean — true if the current row was visibly updated; false otherwise.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestsetFetchDirection(direction)
For documentation of this method, see java.sql.ResultSet#setFetchDirection(int).
direction 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_requestsetFetchSize(rows)
For documentation of this method, see java.sql.ResultSet#setFetchSize(int).
rows Integer The 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_requestupdateArray(columnIndex, x)
For documentation of this method, see java.sql.ResultSet#updateArray(int, Array).
columnIndex Integer The index of the column to update (the first column is 1, the second is 2, and so on). x JdbcArray 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_requestupdateArray(columnLabel, x)
For documentation of this method, see java.sql.ResultSet#updateArray(String, Array).
columnLabel String The 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. x JdbcArray 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_requestupdateBigDecimal(columnIndex, x)
For documentation of this method, see java.sql.ResultSet#updateBigDecimal(int, BigDecimal).
columnIndex Integer The index of the column to update (the first column is 1, the second is 2, and so on). x BigNumber 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_requestupdateBigDecimal(columnLabel, x)
For documentation of this method, see java.sql.ResultSet#updateBigDecimal(String, BigDecimal).
columnLabel String The 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. x BigNumber 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_requestupdateBlob(columnIndex, x)
For documentation of this method, see java.sql.ResultSet#updateBlob(int, Blob).
columnIndex Integer The index of the column to update (the first column is 1, the second is 2, and so on). x JdbcBlob 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_requestupdateBlob(columnLabel, x)
For documentation of this method, see java.sql.ResultSet#updateRef(String, Blob).
columnLabel String The 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. x JdbcBlob 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_requestupdateBoolean(columnIndex, x)
For documentation of this method, see java.sql.ResultSet#updateBoolean(int, boolean).
columnIndex Integer The index of the column to update (the first column is 1, the second is 2, and so on). x Boolean 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_requestupdateBoolean(columnLabel, x)
For documentation of this method, see java.sql.ResultSet#updateBoolean(String, boolean).
columnLabel String The 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. x Boolean 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_requestupdateByte(columnIndex, x)
For documentation of this method, see java.sql.ResultSet#updateByte(int, byte).
columnIndex Integer The index of the column to update (the first column is 1, the second is 2, and so on). x Byte 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_requestupdateByte(columnLabel, x)
For documentation of this method, see java.sql.ResultSet#updateByte(String, byte).
columnLabel String The 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. x Byte 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_requestupdateBytes(columnIndex, x)
For documentation of this method, see java.sql.ResultSet#updateBytes(int, byte[]).
columnIndex Integer The index of the column to update (the first column is 1, the second is 2, and so on). x Byte[] 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_requestupdateBytes(columnLabel, x)
For documentation of this method, see java.sql.ResultSet#updateBytes(String, byte[]).
columnLabel String The 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. x Byte[] 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_requestupdateClob(columnIndex, x)
For documentation of this method, see java.sql.ResultSet#updateClob(int, Clob).
columnIndex Integer The index of the column to update (the first column is 1, the second is 2, and so on). x JdbcClob 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_requestupdateClob(columnLabel, x)
For documentation of this method, see java.sql.ResultSet#updateClob(String, Clob).
columnLabel String The 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. x JdbcClob 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_requestupdateDate(columnIndex, x)
For documentation of this method, see java.sql.ResultSet#updateDate(int, Date).
columnIndex Integer The index of the column to update (the first column is 1, the second is 2, and so on). x JdbcDate 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_requestupdateDate(columnLabel, x)
For documentation of this method, see java.sql.ResultSet#updateDate(String, Date).
columnLabel String The 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. x JdbcDate 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_requestupdateDouble(columnIndex, x)
For documentation of this method, see java.sql.ResultSet#updateDouble(int, double).
columnIndex Integer The index of the column to update (the first column is 1, the second is 2, and so on). x Number 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_requestupdateDouble(columnLabel, x)
For documentation of this method, see java.sql.ResultSet#updateDouble(String, double).
columnLabel String The 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. x Number 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_requestupdateFloat(columnIndex, x)
For documentation of this method, see java.sql.ResultSet#updateFloat(int, float).
columnIndex Integer The index of the column to update (the first column is 1, the second is 2, and so on). x Number 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_requestupdateFloat(columnLabel, x)
For documentation of this method, see java.sql.ResultSet#updateFloat(String, float).
columnLabel String The 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. x Number 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_requestupdateInt(columnIndex, x)
For documentation of this method, see java.sql.ResultSet#updateInt(int, int).
columnIndex Integer The index of the column to update (the first column is 1, the second is 2, and so on). x Integer 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_requestupdateInt(columnLabel, x)
For documentation of this method, see java.sql.ResultSet#updateInt(String, int).
columnLabel String The 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. x Integer 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_requestupdateLong(columnIndex, x)
For documentation of this method, see java.sql.ResultSet#updateLong(int, long).
columnIndex Integer The index of the column to update (the first column is 1, the second is 2, and so on). x Integer 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_requestupdateLong(columnLabel, x)
For documentation of this method, see java.sql.ResultSet#updateLong(String, long).
columnLabel String The 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. x Integer 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_requestupdateNClob(columnIndex, x)
For documentation of this method, see java.sql.ResultSet#updateNClob(int, NClob).
columnIndex Integer The index of the column to update (the first column is 1, the second is 2, and so on). x JdbcClob 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_requestupdateNClob(columnLabel, x)
For documentation of this method, see java.sql.ResultSet#updateNClob(String, NClob).
columnLabel String The 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. x JdbcClob 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_requestupdateNString(columnIndex, x)
For documentation of this method, see java.sql.ResultSet#updateNString(int, String).
columnIndex Integer The index of the column to update (the first column is 1, the second is 2, and so on). x String 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_requestupdateNString(columnLabel, x)
For documentation of this method, see java.sql.ResultSet#updateNString(String, String).
columnLabel String The 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. x String 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_requestupdateNull(columnIndex)
For documentation of this method, see java.sql.ResultSet#updateNull(int).
columnIndex Integer The 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_requestupdateNull(columnLabel)
For documentation of this method, see java.sql.ResultSet#updateNull(String).
columnLabel String The 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_requestupdateObject(columnIndex, x)
For documentation of this method, see java.sql.ResultSet#updateObject(int, Object).
columnIndex Integer The index of the column to update (the first column is 1, the second is 2, and so on). x Object 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_requestupdateObject(columnIndex, x, scaleOrLength)
For documentation of this method, see java.sql.ResultSet#updateObject(int, Object, int).
columnIndex Integer The index of the column to update (the first column is 1, the second is 2, and so on). x Object The new column value. scaleOrLength Integer The 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_requestupdateObject(columnLabel, x)
For documentation of this method, see java.sql.ResultSet#updateObject(String, Object).
columnLabel String The 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. x Object 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_requestupdateObject(columnLabel, x, scaleOrLength)
For documentation of this method, see java.sql.ResultSet#updateObject(String, Object, int).
columnLabel String The 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. x Object The new column value. scaleOrLength Integer The 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_requestupdateRef(columnIndex, x)
For documentation of this method, see java.sql.ResultSet#updateRef(int, Ref).
columnIndex Integer The index of the column to update (the first column is 1, the second is 2, and so on). x JdbcRef 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_requestupdateRef(columnLabel, x)
For documentation of this method, see java.sql.ResultSet#updateRef(String, Ref).
columnLabel String The 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. x JdbcRef 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_requestupdateRow()
For documentation of this method, see java.sql.ResultSet#updateRow().
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestupdateRowId(columnIndex, x)
For documentation of this method, see java.sql.ResultSet#updateRowId(int, RowId).
columnIndex Integer The index of the column to update (the first column is 1, the second is 2, and so on). x JdbcRowId 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_requestupdateRowId(columnLabel, x)
For documentation of this method, see java.sql.ResultSet#updateRowId(String, RowId).
columnLabel String The 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. x JdbcRowId 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_requestupdateSQLXML(columnIndex, x)
For documentation of this method, see java.sql.ResultSet#updateSQLXML(int, SQLXML).
columnIndex Integer The index of the column to update (the first column is 1, the second is 2, and so on). x JdbcSQLXML 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_requestupdateSQLXML(columnLabel, x)
For documentation of this method, see java.sql.ResultSet#updateSQLXML(String, SQLXML).
columnLabel String The 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. x JdbcSQLXML 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_requestupdateShort(columnIndex, x)
For documentation of this method, see java.sql.ResultSet#updateShort(int, short).
columnIndex Integer The index of the column to update (the first column is 1, the second is 2, and so on). x Integer 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_requestupdateShort(columnLabel, x)
For documentation of this method, see java.sql.ResultSet#updateShort(String, short).
columnLabel String The 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. x Integer 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_requestupdateString(columnIndex, x)
For documentation of this method, see java.sql.ResultSet#updateString(int, String).
columnIndex Integer The index of the column to update (the first column is 1, the second is 2, and so on). x String 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_requestupdateString(columnLabel, x)
For documentation of this method, see java.sql.ResultSet#updateString(String, String).
columnLabel String The 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. x String 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_requestupdateTime(columnIndex, x)
For documentation of this method, see java.sql.ResultSet#updateTime(int, Time).
columnIndex Integer The index of the column to update (the first column is 1, the second is 2, and so on). x JdbcTime 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_requestupdateTime(columnLabel, x)
For documentation of this method, see java.sql.ResultSet#updateTime(String, Time).
columnLabel String The 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. x JdbcTime 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_requestupdateTimestamp(columnIndex, x)
For documentation of this method, see java.sql.ResultSet#updateTimestamp(int, Timestamp).
columnIndex Integer The index of the column to update (the first column is 1, the second is 2, and so on). x JdbcTimestamp 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_requestupdateTimestamp(columnLabel, x)
For documentation of this method, see java.sql.ResultSet#updateTimestamp(String, Timestamp).
columnLabel String The 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. x JdbcTimestamp 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_requestwasNull()
For documentation of this method, see java.sql.ResultSet#wasNull().
Boolean — true if the last column read was SQL NULL; false otherwise.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/script.external_requestExcept as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2024-12-05 UTC.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Missing the information I need","missingTheInformationINeed","thumb-down"],["Too complicated / too many steps","tooComplicatedTooManySteps","thumb-down"],["Out of date","outOfDate","thumb-down"],["Samples / code issue","samplesCodeIssue","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2024-12-05 UTC."],[[["`JdbcResultSet` provides methods to navigate, retrieve, and update data within a SQL result set in Google Apps Script."],["Most methods mirror their Java counterparts in `java.sql.ResultSet`, with links to official documentation for detailed behavior."],["Methods often use JDBC-specific types (e.g., `JdbcArray`, `JdbcBlob`) and require the `https://www.googleapis.com/auth/script.external_request` authorization scope."],["The class enables interaction with SQL data, offering functionalities like cursor navigation, data retrieval, and result set management within Apps Script."],["`updateXXX()` methods allow modification of result set data, targeting specific data types with options for using column index or label."]]],[]]
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4