Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 5 Next »

Overview

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

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

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

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

Arguments

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

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

Remarks

If no row matches return value is empty data table.

Example

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

Examples

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