Field-Map Scripting

4.2.3.56 GetMeanOfAttributeValues

GetMeanOfAttributeValues function


Prototype:

function GetMeanOfAttributeValues(const AttributeName: string; const Where: string): variant;

Description:

Returns the mean value of a numeric attribute specified by the AttributeName parameter in a given layer. The search is performed within the currently opened plot to which an SQL query specified by the Where parameter is applied.

Syntax:

variable := Layer.GetMeanOfAttributeValues(AttributeName,Where);


Part

Description


variable

A variable declared as a variant


Layer

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


AttributeName

A reference to a Field-Map attribute in the specified Field-Map layer


Where

The Where parameter specifies the desired attribute using an SQL command

Return value:

a numeric variant


Note: For Field-Map version 13 and older, the name of the function is GetMeanAttributeValue.





See also:

Value; ValueAsString; ValueAsinteger; ValueAsFloat; ValueAsboolean; OldValue; PreviousValue; BOF; EOF; RecordCount; State; SetValues; SetValuesFromXML; CrownProjection; CrownProfile; CrownProfilePoints; StemProfile; OldLayer; SavePosition; RestorePosition; SaveState; RestoreState; SavePositionAndState; RestorePositionAndState; Open; Close; First; Last; Next; Prior; Edit; Post; Append; Delete; Cancel; Refresh; Locate; ClearTable; Filter; Filtered; CheckFilter; SetFilterExt; ClearFilterForChildLayers; DeepFilter; EnableCachedUpdates; ApplyUpdates; GetAttributeValue; GetQueryResult; DeleteFrom; Update; CreateMemTable; SaveToDBF; SaveToExcel; GetMinOfAttributeValues; GetMaxOfAttributeValues; GetMeanOfAttributeValues; GetSumOfAttributeValues; GetRecordCount; GetLookupTable; GetLookupListValue; GetLookupListAttributeValue; GetID; GetIdAttributeName; GetIdSQL; SaveTimeStamp; File2Blob; Blob2Folder; String2Blob; Blob2String; FillAttributeValues; MarkValuesAsConditional;GetListOfChildLayers; GetPercentageOfFilledAttributes4Record; GetPercentageOfFilledAttributes4Layer; RoundAttributeValues