ERPConnect.Queries.Query

Namespace: ERPConnect.Queries
Assembly: ERPConnectStandard20.dll

Class for executing SAP Queries and retrieving the data.

public class Query

Inheritance

object ← Query

Inherited Members

object.GetType(), object.MemberwiseClone(), object.ToString(), object.Equals(object?), object.Equals(object?, object?), object.ReferenceEquals(object?, object?), object.GetHashCode()

Constructors

Query(R3Connection)

Constructs a new query object

public Query(R3Connection Connection)

Parameters

Connection R3Connection

A valid connection object

Properties

ExternalRepresentation

Set or gets if fields with user exits should be represented in external format

public bool ExternalRepresentation { get; set; }

Property Value

bool

Fields

Output fields of the query

public QueryFieldCollection Fields { get; set; }

Property Value

QueryFieldCollection

MaxRows

The maximum number of rows to be extracted (0 for all)

public int MaxRows { get; set; }

Property Value

int

Name

Name of the query

public string Name { get; set; }

Property Value

string

Result

A ADO .NET DataTable which contains the data result

public DataTable Result { get; }

Property Value

DataTable

SelectionParameters

A collection of SelectParameters which represent the selection screen of the query

public QuerySelectionParameterCollection SelectionParameters { get; set; }

Property Value

QuerySelectionParameterCollection

UserGroup

Name of the user group

public string UserGroup { get; set; }

Property Value

string

Variant

Name of the variant (if used)

public string Variant { get; set; }

Property Value

string

WorkArea

The current query workspace

public WorkSpace WorkArea { get; set; }

Property Value

WorkSpace

Methods

Execute()

Executes the query and fills the Result property

public void Execute()

ToString()

Retrieves a textual description of the whole query structure

public override string ToString()

Returns

string

Query structure