Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

ExecuteTable method

UL Ext.: Retrieves in a ULTable a database table for direct manipulation. The table is opened (sorted) using the specified index.

Visual Basic

Overloads Public Function ExecuteTable( _
ByVal tableName As String, _
ByVal indexName As String _
) As ULTable

C#

public ULTable ExecuteTable(
string tableName,
string indexName
);

• tableName   The name of the table to open.

• indexName   The name of the index with which to open (sort) the table.

The table as a ULTable object.

This method is a shortcut for the ULCommand.ExecuteTable() method that does not require a ULCommand instance. It is provided to help users porting from earlier versions of UltraLite.NET (it replaces iAnywhere.UltraLite.Connection.GetTable() and iAnywhere.UltraLite.Table.Open()).

• ULException class - A SQL error occurred.

•  InvalidOperationException - The tableName is invalid.

The following code opens the table named MyTable using the index named MyIndex. It assumes an open ULConnection instance called conn.

' Visual Basic
Dim t As ULTable = conn.ExecuteTable("MyTable", "MyIndex")
' The line above is equivalent to
' Dim cmd As ULCommand = conn.CreateCommand()
' cmd.CommandText = "MyTable"
' cmd.IndexName = "MyIndex"
' cmd.CommandType = CommandType.TableDirect
' Dim t As ULTable = cmd.ExecuteTable()
' cmd.Dispose()

// C#
ULTable t = conn.ExecuteTable("MyTable", "MyIndex");
// The line above is equivalent to
// ULTable t;
// using(ULCommand cmd = conn.CreateCommand())
// {
//     cmd.CommandText = "MyTable";
//     cmd.IndexName = "MyIndex";
//     cmd.CommandType = CommandType.TableDirect;
//     t = cmd.ExecuteTable();
// }

• ULConnection class
• ULConnection members
• ExecuteTable method
• ExecuteTable method
• ULTable class
• ExecuteTable method
• ULCommand class