4.2.3.48 GetQueryResult

Prototype:

function GetQueryResult(const Select, Where: string): TTableWrapper;

Description:

The GetQueryResult function

Syntax:

variable := Layer.GetQueryResult(Select,Where);

Part

Description

variable

A variable declared as an instance of the TFieldMapTableScriptWrapper class

Layer

A reference to a Field-Map layer as defined in Field-Map Project Manager

Select

The "SELECT" part of the SQL query as a string (The "FROM Layer " part is included automatically.)

Where

The "WHERE" part of the SQL query as a string (The "IDPlots=PlotID" part is included automatically, hence limiting the query result to the active plot.)

Syntax example:

Layer.GetQueryResult('DISTINCT Attrib1,Attrib2','ID<20')

The example above will build up the following SQL query: SELECT DISTINCT Attrib1,Attrib2 FROM Layer WHERE IDPlots=23 AND ID<20.

Return value:

a script wrapper for the table which is created by applying the specified query