Geo

Takes nine parameters, FieldBase, Destination, Function, Source1, Source2, Source3, Source4, Options, IfLenFld

Usage:

FieldBase, Destination, Function, Source1, Source2, Source3, Source4, Options, IfLenFld
[WorkWith], Destination, Function, Source1, Source2, Source3, Source4, Options, [""]
[WorkWith], Destination, Function, Source1, Source2, Source3, [""], Options, [""]
[WorkWith], Destination, Function, Source1, Source2, [""], [""], Options, [""]
[WorkWith], Destination, Function, Source1, [""], [""], [""], Options, [""]
[WorkWith], Destination, Function, Source1, [""], [""], [""], [""], [""]
FieldBase, Destination, Function, Source1, Source2, Source3, Source4, Options, [WorkIf]
[WorkWith], Destination, Function, Source1, Source2, Source3, Source4, Options, [WorkIf]
[WorkWith], Destination, Function, Source1, Source2, Source3, [""], Options, [WorkIf]
[WorkWith], Destination, Function, Source1, Source2, [""], [""], Options, [WorkIf]
[WorkWith], Destination, Function, Source1, [""], [""], [""], Options, [WorkIf]
[WorkWith], Destination, Function, Source1, [""], [""], [""], [""], [WorkIf]

Description:

An optimized way to perform geographic calculations in bulk on multiple records simultaneously.

Evaluates the Function and places the requested value into the Destination Field.

List of Functions:

Note: This toolset has been designed for speed and simplicity over precision. All calculations performed are approximate and do not perfectly take into account the earth's geography.

Example:

LoadTable    "MemTab.Contact"
Children "Finance.LineItem"

NewFields "EstDistance"
Geo "EstDistance", "Distance", "MemTab.Contact.Lat", "MemTab.Contact.Long", "Finance.LineItem.Lat", "Finance.LineItem.Long", ""
KeepIf "EstDistance", ">>", 40 'KM