GetData¶

Executes query by specified column and value as single criteria and returns resulting data table instance.

1

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

Executes query by specific column and value as Name or Id number of target data stored criteria and return resulting datatable instance.

1

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

Parameters¶

string schema
    Name of target schema

string table
    Name of target table

string column
    Name of column to use as criteria

any value
    Value of column to use as criteria

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

Remarks¶

If no row matches return value is 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