ULTable class

Represents a table in an UltraLite database.

Syntax

public class ULTable : ULResultSet

Base classes

Members

All members of ULTable class, including all inherited members.

Name	Description
AfterLast method	Moves the cursor after the last row.
AppendByteChunk method	Appends bytes to a column.
AppendStringChunk method	Appends a string chunk to a column.
BeforeFirst method	Moves the cursor before the first row.
Close method	Destroys this object.
Delete method	Deletes the current row and moves it to the next valid row.
DeleteAllRows method	Deletes all rows from a table.
DeleteNamed method	Deletes the current row and moves it to the next valid row.
Find method	Performs an exact match lookup based on the current index scanning forward through the table.
FindBegin method	Prepares to perform a new Find call on a table by entering find mode.
FindFirst method	Performs an exact match lookup based on the current index scanning forward through the table.
FindLast method	Performs an exact match lookup based on the current index scanning backward through the table.
FindNext method	Gets the next row that exactly matches the index.
FindPrevious method	Gets the previous row that exactly matches the index.
First method	Moves the cursor to the first row.
GetBinary method	Fetches a value from a column as a ul_binary value.
GetBinaryLength method	Gets the binary length of the value of a column.
GetByteChunk method	Gets a binary chunk from the column.
GetConnection method	Gets the connection object.
GetDateTime method	Fetches a value from a column as a DECL_DATETIME.
GetDouble method	Fetches a value from a column as a double.
GetFloat method	Fetches a value from a column as a float.
GetGuid method	Fetches a value from a column as a GUID.
GetInt method	Fetches a value from a column as an integer.
GetIntWithType method	Fetches a value from a column as the specified integer type.
GetResultSetSchema method	Returns an object that can be used to get information about the result set.
GetRowCount method	Gets the number of rows in the table.
GetState method	Gets the internal state of the cursor.
GetString method	Fetches a value from a column as a null-terminated string.
GetStringChunk method	Gets a string chunk from the column.
GetStringLength method	Gets the string length of the value of a column.
GetTableSchema method	Returns a ULTableSchema object that can be used to get schema information about the table.
Insert method	Inserts a new row into the table.
InsertBegin method	Selects the insert mode for setting columns.
IsNull method	Checks if a column is NULL.
Last method	Moves the cursor to the last row.
Lookup method	Performs a lookup based on the current index scanning forward through the table.
LookupBackward method	Performs a lookup based on the current index scanning backward through the table.
LookupBegin method	Prepares to perform a new lookup on a table.
LookupForward method	Performs a lookup based on the current index scanning forward through the table.
Next method	Moves the cursor forward one row.
Previous method	Moves the cursor back one row.
Relative method	Moves the cursor by offset rows from the current cursor position.
SetBinary method	Sets a column to a ul_binary value.
SetDateTime method	Sets a column to a DECL_DATETIME value.
SetDefault method	Sets a column to its default value.
SetDouble method	Sets a column to a double value.
SetFloat method	Sets a column to a float value.
SetGuid method	Sets a column to a GUID value.
SetInt method	Sets a column to an integer value.
SetIntWithType method	Sets a column to an integer value of the specified integer type.
SetNull method	Sets a column to null.
SetString method	Sets a column to a string value.
TruncateTable method	Truncates the table and temporarily activates STOP SYNCHRONIZATION DELETE.
Update method	Updates the current row.
UpdateBegin method	Selects the update mode for setting columns.

DeleteAllRows method
Find method
FindBegin method
FindFirst method
FindLast method
FindNext method
FindPrevious method
GetTableSchema method
Insert method
InsertBegin method
Lookup method
LookupBackward method
LookupBegin method
LookupForward method
TruncateTable method

Discuss this page in DocCommentXchange.