Field-Map Scripting
1. Field-Map Scripting
2. About Field-Map Scripting
2.1 What is a Field-Map script
2.2 Why use Field-Map scripts
2.3 How to create a Field-Map script
2.4 Some Field-Map scripting key terms
2.5 Field-Map script types
2.5.1 Field-Map script types overview
2.5.2 On-Validate scripts
2.5.3 On-Change scripts
2.5.4 On-Demand scripts
2.5.5 Layer scripts
2.5.5.1 List of layer events
2.5.6 Global scripts
2.5.6.1 List of global events
2.6 Writing scripts in Field-Map
2.6.1 Writing On-Validate / On-Change scripts in Field-Map Project Manager
2.6.2 Writing On-Demand scripts in Field-Map Project Manager
2.6.3 Writing Layer scripts in Field-Map Project Manager
2.6.4 Writing scripts in Field-Map Data Collector
2.6.5 Hot keys
3. About Field-Map Object Pascal
3.1 What is Field-Map Object Pascal
3.2 Borland Object Pascal features supported in Field-Map Object Pascal
3.3 Format strings
3.4 Field-Map Object Pascal specifics
3.4.1 Accessing Field-Map data within a script
3.4.2 Using Field-Map predefined variables
3.4.3 Using Field-Map global variables
3.4.4 Disabling events
3.4.4.1 DisableScripts
3.4.4.2 EnableScripts
3.4.4.3 ScriptsEnabled
3.4.5 Referencing scripts
3.4.5.1 PerformLayerScript
3.4.5.2 PerformOnChangeScript
3.4.5.3 PerformOnChangeScriptForAllRecords
4. Functions, procedures and properties
4.1 General
4.1.1 Screen
4.1.1.1 Message boxes
4.1.1.1.1 ShowMessage
4.1.1.1.2 ShowMsg
4.1.1.1.3 ShowInformation
4.1.1.1.4 ShowWarning
4.1.1.1.5 ShowError
4.1.1.1.6 YesNoQuestion
4.1.1.1.7 BlinkingMessage
4.1.1.1.8 OpenWebPage
4.1.1.2 Input from user interface
4.1.1.2.1 InputInteger
4.1.1.2.2 InputIntegerWithCounter
4.1.1.2.3 InputFloat
4.1.1.2.4 InputString
4.1.1.2.5 InputText
4.1.1.2.6 InputOption
4.1.1.2.7 InputOptionWithStartingValue
4.1.1.2.8 InputFromList
4.1.1.2.9 InputFromListWithStartingValue
4.1.1.2.10 InputFromCheckListTab
4.1.1.2.11 InputFromListTab
4.1.1.3 Logs
4.1.1.3.1 OpenLog
4.1.1.3.2 IsLogOpen
4.1.1.3.3 HideLog
4.1.1.3.4 ShowLog
4.1.1.3.5 LogWindowStayOnTop
4.1.1.3.6 MakeLogWindowStayOnTop
4.1.1.3.7 CloseLog
4.1.1.3.8 CloseLogWithDelay
4.1.1.3.9 Log
4.1.1.3.10 LogExt
4.1.1.3.11 LogTabStops
4.1.1.4 Progress bar
4.1.1.4.1 PrepareProgressBar
4.1.1.4.2 StartProgressBarCycle
4.1.1.4.3 StepProgressBar
4.1.1.4.4 ResetProgressBar
4.1.1.4.5 PerformOneStepCycle
4.1.1.4.6 SetProgressBarMin
4.1.1.4.7 SetProgressBarMax
4.1.1.4.8 SetProgressBarPosition
4.1.1.4.9 SetProgressBarStep
4.1.1.4.10 Example
4.1.1.5 Navigator
4.1.1.5.1 OpenNavigator
4.1.1.5.2 OpenNavigatorFromFile
4.1.1.5.3 CloseNavigator
4.1.1.5.4 ShowNavigator
4.1.1.5.5 ClearNavigator
4.1.1.6 Button management
4.1.1.6.1 HideButton
4.1.1.6.2 ShowButton
4.1.1.6.3 SetFieldMapButtonLabel
4.1.1.6.4 GetFingerControl
4.1.1.6.5 GetButtonExpansionPercentage
4.1.1.6.6 GetFontExpansionPercentage
4.1.1.6.7 List of button names
4.1.1.7 Data Collector options item
4.1.1.7.1 HideDataCollectorOptionsItem
4.1.1.7.2 ShowDataCollectorOptionsItem
4.1.1.8 Screen resolution
4.1.1.8.1 PixelsPerInch
4.1.1.8.2 MainFormWidth
4.1.1.8.3 MainFormHeight
4.1.1.9 Colors
4.1.1.9.1 RGB
4.1.1.9.2 Color2RGB
4.1.1.9.3 Colors list
4.1.1.10 ComboPanel
4.1.1.10.1 ComboPanelCollapse
4.1.1.10.2 ComboPanelExpand
4.1.1.10.3 CollapseAllComboPanels
4.1.1.10.4 ExpandAllComboPanels
4.1.1.10.5 AllComboPanelsCollapsed
4.1.2 Strings
4.1.2.1 Format
4.1.2.2 LZero
4.1.2.3 Delete
4.1.2.4 Trim
4.1.2.5 TrimLeft
4.1.2.6 TrimRight
4.1.2.7 SameText
4.1.2.8 StringReplace
4.1.2.9 DeFormat1-10
4.1.2.10 GetFieldCountFromString
4.1.2.11 GetFieldFromString
4.1.2.12 IndexOfField
4.1.2.13 SortNumericSequence
4.1.3 Math & Statistics
4.1.3.1 Mathematical functions and procedures
4.1.3.1.1 Power
4.1.3.1.2 Round
4.1.3.1.3 RoundTo
4.1.3.1.4 Round2int
4.1.3.1.5 RoundVariant
4.1.3.1.6 Cos
4.1.3.1.7 ArcCos
4.1.3.1.8 ArcCosH
4.1.3.1.9 Sin
4.1.3.1.10 ArcSin
4.1.3.1.11 ArcSinH
4.1.3.1.12 ArcTan
4.1.3.1.13 ArcTan2
4.1.3.1.14 ArcTanH
4.1.3.1.15 CosH
4.1.3.1.16 SinH
4.1.3.1.17 Tan
4.1.3.1.18 TanH
4.1.3.1.19 Random
4.1.3.1.20 RandomRange
4.1.3.1.21 Randomize
4.1.3.1.22 Floor
4.1.3.1.23 Ceil
4.1.3.1.24 Int
4.1.3.1.25 Frac
4.1.3.1.26 Log10
4.1.3.1.27 Ln
4.1.3.1.28 Exp
4.1.3.1.29 Abs
4.1.3.1.30 Min
4.1.3.1.31 Max
4.1.3.1.32 Odd
4.1.3.1.33 SecondsBetween
4.1.3.1.34 CompareValue
4.1.3.1.35 SameValue
4.1.3.1.36 Trunc
4.1.3.1.37 Example
4.1.3.2 Statistical functions and procedures
4.1.3.2.1 Mean
4.1.3.2.2 QuadraticMean
4.1.3.2.3 WeightedMean
4.1.3.2.4 Median
4.1.3.2.5 SampleVariance
4.1.3.2.6 StandardDeviation
4.1.3.2.7 StandardError
4.1.3.2.8 MeanError
4.1.3.2.9 VarianceOfMean
4.1.3.2.10 WeightedSampleVariance
4.1.3.2.11 WeightedStandardDeviation
4.1.3.2.12 WeightedVarianceOfMean
4.1.3.2.13 ConfidenceIntervalOfMean
4.1.3.2.14 VarianceOfTotal
4.1.3.2.15 ConfidenceIntervalOfTotal
4.1.3.2.16 StratifiedConfidenceIntervalOfTotal
4.1.3.2.17 SampleSize
4.1.3.2.18 ShowDistributionChart
4.1.3.2.19 ParameterizeRegressionModel
4.1.3.2.20 CalculateModelValue
4.1.3.2.21 Example
4.1.4 Text file
4.1.4.1 AssignFile
4.1.4.2 Reset
4.1.4.3 Rewrite
4.1.4.4 Append
4.1.4.5 WriteLn
4.1.4.6 ReadLn
4.1.4.7 EOF
4.1.4.8 CloseFile
4.1.4.9 DeleteFile
4.1.4.10 SaveStringToFile
4.1.4.11 SaveStringToFileAsUTF8
4.1.5 Registry
4.1.5.1 SaveValueToRegistry
4.1.5.2 LoadValueFromRegistry
4.1.6 System
4.1.6.1 Predefined variables
4.1.6.2 Sound
4.1.6.2.1 Beep
4.1.6.2.2 PlaySoundFromFile
4.1.6.2.3 PlaySoundFromLibrary
4.1.6.2.4 ReleaseSound
4.1.6.2.5 SwitchSoundsOff
4.1.6.2.6 SwitchSoundsOn
4.1.6.2.7 Speak
4.1.6.3 Decimal
4.1.6.3.1 DecimalSeparator
4.1.6.3.2 SetDecimalPoint
4.1.6.3.3 SetDecimalComma
4.1.6.3.4 ResetDecimalSeparator
4.1.6.4 Others functions and procedures
4.1.6.4.1 CloseFieldMap
4.1.6.4.2 Abort
4.1.6.4.3 ProcessMessages
4.1.6.4.4 Sleep
4.1.6.4.5 SoftwareKey
4.1.6.4.6 GetTickCount
4.1.6.4.7 CreateGUID
4.1.6.4.8 HourGlassCursor
4.1.6.4.9 DefaultCursor
4.1.6.4.10 DisableFieldMapWindow
4.1.6.4.11 EnableFieldMapWindow
4.1.6.4.12 SetRightTitleBarCaption
4.1.6.4.13 RunFieldMapExtension
4.1.6.4.14 VarIsNull
4.1.7 Conversions
4.1.7.1 String2Float
4.1.7.2 Variant2Float
4.1.7.3 Variant2Integer
4.1.7.4 Variant2String
4.1.7.5 String2Variant
4.1.7.6 Boolean2Integer
4.1.7.7 Date2Integer
4.1.7.8 Integer2Date
4.1.7.9 Int2Hex
4.1.7.10 IntToHex
4.1.7.11 GetBitFromLastThreeDigits
4.1.7.12 SetBitOfDouble
4.1.7.13 GetBitOfDouble
4.1.7.14 SetBitOfInteger
4.1.7.15 GetBitOfInteger
4.1.7.16 SetBitOfBigInt
4.1.7.17 GetBitOfBigInt
4.1.8 Global variables
4.1.8.1 SetGlobalVariable
4.1.8.2 GetGlobalVariable
4.1.8.3 GlobalVariableExists
4.1.8.4 RemoveGlobalVariable
4.1.8.5 RemoveGlobalVariables
4.1.8.6 Value
4.1.8.7 Example
4.1.9 Database
4.1.9.1 OpenTable
4.1.9.2 LoadSimpleXML
4.1.9.3 OpenParadoxTable
4.1.9.4 CreateMemTableFromDefs
4.1.9.5 CloseAndFreeTable
4.1.9.6 Constants
4.1.9.7 AddintegerAttribute
4.1.9.8 AddFloatAttribute
4.1.9.9 AddbooleanAttribute
4.1.9.10 AddStringAttribute
4.1.9.11 AttributeExists
4.1.9.12 DefaultValue
4.1.9.13 DefaultValueEnabled
4.1.9.14 GetAttributesWithDefaultValue
4.1.9.15 NumberOfAttributesWithDefaultValue
4.1.10 Array
4.1.10.1 SetArrayLength
4.1.10.2 GetArrayLength
4.1.10.3 VarArrayOf
4.1.10.4 VarArrayCreate
4.1.10.5 VarArrayDimCount
4.1.10.6 VarArrayLowBound
4.1.10.7 VarArrayHighBound
4.1.10.8 VarType
4.1.10.9 VarIsArray
4.1.10.10 VarIsNumeric
4.1.10.11 SetVarArrayValue
4.1.10.12 GetVarArrayValue
4.1.11 XML
4.1.11.1 TScriptXMLDocument members
4.1.11.1.1 OpenXMLDocument
4.1.11.1.2 OpenLockedXMLDocument
4.1.11.1.3 OpenXMLDocumentExt
4.1.11.1.4 OpenXMLDocumentFromString
4.1.11.1.5 OpenXMLDocumentFromStringExt
4.1.11.1.6 FreeXMLDocument
4.1.11.1.7 GetAttributeValueFromXMLDocument
4.1.11.1.8 Example
4.1.11.2 TScriptXMLElement members
4.1.11.2.1 GetRootElement
4.1.11.2.2 GetElementName
4.1.11.2.3 GetChildElements
4.1.11.2.4 GetFirstChildElement
4.1.11.2.5 GetElementText
4.1.11.2.6 GetElementInteger
4.1.11.2.7 GetElementDouble
4.1.11.2.8 GetElementBoolean
4.1.11.2.9 GetElementCDATA
4.1.11.2.10 HasAttribute
4.1.11.2.11 HasNoNullAttribute
4.1.11.2.12 GetStringAttribute
4.1.11.2.13 GetStringAttributeAsString
4.1.11.2.14 GetStringAttributeAsDateTime
4.1.11.2.15 GetIntegerAttribute
4.1.11.2.16 GetIntegerAttributeAsInteger
4.1.11.2.17 GetFloatAttribute
4.1.11.2.18 GetFloatAttributeAsVariant
4.1.11.2.19 GetFloatAttributeAsFloat
4.1.11.2.20 GetBooleanAttribute
4.1.11.2.21 GetFirstChildElementStringAttribute
4.1.11.2.22 GetFirstChildElementStringAttributeAsString
4.1.11.2.23 GetFirstChildElementIntegerAttribute
4.1.11.2.24 GetFirstChildElementIntegerAttributeAsInteger
4.1.11.2.25 GetFirstChildElementFloatAttribute
4.1.11.2.26 GetFirstChildElementFloatAttributeAsVariant
4.1.11.2.27 GetFirstChildElementFloatAttributeAsFloat
4.1.11.2.28 GetFirstChildElementBooleanAttribute
4.1.11.2.29 Name
4.1.11.2.30 FreeXMLElement
4.1.11.2.31 SaveValuesToTable
4.1.11.2.32 GetRootElementName
4.1.11.2.33 GetFirstChildElementText
4.1.11.2.34 GetFirstChildElementinteger
4.1.11.2.35 GetFirstChildElementDouble
4.1.11.2.36 GetFirstChildElementboolean
4.1.11.3 TScriptXMLElementList members
4.1.11.3.1 GetCount
4.1.11.3.2 GetElement
4.1.11.3.3 FreeXMLElementList
4.1.11.3.4 Example
4.1.11.4 TXMLOutputWrapper members
4.1.11.4.1 CreateXMLOutput
4.1.11.4.2 WriteComment
4.1.11.4.3 WriteString
4.1.11.4.4 WriteInteger
4.1.11.4.5 WriteVariant
4.1.11.4.6 WriteFloat
4.1.11.4.7 WriteBoolean
4.1.11.4.8 WriteDate
4.1.11.4.9 WriteDateTime
4.1.11.4.10 WriteDateTimeAsInt64
4.1.11.4.11 WriteDateTimeAsInt64WithMiliseconds
4.1.11.4.12 AddTableData
4.1.11.4.13 AddLayerData
4.1.11.4.14 BeginDocumentAttrs
4.1.11.4.15 BeginElementAttrs
4.1.11.4.16 EndAttrs
4.1.11.4.17 EndElement
4.1.11.4.18 EndDocument
4.1.11.4.19 FreeXMLOutput
4.1.11.4.20 CreateXMLOutputFile
4.1.11.4.21 Example
4.1.12 Date
4.1.12.1 Day
4.1.12.2 Month
4.1.12.3 Year
4.1.12.4 DecodeDate
4.1.12.5 DecodeDateExt
4.1.12.6 DecodeDateTimeExt
4.1.12.7 YearOf
4.1.12.8 MonthOf
4.1.12.9 DayOf
4.1.12.10 DaysInAMonth
4.1.12.11 StrToDateTime
4.1.12.12 DateToStr
4.1.12.13 DateTimeAsString
4.1.12.14 FormatElapsedTime
4.1.12.15 Date
4.1.12.16 Now
4.1.12.17 IncMonth
4.1.12.18 IncDay
4.1.13 Measurement (support of devices)
4.1.13.1 CancelMeasurement
4.1.13.2 MeasureHorizDist
4.1.13.3 MeasureInclination
4.1.13.4 MeasureHorizDistAndInclination
4.1.13.5 MeasureRemoteDiameter
4.1.13.6 MeasureStemProfile
4.1.13.7 GetContinuousGpsCoordinates
4.1.13.8 GetCurrentPosition
4.1.13.9 SetCurrentPosition
4.1.13.10 ResetOnlineCalliper
4.1.13.11 SendMessageToNonSpecificEquipment
4.1.13.12 ManageNonSpecificEquipment
4.1.13.13 NonSpecificEquipmentActive
4.1.13.14 DendroscopeSerialNumber
4.1.13.15 GetFieldMapVersion
4.1.13.16 CalcVerticalDistance
4.1.13.17 VerticalDistance
4.1.13.18 CalcInclination
4.1.13.19 CheckSum
4.1.13.20 CheckSumOK
4.1.13.21 GetBearingAngle_deg
4.1.13.22 GetBearingAzimuth_deg
4.1.13.23 GetLaserEquipmentHeight_cm
4.1.13.24 GetAzimuthFixOffset_deg
4.1.13.25 GetAzimuthUnits
4.1.13.26 GetMagneticDeclination_deg
4.1.13.27 GetMainPoleLength_cm
4.1.13.28 GetMainPoleLengthCorrection_cm
4.1.13.29 GetMainPoleOffsetForTreeMeasurement_cm
4.1.13.30 GetMainPoleReflectorOffset_cm
4.1.13.31 GetOffsetOfCylReflector_cm
4.1.13.32 GetGPSAntennaHeight_cm
4.1.13.33 GetPolePositionMode
4.1.13.34 SetPromptBeforeChangeTreePositionOfPreviousMeasurement
4.1.13.35 StartGNSSLog
4.1.14 GIS
4.1.14.1 ExtendLine
4.1.14.2 CombinePolygons
4.1.14.3 IntersectPolygons
4.1.14.4 FindLineIntersects
4.1.14.5 Distance
4.1.14.6 PolarToXY
4.1.14.7 Polar2XY
4.1.14.8 XYtoPolar
4.1.14.9 XY2polar
4.1.15 Lists
4.1.15.1 Creating list members
4.1.15.1.1 CreateStringList
4.1.15.1.2 CreateIntegerList
4.1.15.1.3 CreateVariantList
4.1.15.1.4 CreateMultiVariantList
4.1.15.1.5 CreateVarVariantList
4.1.15.2 Free list members
4.1.15.2.1 FreeStringList
4.1.15.2.2 FreeIntegerList
4.1.15.2.3 FreeVariantList
4.1.15.2.4 FreeMultiVariantList
4.1.15.2.5 FreeVarVariantList
4.1.16 ScriptOrganizer
4.1.16.1 Create
4.1.16.2 Free
4.1.16.3 Caption
4.1.16.4 Header
4.1.16.5 AddGroup
4.1.16.6 AddSubGroup
4.1.16.7 AddAttributeScript
4.1.16.8 AddOnDemandScript
4.1.16.9 AddGlobalVariable
4.1.16.10 Show
4.1.16.11 RegistryNameForLastPositionStyle
4.1.17 Stem profile
4.1.17.1 CreateStemProfile
4.1.17.2 FreeStemProfile
4.1.18 Species groups
4.1.18.1 CreateSpeciesGroups
4.1.18.2 FreeSpeciesGroups
4.2 LayerWrapper
4.2.1 Basic
4.2.1.1 Name
4.2.1.2 Free
4.2.1.3 ParentName
4.2.1.4 LayerType
4.2.1.5 LayerLevel
4.2.1.6 LayerLabel
4.2.1.7 AutoTimeStampEnabled
4.2.1.8 PerformOnChangeScript
4.2.1.9 PerformOnChangeScriptForAllRecords
4.2.1.10 PerformLayerScript
4.2.1.11 OnLineCalliper_AddAttribute
4.2.1.12 OnLineCalliper_RemoveAttribute
4.2.1.13 OnLineCalliper_ClearAttributes
4.2.1.14 OnLineCalliper_GotoAttribute
4.2.1.15 OnLineCalliper_AddRecordUponReceipt
4.2.1.16 GetCrownProfileVolumeAndSurface
4.2.1.17 GetCrownProjectionAsLine
4.2.1.18 GetCrownProjectionAsPolygon
4.2.1.19 OpenExternalForm
4.2.1.20 Filename
4.2.1.21 AssignAttribute
4.2.1.22 ImportOnlyCentroids
4.2.1.23 Execute
4.2.1.24 IsValidParentLayer
4.2.1.25 RelationType
4.2.1.26
4.2.2 Screen
4.2.2.1 RefreshAttributeLayout
4.2.2.2 TabStop
4.2.2.3 Enabled
4.2.2.4 EnableAttributes
4.2.2.5 DisableAttributes
4.2.2.6 Visible
4.2.2.7 ShowAttributes
4.2.2.8 HideAttributes
4.2.2.9 AlignAttribute
4.2.2.10 AlignAttributes
4.2.2.11 AlignOverviewGridTitles
4.2.2.12 OverviewGridAttributeTitle
4.2.2.13 ClickToAttributeControl
4.2.2.14 UseKeyboard4ComboBox
4.2.2.15 OverviewGridAttributeVisible
4.2.2.16 ShowOverviewGridAttribute
4.2.2.17 HideOverviewGridAttribute
4.2.2.18 Color
4.2.2.19 ResetColor
4.2.2.20 SetParentColor
4.2.2.21 SetColorOfAttributes
4.2.2.22 ResetColorOfAttributes
4.2.2.23 SetParentColorOfAttributes
4.2.2.24 EnableControls
4.2.2.25 DisableControls
4.2.2.26 ControlsDisabled
4.2.2.27 EnableScreenControls
4.2.2.28 DisableScreenControls
4.2.2.29 ScreenControlsDisabled
4.2.2.30 SetFocus
4.2.2.31 DisplayFormat
4.2.2.32 AttributeHint
4.2.2.33 ResetAttributeHint
4.2.2.34 AttributeLabel
4.2.2.35 PlacerStrategy
4.2.2.36 MaxSpaceForControlsPerc
4.2.2.37 GoToLayerPage
4.2.2.38 GoToMapPage
4.2.2.39 IsLayerPageOnTop
4.2.2.40 TabVisible
4.2.2.41 LayerPageVisible
4.2.2.42 StemProfilePageVisible
4.2.2.43 ShowInSeparateWindow
4.2.2.44 ShowThumbnailPreview
4.2.2.45 LayerVisible
4.2.2.46 LabelsVisible
4.2.2.47 AlwaysColored
4.2.2.48 SaveMiscTreeDataToXML
4.2.2.49 ShowVirtualKeyboard
4.2.2.50
4.2.2.51
4.2.2.52
4.2.2.53
4.2.2.54
4.2.2.55
4.2.2.56
4.2.2.57
4.2.2.58
4.2.2.59
4.2.2.60
4.2.2.61
4.2.2.62
4.2.2.63
4.2.2.64
4.2.2.65
4.2.2.66
4.2.2.67
4.2.3 Database
4.2.3.1 Value
4.2.3.2 ValueAsString
4.2.3.3 ValueAsinteger
4.2.3.4 ValueAsFloat
4.2.3.5 ValueAsboolean
4.2.3.6 OldValue
4.2.3.7 PreviousValue
4.2.3.8 BOF
4.2.3.9 EOF
4.2.3.10 RecordCount
4.2.3.11 State
4.2.3.12 SetValues
4.2.3.13 SetValuesFromXML
4.2.3.14 CrownProjection
4.2.3.15 CrownProfile
4.2.3.16 CrownProfilePoints
4.2.3.17 StemProfile
4.2.3.18 OldLayer
4.2.3.19 SavePosition
4.2.3.20 RestorePosition
4.2.3.21 SaveState
4.2.3.22 RestoreState
4.2.3.23 SavePositionAndState
4.2.3.24 RestorePositionAndState
4.2.3.25 Open
4.2.3.26 Close
4.2.3.27 First
4.2.3.28 Last
4.2.3.29 Next
4.2.3.30 Prior
4.2.3.31 Edit
4.2.3.32 Post
4.2.3.33 Append
4.2.3.34 Delete
4.2.3.35 Cancel
4.2.3.36 Refresh
4.2.3.37 Locate
4.2.3.38 ClearTable
4.2.3.39 Filter
4.2.3.40 Filtered
4.2.3.41 CheckFilter
4.2.3.42 SetFilterExt
4.2.3.43 ClearFilterForChildLayers
4.2.3.44 DeepFilter
4.2.3.45 EnableCachedUpdates
4.2.3.46 ApplyUpdates
4.2.3.47 GetAttributeValue
4.2.3.48 GetQueryResult
4.2.3.49 DeleteFrom
4.2.3.50 Update
4.2.3.51 CreateMemTable
4.2.3.52 SaveToDBF
4.2.3.53 SaveToExcel
4.2.3.54 GetMinOfAttributeValues
4.2.3.55 GetMaxOfAttributeValues
4.2.3.56 GetMeanOfAttributeValues
4.2.3.57 GetSumOfAttributeValues
4.2.3.58 GetRecordCount
4.2.3.59 GetLookupTable
4.2.3.60 GetLookupListValue
4.2.3.61 GetLookupListAttributeValue
4.2.3.62 GetID
4.2.3.63 GetIdAttributeName
4.2.3.64 GetIdSQL
4.2.3.65 SaveTimeStamp
4.2.3.66 File2Blob
4.2.3.67 Blob2Folder
4.2.3.68 String2Blob
4.2.3.69 Blob2String
4.2.3.70 FillAttributeValues
4.2.3.71 MarkValuesAsConditional
4.2.3.72 RoundAttributeValues
4.2.3.73 GetPercentageOfFilledAttributes4Table
4.2.3.74 GetPercentageOfFilledAttributes4Record
4.2.3.75 GetListOfChildLayers
4.2.4 XML
4.2.4.1 AddDataToXML
4.2.4.2 GetRecordAsXML
4.2.4.3 GetRecordsAsXML
4.2.4.4 GetLookupListContentAsXML
4.2.4.5 GetLookupListsContentAsXML
4.2.5 GIS
4.2.5.1 GisLayerReference
4.2.5.2 ShapeRecordCount
4.2.5.3 GetParentPolygonArea_m2
4.2.5.4 FindIntersectingPolygons
4.2.5.5 GetIntersectingPolygonAreas
4.2.5.6 FindContainedPointsOrCentroids
4.2.5.7 FindLinesIntersectingPolygon
4.2.5.8 FindLinesContainedInExpandedPolygon
4.2.5.9 FindClosestLine
4.2.5.10 FindPolygonContainingPoint
4.2.5.11 FindPolygonContainingPointByCoords
4.2.5.12 AddPoint
4.2.5.13 AddLine
4.2.5.14 AddPolygon
4.2.5.15 AddCentroid
4.2.5.16 AddPolygonWithCentroid
4.2.5.17 AddCircularPolygonWithCentroid
4.2.5.18 SplitMultiPolygon
4.2.5.19 DeletePoint
4.2.5.20 DeleteLine
4.2.5.21 DeletePolygon
4.2.5.22 DeletePolygonsKeepCentroidsAndAttributes
4.2.5.23 SaveShapesToBlobs
4.2.5.24 UpdateSymbolAndLabelInShapefiles
4.2.5.25 CreatePointsAlongLine
4.2.5.26 RefreshMap
4.2.5.27 RefreshMapRectangle
4.2.5.28 ZoomAndSelect
4.2.5.29 ZoomAndSelectEntity
4.2.5.30 SelectEntities
4.2.5.31 ZoomToLayerExtent
4.2.5.32 MeasureLineLength_m
4.2.5.33 MeasurePolygonArea_m2
4.2.5.34 GetLineCoordinates
4.2.5.35 GetPolygonCoordinates
4.2.5.36 GisEntityExists
4.2.5.37 GetCombinedPolygonsCoordinates
4.2.5.38 SelectLine
4.2.6 Navigator & DQT
4.2.6.1 AddItemToNavigatorXML
4.2.6.2 DBNavigatorVisible
4.2.6.3 DBNavigatorConfirmDelete
4.2.6.4 QueryBuilderEnabled
4.2.6.5 EnableQueryBuilder
4.2.6.6 DisableQueryBuilder
4.3 TableWrapper
4.3.1 Shared Layer members
4.3.2 Unique Table members
4.3.2.1 FieldExists
4.3.2.2 RecNo
4.3.2.3 IsTableOpen
4.3.2.4 AsXML
4.3.2.5 SaveToDbfExt
4.3.2.6 AlterTable
4.3.2.7 DisplayLabel
4.3.2.8 BlobAsString
4.4 Project
4.4.1 Basic
4.4.1.1 Name
4.4.1.2 DatabaseType
4.4.1.3 Version
4.4.1.4 UserLoginFullName
4.4.1.5 UserLoginName
4.4.1.6 UserGroupName
4.4.1.7 LayerCount
4.4.1.8 Layer
4.4.1.9 GetMapLayerListAsXML
4.4.1.10 ActiveLayer
4.4.1.11 ActiveLayerName
4.4.1.12 LayerAtIndex
4.4.1.13 SysTab_LayerList
4.4.1.14 SysTab_AttributeList
4.4.1.15 GetMapLayerListAsXML
4.4.1.16 ApplyMapLayerList
4.4.1.17 LoadMapLayerListFromXML
4.4.1.18 SaveMapLayerListToXML
4.4.1.19 MapLayerListVisible
4.4.1.20 SendDataToAnotherRunningProject
4.4.1.21 GetResourceString
4.4.1.22 AnotherProjectIsRunning
4.4.1.23 OpenAnotherProject
4.4.1.24 BringProjectToFront
4.4.1.25 SendDataToAnotherRunningProject
4.4.1.26 OpenInactiveLayers
4.4.1.27 CloseInactiveLayers
4.4.1.28 OpenPlot
4.4.1.29 OpenPlotUsingDataCollector
4.4.1.30 RunPolyshape
4.4.1.31 AddLayerWrapper
4.4.1.32 ScriptsEnabled
4.4.1.33 OnValidateScriptsEnabled
4.4.1.34 OnChangeScriptsEnabled
4.4.1.35 OnChangeTimeStampEnabled
4.4.1.36 DisableScripts
4.4.1.37 EnableScripts
4.4.1.38 RunSynchronization
4.4.1.39 RunSynchronizationExt
4.4.1.40 AdjustOnLineCalliperConnection
4.4.1.41 Example
4.4.2 Screen
4.4.2.1 GoToLayerPage
4.4.2.2 IsLayerPageVisible
4.4.3 Files
4.4.3.1 DeleteFile
4.4.3.2 CreateDir
4.4.3.3 DeleteDir
4.4.3.4 GetFilesOfDir
4.4.3.5 OpenFileByWindowsAssociation
4.4.3.6 SaveStringToIniFile
4.4.3.7 SaveIntegerToIniFile
4.4.3.8 SaveDoubleToIniFile
4.4.3.9 SaveBooleanToIniFile
4.4.3.10 LoadStringFromIniFile
4.4.3.11 LoadIntegerFromIniFile
4.4.3.12 LoadDoubleFromIniFile
4.4.3.13 LoadBooleanFromIniFile
4.4.3.14 ExtractFilename
4.4.3.15 ExtractFilePath
4.4.3.16 ExtractFileExt
4.4.3.17 FileExists
4.4.3.18 DirectoryExists
4.4.4 Database
4.4.4.1 Refresh
4.4.4.2 EnableCachedUpdates
4.4.4.3 ApplyUpdates
4.4.4.4 StartTransaction
4.4.4.5 Commit
4.4.4.6 CommitRetaining
4.4.4.7 Rollback
4.4.4.8 RollbackRetaining
4.4.4.9 ClearAllFilters
4.4.4.10 GetQueryResult
4.4.4.11 PerformQuery
4.4.4.12 OpenTable
4.4.4.13 SaveRecordToDeletedLog
4.4.4.14 SaveRecordsToDeletedLog
4.4.4.15 BackupDatabase
4.4.4.16 PostAllData
4.4.4.17 ReloadLookupLists
4.4.4.18 PostProjectAndLookupTablesToSynchroJournal
4.4.4.19 PostLookupTablesToSynchroJournal
4.4.4.20 PostSelectedLookupTablesToSynchroJournal
4.4.4.21 PostFileToSynchroJournal
4.4.4.22 ChangedAfterLastSynchronization
4.4.5 Navigator & DQT & Extensions
4.4.5.1 RunFieldMapExtension
4.4.5.2 HideExtensionMenu
4.4.5.3 ShowExtensionMenu
4.4.5.4 RunDatabaseQueryTool
4.4.5.5 ShowExcelPreview
4.4.5.6 AddItemToNavigatorXML
4.4.5.7 DBNavigatorVisible
4.4.5.8 DBNavigatorConfirmDelete
4.4.5.9 GetSpeciesGroupID
4.4.6 GIS
4.4.6.1 GetPolygonIntersectArea_m2
4.4.6.2 OverlayPolygonLayers
4.4.6.3 TransferAttributeValuesFromPolygonsToPointsOrCentroids
4.4.6.4 GetPoint
4.4.6.5 GetCentroids
4.4.6.6 DrawText
4.4.6.7 DrawPoint
4.4.6.8 DrawLine
4.4.6.9 DrawPolygon
4.4.6.10 DrawCircle
4.4.6.11 DrawRectangle
4.4.6.12 FlashPolygon
4.4.6.13 FlashLine
4.4.6.14 FlashPoint
4.4.6.15 SelectedPointCount
4.4.6.16 SelectedPointID
4.4.6.17 SelectedLineCount
4.4.6.18 SelectedLineID
4.4.6.19 GetCurrentPosition
4.4.6.20 SetCurrentPosition
4.4.6.21 SetBasicExtent
4.4.6.22 GetMapExtent
4.4.6.23 GetMapFullExtent
4.4.6.24 GetBasicExtent
4.4.6.25 ZoomToPolygon
4.4.6.26 ZoomToLine
4.4.6.27 MapExtentAsVariant
4.4.6.28 AddReferencePoint
4.4.6.29 InvertColors
4.4.6.30 FindTargetHeight
4.4.6.31 SetCircularPlotBoundary
4.4.6.32 TrimLineByPlotBoundary
4.4.6.33 RefreshMap
4.4.6.34 RefreshMapRectangle
4.4.6.35 RefreshTrackingLayer
4.4.6.36 RefreshTrackingLayerRectangle
4.4.6.37 ScreenMilimeters2MapDistance_m
4.4.6.38 MapToScreen
4.4.6.39 SaveShapesToBlobs
4.4.6.40 SaveShapesOfCurrentPlotToBlobs
4.4.6.41 SaveShapesOfAllPlotsToBlobs
4.4.6.42 ProjectionToWGS84
4.4.6.43 WGS84ToProjection
4.4.6.44 AdjustLineIntersectCoordinates
4.4.7 Extras
4.4.7.1 EditSpeciesGroups
4.4.7.2 EditSpeciesGroupsUsingDesigner
4.4.7.3 ShowHeightCandidates
4.4.8 Stem profile
4.4.8.1 LoadGlobalStemProfileModels
4.4.8.2 LoadGlobalStemProfileModelsForRegion
4.4.8.3 GlobalStemProfileModelsFilename
4.4.8.4 FreeGlobalStemProfileModels
4.5 Lists
4.5.1 StringList
4.5.1.1 Free
4.5.1.2 Duplicates
4.5.1.3 Sorted
4.5.1.4 CaseSensitive
4.5.1.5 BeginUpdate
4.5.1.6 EndUpdate
4.5.1.7 Add
4.5.1.8 AddStrings
4.5.1.9 Assign
4.5.1.10 Clear
4.5.1.11 Delete
4.5.1.12 Count
4.5.1.13 Exchange
4.5.1.14 Move
4.5.1.15 Find
4.5.1.16 IndexOf
4.5.1.17 Insert
4.5.1.18 Sort
4.5.1.19 LoadFromFile
4.5.1.20 SaveToFile
4.5.1.21 Strings
4.5.1.22 Text
4.5.1.23 Delimiter
4.5.1.24 DelimitedText
4.5.1.25 NameValueSeparator
4.5.1.26 IndexOfName
4.5.1.27 Name
4.5.1.28 Value
4.5.1.29 AsVarArray
4.5.2 IntegerList
4.5.2.1 Free
4.5.2.2 Add
4.5.2.3 Clear
4.5.2.4 Assign
4.5.2.5 Delete
4.5.2.6 Count
4.5.2.7 IndexOf
4.5.2.8 SortAscending
4.5.2.9 SortDescending
4.5.2.10 SortAscendingAndRemoveDuplicates
4.5.2.11 Value
4.5.2.12 Delimiter
4.5.2.13 DelimitedText
4.5.2.14 AsVarArray
4.5.3 VariantList
4.5.3.1 Free
4.5.3.2 Add
4.5.3.3 Clear
4.5.3.4 Assign
4.5.3.5 Delete
4.5.3.6 Count
4.5.3.7 IndexOf
4.5.3.8 Value
4.5.3.9 ValueAsFloat
4.5.3.10 ValueAsInteger
4.5.3.11 ValueAsString
4.5.3.12 AsVarArray
4.5.3.13 SortAscendingAndRemoveDuplicates
4.5.3.14 Delimiter
4.5.3.15 DelimitedText
4.5.4 MultiVariantList
4.5.4.1 Free
4.5.4.2 Add
4.5.4.3 Clear
4.5.4.4 Assign
4.5.4.5 Delete
4.5.4.6 Count
4.5.4.7 NumberOfVariantsPerItem
4.5.4.8 AsText
4.5.4.9 Value
4.5.4.10 ValueAsFloat
4.5.4.11 ValueAsInteger
4.5.4.12 ValueAsString
4.5.4.13 SortAscending
4.5.4.14 SortDescending
4.5.4.15 SortMultiAscending
4.5.4.16 SortMultiDescending
4.5.4.17 IndexOf
4.5.4.18 IndexOfMulti
4.5.5 VarVariantList
4.5.5.1 Free
4.5.5.2 ListCount
4.5.5.3 ValueCount
4.5.5.4 AddList
4.5.5.5 Clear
4.5.5.6 Assign
4.5.5.7 List
4.5.5.8 Value
4.5.5.9 ValueAsFloat
4.5.5.10 ValueAsInteger
4.5.5.11 ValueAsString
4.5.6 ObjectList
4.5.6.1 Free
4.5.6.2 Clear
4.5.6.3 OwnsObjects
4.5.6.4 Count
4.5.6.5 Add
4.5.6.6 Item
4.6 ExcelWrapper
4.6.1 Managing files
4.6.1.1 CreateFile
4.6.1.2 OpenFile
4.6.1.3 FileName
4.6.1.4 CloseAndSave
4.6.1.5 Save
4.6.1.6 OpenInExcel
4.6.1.7 ShowExcelPreview
4.6.2 Setting / getting cell values
4.6.2.1 SetValue
4.6.2.2 SetValueAndMerge
4.6.2.3 SetFormula
4.6.2.4 GetCellValue
4.6.2.5 AddImage
4.6.2.6 AddImageExt
4.6.2.7 SetHTML
4.6.2.8 SetHTMLAndMerge
4.6.3 Formatting cells
4.6.3.1 FillColor
4.6.3.2 MergeCells
4.6.3.3 SetTextOrientation
4.6.3.4 Align
4.6.3.5 DrawBorders
4.6.3.6 FormatCells
4.6.3.7 AddUserFormat
4.6.3.8 AutofitCol
4.6.3.9 AutofitRow
4.6.3.10 SetOptimalColWidth
4.6.3.11 SetColWidth
4.6.3.12 SetDefaultColWidth
4.6.3.13 SetRowHeight
4.6.3.14 SetDefaultRowHeight
4.6.3.15 SetColWidth_mm
4.6.3.16 SetRowHeight_mm
4.6.3.17 GetTextWidth
4.6.3.18 GetTextHeight
4.6.3.19 GetCellWidth
4.6.4 Managing page layout
4.6.4.1 Landscape
4.6.4.2 SetPaperSize
4.6.4.3 SetPrintArea
4.6.4.4 SetPrintMargins
4.6.4.5 SetHeader
4.6.4.6 SetFooter
4.6.4.7 SetHeaderAndFooter
4.6.4.8 SetFirstHeaderAndFooter
4.6.4.9 SetTitleRows
4.6.4.10 SetTitleRowsAndCols
4.6.4.11 InsertHPageBreak
4.6.4.12 InsertVPageBreak
4.6.4.13 CreateHeaderOfTableContent
4.6.4.14 CreateTableOfContent
4.6.4.15 AddBackToTableOfContent
4.6.4.16 RowCount
4.6.4.17 ColCount
4.6.4.18 Header and footer codes
4.6.4.19 Predefined paper sizes
4.6.4.20 HeaderAndFooterExample
4.6.4.21 KeepColsTogether
4.6.4.22 KeepRowsTogether
4.6.4.23 AutoPageBreaks
4.6.4.24 PrintNumberOfHorizontalPages
4.6.4.25 PrintNumberOfVerticalPages
4.6.4.26 PrintToFit
4.6.5 Managing worksheets
4.6.5.1 AddSheet
4.6.5.2 MakeSheetActive
4.6.5.3 ClearSheet
4.6.6 ExcelWrapperExample
4.7 PointWrapper
4.7.1 Create
4.7.2 Free
4.7.3 ID
4.7.4 X
4.7.5 Y
4.7.6 ShiftAndRotate
4.8 PointsWrapper
4.8.1 AddPoint
4.8.2 PointCount
4.8.3 Point
4.8.4 ClearPoints
4.9 LineWrapper
4.9.1 Create
4.9.2 Free
4.9.3 ID
4.9.4 AddPoint
4.9.5 AddPoint3D
4.9.6 ClearPoints
4.9.7 PointX
4.9.8 PointY
4.9.9 PointZ
4.9.10 Length
4.9.11 GetParallelLine
4.9.12 LoadFromPolygon
4.9.13 CreatePointsAlongLine
4.9.14 PointCount
4.9.15 FindClosestPoint
4.9.16 FindPointsWithinDistance
4.9.17 CloseLine
4.10 PolygonWrapper
4.10.1 Create
4.10.2 Free
4.10.3 ID
4.10.4 AddRing
4.10.5 AddPointToRing
4.10.6 LoadFromVarArray
4.10.7 AddPolygon
4.10.8 Ring
4.10.9 RingRotation
4.10.10 RingCount
4.10.11 MainRingCount
4.10.12 PointCount
4.10.13 TotalPointCount
4.10.14 PointX
4.10.15 PointY
4.10.16 Area
4.10.17 AreaOfSimplePolygons
4.10.18 PointInPolygon
4.10.19 CreateCircle
4.10.20 CoordinatesAsText
4.10.21 CreateSamplePoints
4.10.22 CreateCentroids
4.11 SpeciesGroups
4.11.1 Create
4.11.2 Free
4.11.3 Assign
4.11.4 SpeciesLookupTableName
4.11.5 LoadFromTable
4.11.6 SaveToTable
4.11.7 LoadFromXML
4.11.8 SaveToXML
4.11.9 GetSpeciesCompositionInfo
4.11.10 UpdateSpeciesGroupsLookupList
4.11.11 PublishClassificationToMemTable
4.11.12 EditClassification
4.11.13 ID
4.11.14 Name
4.11.15 FullName
4.11.16 SpecGroupsCount
4.11.17 SpecGroupName
4.11.18 SpecGroupFullName
4.11.19 SpeciesListForGroup
4.11.20 SpecGroupID
4.11.21 SpecGroupIDForSpecies
4.11.22 ClassifyTable
4.11.23 ClassifyLayerUsingSQL
4.11.24 UngroupedSpeciesCount
4.12 StemProfile
4.12.1 Free
4.12.2 Assign
4.12.3 ClearContent
4.12.4 ResetData
4.12.5 ID
4.12.6 SpeciesCode
4.12.7 SpeciesName
4.12.8 DBH_mm
4.12.9 TreeHeight_m
4.12.10 AddPoint
4.12.11 DeletePointAtHeight
4.12.12 DeletePointsBelowHeight
4.12.13 AddTop
4.12.14 ResetStemBaseAndTop
4.12.15 Count
4.12.16 SortByHeight
4.12.17 Diameter_mm
4.12.18 Height_m
4.12.19 Diameter2_mm
4.12.20 SD_m
4.12.21 Ticks
4.12.22 LoadBarkThicknessXML
4.12.23 LoadParametersFromStandModelXML
4.12.24 CalcD03FromStandModelXML
4.12.25 GetModelTypeFromStandModelXML
4.12.26 LoadDataFromXML
4.12.27 ExportStemPointsToXML
4.12.28 ApplyGlobalModel
4.12.29 DiamForHeightByModel_mm
4.12.30 HeightForDiamByModel_m
4.12.31 RoughBarkHeight_m
4.12.32 DoubleBarkThickness_mm
4.12.33 RoughBarkSmoothTransition
4.12.34 StumpDiameter_mm
4.12.35 StumpHeightCalcMethod
4.12.36 StumpHeight_m
4.12.37 AddDiameterReduction
4.12.38 ResetDiameterReductions
4.12.39 SaveDiameterReductions
4.12.40 RestoreDiameterReductions
4.12.41 CumulativeDiameterReduction
4.12.42 ExpandStemDataByDiameterReductions
4.12.43 Volume_m3
4.12.44 TotalVolume_m3
4.12.45 StemVolume_m3
4.12.46 MerchantableVolume_m3
4.12.47 ParametrizeModel
4.12.48 ModelAvailable
4.12.49 Param
4.12.50 AdjustForKnownVolume
4.12.51 AdjustForKnownMerchantableVolume
4.12.52 ShowStemProfile
4.12.53 ShowStemProfileComaprison
4.12.54 ShowStemProfileWithPoints
4.12.55 ShowStemProfileExt
4.12.56 RecalcDiametersUsingCurrentDendroscope
4.13 VolumeModelsWrapper
4.13.1 Create
4.13.2 Free
4.13.3 LoadFromXML
4.13.4 UseSpeciesGroups
4.13.5 Volume_m3
4.14 AttribDefsWrapper
4.14.1 Create
4.14.2 Free
4.14.3 AddAttributeDefAndValueFromFieldMapAttribute
4.14.4 AddAttributeDefAndValueFromFieldMapAttributeExt
4.14.5 AddAttributeByValue
4.14.6 AttributeLabel
4.14.7 AttributeType
4.14.8 AttributeRequired
4.14.9 AttributeVisible
4.14.10 AttributeValue
4.14.11 AttributeDefaultValue
4.14.12 AttributeExists
4.14.13 PrintAttributes
4.14.14 PrintAttributesCount
4.14.15 PrintAttribute
4.14.16 LoadFromXML
4.14.17 AsXML
4.14.18 ValuesHaveChanged
4.14.19 RenameAttribute
4.15 ValueDialogWrapper
4.15.1 Create
4.15.2 Free
4.15.3 AddHeader
4.15.4 AddInteger
4.15.5 AddFloat
4.15.6 AddString
4.15.7 AddLookupList
4.15.8 AddDate
4.15.9 InputValues
4.15.10 Value
4.15.11 ValueByLabel
4.16 ReclassificationWrapper
4.16.1 Create
4.16.2 Free
4.16.3 LoadClassification
4.16.4 RaiseExceptionOnMissingClass
4.16.5 ReclassifiedValue
4.16.6 ReclassifyTable
5. Data types
5.1 Basic data types
5.2 Structured data types
5.3 Variant types constants
6. Tutorial
6.1 Working with Field-Map data – scan and locate table records
6.2 Handling exceptions
6.3 Working with Field-Map data – using SQL queries
6.4 Parameterize regression models
6.5 Show diameter distribution
6.6 Grouping species
6.7 Working with Log window
6.8 Management of screen interface
About
About Field-Map script
Blob
Button
Calliper
Database
MyTest2
DisableEvents variable
GIS
Global scripts
Hot keys
Layer scripts
Log
Measurement
MyTest1
On-Change scripts
On-Demand scripts
On-Validate scripts
Project variable
ProjectDir variable
ProjectName variable
Query
Record
Script
ScriptResult variable
Species
Stem
TAttribDefsWrapper
TExcelWrapper
TIntegerListWrapper
TLayerWrapper
TLineWrapper
TMultiVariantListWrapper
TObjectListWrapper
TPointWrapper
TPolygonWrapper
TProjectWrapper
TScriptOrganizer
TSpeciesGroupsWrapper
TStemProfileWrapper
TStringListWrapper
TTableWrapper
TVariantListWrapper
TVarVariantListWrapper
TVolumeModelsWrapper
TXMLOutputWrapper
ValidationFailedMessageText variable
Writing scripts
Functions, procedures and properties
>
ExcelWrapper
>
Managing worksheets
4.6.5 Managing worksheets
Managing worksheets
In this chapter:
AddSheet
MakeSheetActive
ClearSheet