TABLE <Active=caches|logs|waypoints|corrected> [<Scope=Parent|All|Same>]
The Table command allows you to select the current supported table in the macro language. There are 5 supported tables. Caches - The master for all "cache" data. Logs - All log entries associated with a cache. Waypoints - Any child waypoints associated with the cache. Corrected - All corrected coordinates. Attributes - the Groundspeak cache attributes.
Active - This parameter determines which table will be current for certain operations. Currently, this only applies to the GOTO command and the system variables $_EOL and $_Count. When a macro first starts, the default active table is "caches"
Scope - This parameter only applies to "waypoints", "logs", and "correct". All, means you have access to all the records in the table. Using a Goto Position=Top will take you to the very first record in the table. Goto Position=Bottom will take you to the very last record in the table. $_EOL is only set to true when you read past the very last record on the file. Parent, means you only have access to those records that belong to the parent. Goto Position=Top will take you to the first child of the parent, Goto Position=Bottom will take you to the last child of the parent. The "parent" is what ever record your "caches" table is currently set to. $_EOL is set to true when ever you try to read a child that does not belong to the current parent. If there are no child records $_EOL will be true, and $_Count equals 0. When you use the TABLE command with a scope of parent or all, you are immediately placed at the first record in that scope (same as if you issue the command Goto Position=Top). Same, (default value, so you can omit this parameter when requesting "same") enables you to set another table to be the active one, but not move the record pointer to the top. That is, the record pointer will be left on the same child record as before (as long as you haven't run another command that would cause the record pointer to move in the mean time)
For a complete list of database variables you can use for each TABLE see Database Variables
Example 1 - show the total number or records in each table
# default is "caches" so no need for TABLE command first $msg = "Total Caches = $_Count" + $_NewLine Table Active=Logs Scope=All $msg = $msg + "Total Logs = $_Count" + $_Newline Table Active=Waypoints Scope=All $msg = $msg + "Total child waypoints = $_Count" Pause Msg=$msg |
Example 2 - Flag only "parking area" for selection on GPSr send
Goto Position=top while not ($_eol) table active=waypoints scope=parent while not($_eol) if $d_cType = "Parking Area" $d_cFlag = True else $d_cFlag = False EndIf Goto Position=Next EndWhile Table active=caches Goto position=Next EndWhile Goto position=Top |
Example 3 - Set a filter on all caches that have only parking child waypoints
MacroFlag Type=Clear Range=All Goto Position=Top While not ($_eol) Table Active=Waypoints Scope=Parent while not ($_eol) if $d_cType = "Parking Area" $d_MacroFlag = True Break EndIf Goto Position=Next EndWhile Table Active=caches Goto position=Next EndWhile Mfilter Where=MacroFlag |
Alpha List Category List