A JDBC Result
. For documentation of this class, see java.sql.ResultSet
.
Methods
Detailed documentation
absolute(row)
For documentation of this method, see
java.sql.ResultSet#absolute(int)
.
Parameters
Name | Type | Description |
---|---|---|
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.
Authorization
Scripts that use this method require authorization with one or more of the following scopes:
-
https://www.googleapis.com/auth/script.external_request
after Last()
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
before First()
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
cancel Row Updates()
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
clear Warnings()
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()
.
delete Row()
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
find Column(columnLabel)
For documentation of this method, see
java.sql.ResultSet#findColumn(String)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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.
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
Boolean
— true
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
get Array(columnIndex)
For documentation of this method, see
java.sql.ResultSet#getArray(int)
.
Parameters
Name | Type | Description |
---|---|---|
column | Integer | The index of the column to retrieve the data from (the first column is 1, the second is 2, and so on). |
Return
Jdbc
— 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
get Array(columnLabel)
For documentation of this method, see
java.sql.ResultSet#getArray(String)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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
Jdbc
— 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
get Big Decimal(columnIndex)
For documentation of this method, see
java.sql.ResultSet#getBigDecimal(int)
.
Parameters
Name | Type | Description |
---|---|---|
column | Integer | The index of the column to retrieve the data from (the first column is 1, the second is 2, and so on). |
Return
Big
— 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
get Big Decimal(columnLabel)
For documentation of this method, see
java.sql.ResultSet#getBigDecimal(String)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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
Big
— 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
get Blob(columnIndex)
For documentation of this method, see
java.sql.ResultSet#getBlob(int)
.
Parameters
Name | Type | Description |
---|---|---|
column | Integer | The index of the column to retrieve the data from (the first column is 1, the second is 2, and so on). |
Return
Jdbc
— 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
get Blob(columnLabel)
For documentation of this method, see
java.sql.ResultSet#getBlob(String)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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
Jdbc
— 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
get Boolean(columnIndex)
For documentation of this method, see
java.sql.ResultSet#getBoolean(int)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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
.
Authorization
Scripts that use this method require authorization with one or more of the following scopes:
-
https://www.googleapis.com/auth/script.external_request
get Boolean(columnLabel)
For documentation of this method, see
java.sql.ResultSet#getBoolean(String)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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
.
Authorization
Scripts that use this method require authorization with one or more of the following scopes:
-
https://www.googleapis.com/auth/script.external_request
get Byte(columnIndex)
For documentation of this method, see
java.sql.ResultSet#getByte(int)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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
.
Authorization
Scripts that use this method require authorization with one or more of the following scopes:
-
https://www.googleapis.com/auth/script.external_request
get Byte(columnLabel)
For documentation of this method, see
java.sql.ResultSet#getByte(String)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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
.
Authorization
Scripts that use this method require authorization with one or more of the following scopes:
-
https://www.googleapis.com/auth/script.external_request
get Bytes(columnIndex)
For documentation of this method, see
java.sql.ResultSet#getBytes(int)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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
.
Authorization
Scripts that use this method require authorization with one or more of the following scopes:
-
https://www.googleapis.com/auth/script.external_request
get Bytes(columnLabel)
For documentation of this method, see
java.sql.ResultSet#getBytes(String)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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
.
Authorization
Scripts that use this method require authorization with one or more of the following scopes:
-
https://www.googleapis.com/auth/script.external_request
get Clob(columnIndex)
For documentation of this method, see
java.sql.ResultSet#getClob(int)
.
Parameters
Name | Type | Description |
---|---|---|
column | Integer | The index of the column to retrieve the data from (the first column is 1, the second is 2, and so on). |
Return
Jdbc
— 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
get Clob(columnLabel)
For documentation of this method, see
java.sql.ResultSet#getClob(String)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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
Jdbc
— 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
get Concurrency()
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
get Cursor Name()
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
get Date(columnIndex)
For documentation of this method, see
java.sql.ResultSet#getDate(int)
.
Parameters
Name | Type | Description |
---|---|---|
column | Integer | The index of the column to retrieve (the first column is 1, the second is 2, and so on). |
Return
Jdbc
— 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
get Date(columnIndex, timeZone)
For documentation of this method, see
java.sql.ResultSet#getDate(int, Calendar)
.
Parameters
Name | Type | Description |
---|---|---|
column | Integer | The index of the column to retrieve (the first column is 1, the second is 2, and so on). |
time | 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
Jdbc
— 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
get Date(columnLabel)
For documentation of this method, see
java.sql.ResultSet#getDate(String)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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
Jdbc
— 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
get Date(columnLabel, timeZone)
For documentation of this method, see
java.sql.ResultSet#getDate(String, Calendar)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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. |
time | 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
Jdbc
— 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
get Double(columnIndex)
For documentation of this method, see
java.sql.ResultSet#getDouble(int)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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
.
Authorization
Scripts that use this method require authorization with one or more of the following scopes:
-
https://www.googleapis.com/auth/script.external_request
get Double(columnLabel)
For documentation of this method, see
java.sql.ResultSet#getDouble(String)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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
.
Authorization
Scripts that use this method require authorization with one or more of the following scopes:
-
https://www.googleapis.com/auth/script.external_request
get Fetch Direction()
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
get Fetch Size()
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
get Float(columnIndex)
For documentation of this method, see
java.sql.ResultSet#getFloat(int)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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
.
Authorization
Scripts that use this method require authorization with one or more of the following scopes:
-
https://www.googleapis.com/auth/script.external_request
get Float(columnLabel)
For documentation of this method, see
java.sql.ResultSet#getFloat(String)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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
.
Authorization
Scripts that use this method require authorization with one or more of the following scopes:
-
https://www.googleapis.com/auth/script.external_request
get Holdability()
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
get Int(columnIndex)
For documentation of this method, see
java.sql.ResultSet#getInt(int)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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
.
Authorization
Scripts that use this method require authorization with one or more of the following scopes:
-
https://www.googleapis.com/auth/script.external_request
get Int(columnLabel)
For documentation of this method, see
java.sql.ResultSet#getInt(String)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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
.
Authorization
Scripts that use this method require authorization with one or more of the following scopes:
-
https://www.googleapis.com/auth/script.external_request
get Long(columnIndex)
For documentation of this method, see
java.sql.ResultSet#getLong(int)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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
.
Authorization
Scripts that use this method require authorization with one or more of the following scopes:
-
https://www.googleapis.com/auth/script.external_request
get Long(columnLabel)
For documentation of this method, see
java.sql.ResultSet#getLong(String)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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
.
Authorization
Scripts that use this method require authorization with one or more of the following scopes:
-
https://www.googleapis.com/auth/script.external_request
get Meta Data()
For documentation of this method, see
java.sql.ResultSet#getMetaData()
.
Return
Jdbc
— 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
get NClob(columnIndex)
For documentation of this method, see
java.sql.ResultSet#getNClob(int)
.
Parameters
Name | Type | Description |
---|---|---|
column | Integer | The index of the column to retrieve the data from (the first column is 1, the second is 2, and so on). |
Return
Jdbc
— 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
get NClob(columnLabel)
For documentation of this method, see
java.sql.ResultSet#getNClob(String)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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
Jdbc
— 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
get NString(columnIndex)
For documentation of this method, see
java.sql.ResultSet#getNString(int)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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
.
Authorization
Scripts that use this method require authorization with one or more of the following scopes:
-
https://www.googleapis.com/auth/script.external_request
get NString(columnLabel)
For documentation of this method, see
java.sql.ResultSet#getNString(String)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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
.
Authorization
Scripts that use this method require authorization with one or more of the following scopes:
-
https://www.googleapis.com/auth/script.external_request
get Object(columnIndex)
For documentation of this method, see
java.sql.ResultSet#getObject(int)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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.
Authorization
Scripts that use this method require authorization with one or more of the following scopes:
-
https://www.googleapis.com/auth/script.external_request
get Object(columnLabel)
For documentation of this method, see
java.sql.ResultSet#getObject(String)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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.
Authorization
Scripts that use this method require authorization with one or more of the following scopes:
-
https://www.googleapis.com/auth/script.external_request
get Ref(columnIndex)
For documentation of this method, see
java.sql.ResultSet#getRef(int)
.
Parameters
Name | Type | Description |
---|---|---|
column | Integer | The index of the column to retrieve the data from (the first column is 1, the second is 2, and so on). |
Return
Jdbc
— 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
get Ref(columnLabel)
For documentation of this method, see
java.sql.ResultSet#getRef(String)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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
Jdbc
— 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
get Row()
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
get Row Id(columnIndex)
For documentation of this method, see
java.sql.ResultSet#getRowId(int)
.
Parameters
Name | Type | Description |
---|---|---|
column | Integer | The index of the column to retrieve the data from (the first column is 1, the second is 2, and so on). |
Return
Jdbc
— 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
get Row Id(columnLabel)
For documentation of this method, see
java.sql.ResultSet#getRowId(String)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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
Jdbc
— 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
get SQLXML(columnIndex)
For documentation of this method, see
java.sql.ResultSet#getSQLXML(int)
.
Parameters
Name | Type | Description |
---|---|---|
column | Integer | The index of the column to retrieve the data from (the first column is 1, the second is 2, and so on). |
Return
Jdbc
— 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
get SQLXML(columnLabel)
For documentation of this method, see
java.sql.ResultSet#getSQLXML(String)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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
Jdbc
— 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
get Short(columnIndex)
For documentation of this method, see
java.sql.ResultSet#getShort(int)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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
.
Authorization
Scripts that use this method require authorization with one or more of the following scopes:
-
https://www.googleapis.com/auth/script.external_request
get Short(columnLabel)
For documentation of this method, see
java.sql.ResultSet#getShort(String)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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
.
Authorization
Scripts that use this method require authorization with one or more of the following scopes:
-
https://www.googleapis.com/auth/script.external_request
get Statement()
For documentation of this method, see
java.sql.ResultSet#getStatement()
.
Return
Jdbc
— 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
get String(columnIndex)
For documentation of this method, see
java.sql.ResultSet#getString(int)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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
.
Authorization
Scripts that use this method require authorization with one or more of the following scopes:
-
https://www.googleapis.com/auth/script.external_request
get String(columnLabel)
For documentation of this method, see
java.sql.ResultSet#getString(String)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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
.
Authorization
Scripts that use this method require authorization with one or more of the following scopes:
-
https://www.googleapis.com/auth/script.external_request
get Time(columnIndex)
For documentation of this method, see
java.sql.ResultSet#getTime(int)
.
Parameters
Name | Type | Description |
---|---|---|
column | Integer | The index of the column to retrieve (the first column is 1, the second is 2, and so on). |
Return
Jdbc
— 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
get Time(columnIndex, timeZone)
For documentation of this method, see
java.sql.ResultSet#getTime(int, Calendar)
.
Parameters
Name | Type | Description |
---|---|---|
column | Integer | The index of the column to retrieve (the first column is 1, the second is 2, and so on). |
time | 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
Jdbc
— 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
get Time(columnLabel)
For documentation of this method, see
java.sql.ResultSet#getTime(String)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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
Jdbc
— 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
get Time(columnLabel, timeZone)
For documentation of this method, see
java.sql.ResultSet#getTime(String, Calendar)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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. |
time | 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
Jdbc
— 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
get Timestamp(columnIndex)
For documentation of this method, see
java.sql.ResultSet#getTimestamp(int)
.
Parameters
Name | Type | Description |
---|---|---|
column | Integer | The index of the column to retrieve (the first column is 1, the second is 2, and so on). |
Return
Jdbc
— 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
get Timestamp(columnIndex, timeZone)
For documentation of this method, see
java.sql.ResultSet#getTimestamp(int, Calendar)
.
Parameters
Name | Type | Description |
---|---|---|
column | Integer | The index of the column to retrieve (the first column is 1, the second is 2, and so on). |
time | 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
Jdbc
— 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
get Timestamp(columnLabel)
For documentation of this method, see
java.sql.ResultSet#getTimestamp(String)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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
Jdbc
— 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
get Timestamp(columnLabel, timeZone)
For documentation of this method, see
java.sql.ResultSet#getTimestamp(String, Calendar)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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. |
time | 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
Jdbc
— 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
get Type()
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
get URL(columnIndex)
For documentation of this method, see
java.sql.ResultSet#getURL(int)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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.
Authorization
Scripts that use this method require authorization with one or more of the following scopes:
-
https://www.googleapis.com/auth/script.external_request
get URL(columnLabel)
For documentation of this method, see
java.sql.ResultSet#getURL(String)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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.
Authorization
Scripts that use this method require authorization with one or more of the following scopes:
-
https://www.googleapis.com/auth/script.external_request
get Warnings()
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
insert Row()
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
is After Last()
For documentation of this method, see
java.sql.ResultSet#isAfterLast()
.
Return
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.
Authorization
Scripts that use this method require authorization with one or more of the following scopes:
-
https://www.googleapis.com/auth/script.external_request
is Before First()
For documentation of this method, see
java.sql.ResultSet#isBeforeFirst()
.
Return
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.
Authorization
Scripts that use this method require authorization with one or more of the following scopes:
-
https://www.googleapis.com/auth/script.external_request
is Closed()
For documentation of this method, see
java.sql.ResultSet#isClosed()
.
Return
Boolean
— true
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
is First()
For documentation of this method, see
java.sql.ResultSet#isFirst()
.
Return
Boolean
— true
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
is Last()
For documentation of this method, see
java.sql.ResultSet#isLast()
.
Return
Boolean
— true
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
Boolean
— true
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
move To Current Row()
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
move To Insert Row()
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
Boolean
— true
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
Boolean
— true
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
refresh Row()
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
Name | Type | Description |
---|---|---|
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.
Authorization
Scripts that use this method require authorization with one or more of the following scopes:
-
https://www.googleapis.com/auth/script.external_request
row Deleted()
For documentation of this method, see
java.sql.ResultSet#rowDeleted()
.
Return
Boolean
— true
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
row Inserted()
For documentation of this method, see
java.sql.ResultSet#rowInserted()
.
Return
Boolean
— true
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
row Updated()
For documentation of this method, see
java.sql.ResultSet#rowUpdated()
.
Return
Boolean
— true
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
set Fetch Direction(direction)
For documentation of this method, see
java.sql.ResultSet#setFetchDirection(int)
.
Parameters
Name | Type | Description |
---|---|---|
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_request
set Fetch Size(rows)
For documentation of this method, see
java.sql.ResultSet#setFetchSize(int)
.
Parameters
Name | Type | Description |
---|---|---|
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_request
update Array(columnIndex, x)
For documentation of this method, see
java.sql.ResultSet#updateArray(int, Array)
.
Parameters
Name | Type | Description |
---|---|---|
column | Integer | The index of the column to update (the first column is 1, the second is 2, and so on). |
x | Jdbc | 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
update Array(columnLabel, x)
For documentation of this method, see
java.sql.ResultSet#updateArray(String, Array)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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 | Jdbc | 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
update Big Decimal(columnIndex, x)
For documentation of this method, see
java.sql.ResultSet#updateBigDecimal(int, BigDecimal)
.
Parameters
Name | Type | Description |
---|---|---|
column | Integer | The index of the column to update (the first column is 1, the second is 2, and so on). |
x | Big | 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
update Big Decimal(columnLabel, x)
For documentation of this method, see
java.sql.ResultSet#updateBigDecimal(String, BigDecimal)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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 | Big | 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
update Blob(columnIndex, x)
For documentation of this method, see
java.sql.ResultSet#updateBlob(int, Blob)
.
Parameters
Name | Type | Description |
---|---|---|
column | Integer | The index of the column to update (the first column is 1, the second is 2, and so on). |
x | Jdbc | 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
update Blob(columnLabel, x)
For documentation of this method, see
java.sql.ResultSet#updateRef(String, Blob)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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 | Jdbc | 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
update Boolean(columnIndex, x)
For documentation of this method, see
java.sql.ResultSet#updateBoolean(int, boolean)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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_request
update Boolean(columnLabel, x)
For documentation of this method, see
java.sql.ResultSet#updateBoolean(String, boolean)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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_request
update Byte(columnIndex, x)
For documentation of this method, see
java.sql.ResultSet#updateByte(int, byte)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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_request
update Byte(columnLabel, x)
For documentation of this method, see
java.sql.ResultSet#updateByte(String, byte)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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_request
update Bytes(columnIndex, x)
For documentation of this method, see
java.sql.ResultSet#updateBytes(int, byte[])
.
Parameters
Name | Type | Description |
---|---|---|
column | 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_request
update Bytes(columnLabel, x)
For documentation of this method, see
java.sql.ResultSet#updateBytes(String, byte[])
.
Parameters
Name | Type | Description |
---|---|---|
column | 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_request
update Clob(columnIndex, x)
For documentation of this method, see
java.sql.ResultSet#updateClob(int, Clob)
.
Parameters
Name | Type | Description |
---|---|---|
column | Integer | The index of the column to update (the first column is 1, the second is 2, and so on). |
x | Jdbc | 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
update Clob(columnLabel, x)
For documentation of this method, see
java.sql.ResultSet#updateClob(String, Clob)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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 | Jdbc | 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
update Date(columnIndex, x)
For documentation of this method, see
java.sql.ResultSet#updateDate(int, Date)
.
Parameters
Name | Type | Description |
---|---|---|
column | Integer | The index of the column to update (the first column is 1, the second is 2, and so on). |
x | Jdbc | 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
update Date(columnLabel, x)
For documentation of this method, see
java.sql.ResultSet#updateDate(String, Date)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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 | Jdbc | 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
update Double(columnIndex, x)
For documentation of this method, see
java.sql.ResultSet#updateDouble(int, double)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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_request
update Double(columnLabel, x)
For documentation of this method, see
java.sql.ResultSet#updateDouble(String, double)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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_request
update Float(columnIndex, x)
For documentation of this method, see
java.sql.ResultSet#updateFloat(int, float)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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_request
update Float(columnLabel, x)
For documentation of this method, see
java.sql.ResultSet#updateFloat(String, float)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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_request
update Int(columnIndex, x)
For documentation of this method, see
java.sql.ResultSet#updateInt(int, int)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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_request
update Int(columnLabel, x)
For documentation of this method, see
java.sql.ResultSet#updateInt(String, int)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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_request
update Long(columnIndex, x)
For documentation of this method, see
java.sql.ResultSet#updateLong(int, long)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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_request
update Long(columnLabel, x)
For documentation of this method, see
java.sql.ResultSet#updateLong(String, long)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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_request
update NClob(columnIndex, x)
For documentation of this method, see
java.sql.ResultSet#updateNClob(int, NClob)
.
Parameters
Name | Type | Description |
---|---|---|
column | Integer | The index of the column to update (the first column is 1, the second is 2, and so on). |
x | Jdbc | 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
update NClob(columnLabel, x)
For documentation of this method, see
java.sql.ResultSet#updateNClob(String, NClob)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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 | Jdbc | 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
update NString(columnIndex, x)
For documentation of this method, see
java.sql.ResultSet#updateNString(int, String)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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_request
update NString(columnLabel, x)
For documentation of this method, see
java.sql.ResultSet#updateNString(String, String)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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_request
update Null(columnIndex)
For documentation of this method, see
java.sql.ResultSet#updateNull(int)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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_request
update Null(columnLabel)
For documentation of this method, see
java.sql.ResultSet#updateNull(String)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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_request
update Object(columnIndex, x)
For documentation of this method, see
java.sql.ResultSet#updateObject(int, Object)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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_request
update Object(columnIndex, x, scaleOrLength)
For documentation of this method, see
java.sql.ResultSet#updateObject(int, Object, int)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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. |
scale | Integer | The number of digits after the decimal for Big types, or
the length of data for Input 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
update Object(columnLabel, x)
For documentation of this method, see
java.sql.ResultSet#updateObject(String, Object)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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_request
update Object(columnLabel, x, scaleOrLength)
For documentation of this method, see
java.sql.ResultSet#updateObject(String, Object, int)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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. |
scale | Integer | The number of digits after the decimal for Big types, or
the length of data for Input 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
update Ref(columnIndex, x)
For documentation of this method, see
java.sql.ResultSet#updateRef(int, Ref)
.
Parameters
Name | Type | Description |
---|---|---|
column | Integer | The index of the column to update (the first column is 1, the second is 2, and so on). |
x | Jdbc | 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
update Ref(columnLabel, x)
For documentation of this method, see
java.sql.ResultSet#updateRef(String, Ref)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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 | Jdbc | 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
update Row()
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
update Row Id(columnIndex, x)
For documentation of this method, see
java.sql.ResultSet#updateRowId(int, RowId)
.
Parameters
Name | Type | Description |
---|---|---|
column | Integer | The index of the column to update (the first column is 1, the second is 2, and so on). |
x | Jdbc | 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
update Row Id(columnLabel, x)
For documentation of this method, see
java.sql.ResultSet#updateRowId(String, RowId)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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 | Jdbc | 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
update SQLXML(columnIndex, x)
For documentation of this method, see
java.sql.ResultSet#updateSQLXML(int, SQLXML)
.
Parameters
Name | Type | Description |
---|---|---|
column | Integer | The index of the column to update (the first column is 1, the second is 2, and so on). |
x | Jdbc | 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
update SQLXML(columnLabel, x)
For documentation of this method, see
java.sql.ResultSet#updateSQLXML(String, SQLXML)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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 | Jdbc | 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
update Short(columnIndex, x)
For documentation of this method, see
java.sql.ResultSet#updateShort(int, short)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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_request
update Short(columnLabel, x)
For documentation of this method, see
java.sql.ResultSet#updateShort(String, short)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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_request
update String(columnIndex, x)
For documentation of this method, see
java.sql.ResultSet#updateString(int, String)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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_request
update String(columnLabel, x)
For documentation of this method, see
java.sql.ResultSet#updateString(String, String)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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_request
update Time(columnIndex, x)
For documentation of this method, see
java.sql.ResultSet#updateTime(int, Time)
.
Parameters
Name | Type | Description |
---|---|---|
column | Integer | The index of the column to update (the first column is 1, the second is 2, and so on). |
x | Jdbc | 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
update Time(columnLabel, x)
For documentation of this method, see
java.sql.ResultSet#updateTime(String, Time)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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 | Jdbc | 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
update Timestamp(columnIndex, x)
For documentation of this method, see
java.sql.ResultSet#updateTimestamp(int, Timestamp)
.
Parameters
Name | Type | Description |
---|---|---|
column | Integer | The index of the column to update (the first column is 1, the second is 2, and so on). |
x | Jdbc | 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
update Timestamp(columnLabel, x)
For documentation of this method, see
java.sql.ResultSet#updateTimestamp(String, Timestamp)
.
Parameters
Name | Type | Description |
---|---|---|
column | 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 | Jdbc | 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
was Null()
For documentation of this method, see
java.sql.ResultSet#wasNull()
.
Return
Boolean
— true
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