GetData¶

Executes a query using the specified column and value as a single criterion, and returns the resulting DataTable instance.

1

$Database.GetData(schema: string, table: string, column: string, value: any):DataTable

Executes a query by a specific column and value as a criteria and returns the resulting data table instance.

1

$Database.GetData(store: string, schema: string, table: string, column: string, value: any):DataTable

Parameters¶

string schema
    The name of the target schema.

string table
    The name of the target table.

string column
    The name of the column to use as criteria.

any value
    The value of the column to use as criteria.

string store
    Name or Id number of target data store. This parameter is optional.

Returns¶

A DataTable instance containing the query results.

Remarks¶

If no rows match, the return value is an empty data table.

Example¶

1

var table = $Database.GetData("MySchema", "MyTable", "Id", $Xml.Evaluate('Id'));

If no row matches return value is empty data table.

Example¶

1

var table = $Database.GetData("MySchema", "MyTable", "Id", $Xml.Evaluate('Id'));

See Also¶

• DataTable