ExecuteTable() method

UL Ext: Retrieves a database table in a ULTable object for direct manipulation.

Visual Basic syntax

Public Function ExecuteTable() As ULTable

C# syntax

public ULTable ExecuteTable()

Exceptions

ULException class A SQL error occurred.
InvalidOperationException The command is in an invalid state. Either the ULCommand.Connection value is missing or closed, the ULCommand.Transaction value does not match the current transaction state of the connection, or the ULCommand.CommandText value is invalid.

Remarks

The ULCommand.CommandText value is interpreted as the name of the table, and ULCommand.IndexName value can be used to specify a table sorting order.

The ULCommand.CommandType value must be set to System.Data.CommandType.TableDirect.

If the ULCommand.IndexName value is a null reference (Nothing in Visual Basic), the primary key is used to open the table. Otherwise, the table is opened using the ULCommand.IndexName value as the name of the index by which to sort.

ExecuteTable() method

Visual Basic syntax

C# syntax

Returns

Exceptions

Remarks

See also