ULTable class

Represents a table in an UltraLite database.

Syntax

public class ULTable

Members

All members of ULTable class, including all inherited members.

Name	Description
appendBytes method	Appends the given bytes to the end of the column.
appendStringChunk method	Appends a string chunk to a column.
close method	Closes the table.
deleteAllRows method	Deletes all rows in the table.
deleteRow method	Deletes the current row and moves to the next valid row.
findBegin method	Prepares to perform a new find on this table.
findFirst method	Moves forward through the table from the beginning, looking for a row that exactly matches a value or full set of values in the current index.
findFirstForColumns method	Moves forward through the table from the beginning, looking for a row that exactly matches a value or partial set of values in the current index.
findLast method	Moves backward through the table from the end, looking for a row that exactly matches a value or full set of values in the current index.
findLastForColumns method	Moves backward through the table from the end, looking for a row that exactly matches a value or partial set of values in the current index.
findNext method	Continues a findFirst() search by moving forward through the table from the current position, looking to see if the next row exactly matches a value or full set of values in the current index.
findNextForColumns method	Continues a findFirst(int) search by moving forward through the table from the current position, looking to see if the next row exactly matches a value or partial set of values in the current index.
findPrevious method	Continues a findLast() search by moving backward through the table from the current position, looking to see if the previous row exactly matches a value or full set of values in the current index.
findPreviousForColumns method	Continues a findLast(int) search by moving backward through the table from the current position, looking to see if the previous row exactly matches a value or partial set of values in the current index.
getBoolean method	Returns the value for the specified column as a boolean.
getBytes method	Returns the value for the specified column as an array of bytes.
getBytesSection method	Gets a binary chunk from the column.
getDate method	Returns the value for the specified SQLType.DATE column as a Date object.
getDouble method	Returns the value for the specified column as a double.
getFloat method	Returns the value for the specified column as a float.
getInt method	Returns the value for the specified column as a signed 32-bit integer.
getLong method	Returns the value for the specified column as a long.
getRowCount method	Returns the number of rows in the table.
getRowCountWithThreshold method	Returns the number of rows in the table up to a specified threshold number of rows.
getShort method	Returns the value for the specified column as a signed 16-bit integer.
getString method	Returns the value of the specified column as a String.
getStringChunk method	Copies a subset of the value for the specified SQLType.LONGVARCHAR column, beginning at the specified offset, to the retuned String object.
getTime method	Returns the value for the specified SQLType.TIME column as a Date object.
getTimestamp method	Returns the value for the specified SQLType.TIMESTAMP column as a Date object.
getTimestampWithTimeZone method	Returns the value for the specified SQLType.TIMESTAMP_WITH_TIME_ZONE column as a Date object.
getULong method	Returns the value for the specified column as an unsigned 64-bit integer.
getUUID method	Returns the value for the specified column as a UUID.
insert method	Inserts a new row with the current column values (specified using the setType methods).
insertBegin method	Prepares to insert a new row into this table by setting all current column values to their default values.
isBOF method	Checks whether the current row position is before the first row.
isEOF method	Checks whether the current row position is after the last row.
isNull method	Checks whether the value from the specified column is NULL.
isOpen method	Checks whether this table is currently open.
lookupBackward method	Moves backward through the table from the end, looking for a row that matches or is less than a value or full set of values in the current index.
lookupBackwardForColumns method	Moves backward through the table from the beginning, looking for a row that matches or is less than a value or partial set of values in the current index.
lookupBegin method	Prepares to perform a new lookup on this table.
lookupForward method	Moves forward through the table from the beginning, looking for a row that matches or is greater than a value or full set of values in the current index.
lookupForwardForColumns method	Moves forward through the table from the beginning, looking for a row that matches or is greater than a value or partial set of values in the current index.
moveAfterLast method	Moves to a position after the last row of the table.
moveBeforeFirst method	Moves to a position before the first row of the table.
moveFirst method	Moves to the position of the first row of the table.
moveLast method	Moves to the position of the last row of the table.
moveNext method	Moves to the position of the next row or after the last row of the table.
movePrevious method	Moves to the position of the previous row or before the first row of the table.
moveRelative method	Moves from the current row to the offset number of rows.
open method	Opens this table for data access using its primary key.
openWithIndex method	Opens this table for data access using the specified index.
setBoolean method	Sets the value for the specified column using a boolean.
setBytes method	Sets the value for the specified column using an array of bytes.
setDate method	Sets the value for the specified column using a Date object.
setDouble method	Sets the value for the specified column using a double.
setFloat method	Sets the value for the specified column using a float.
setInt method	Sets the value for the specified column using an integer.
setLong method	Sets the value for the specified column using an Int64.
setNull method	Sets a column to the SQL NULL.
setShort method	Sets the value for the specified column using a UInt16.
setString method	Sets the value for the specified column using a String.
setTime method	Sets the value for the specified column using a Date object.
setTimestamp method	Sets the value for the specified column using a Date object.
setTimestampWithTimeZone method	Sets the value for the specified column using a Date object.
setToDefault method	Sets the value for the specified column to its default value.
setULong method	Sets the value for the specified column using a 64-bit long treated as an unsigned value.
setUUID method	Sets the value for the specified column using a UUID.
truncate method	Deletes all rows in the table while temporarily activating stop synchronization delete.
update method	Updates the current row.
updateBegin method	Selects the updates made for setting columns.
NULL_TIMESTAMP_VAL variable	Constant for null timestamp.
schema variable	Readonly property; Holds the schema of this table.

appendBytes method
appendStringChunk method
close method
deleteAllRows method
deleteRow method
findBegin method
findFirst method
findFirstForColumns method
findLast method
findLastForColumns method
findNext method
findNextForColumns method
findPrevious method
findPreviousForColumns method
getBoolean method
getBytes method
getBytesSection method
getDate method
getDouble method
getFloat method
getInt method
getLong method
getRowCount method
getRowCountWithThreshold method
getShort method
getString method
getStringChunk method
getTime method
getTimestamp method
getTimestampWithTimeZone method
getULong method
getUUID method
insert method
insertBegin method
isBOF method
isEOF method
isNull method
isOpen method
lookupBackward method
lookupBackwardForColumns method
lookupBegin method
lookupForward method
lookupForwardForColumns method
moveAfterLast method
moveBeforeFirst method
moveFirst method
moveLast method
moveNext method
movePrevious method
moveRelative method
open method
openWithIndex method
setBoolean method
setBytes method
setDate method
setDouble method
setFloat method
setInt method
setLong method
setNull method
setShort method
setString method
setTime method
setTimestamp method
setTimestampWithTimeZone method
setToDefault method
setULong method
setUUID method
truncate method
update method
updateBegin method
NULL_TIMESTAMP_VAL variable
schema variable

Discuss this page in DocCommentXchange.