|
GSAK (Geocaching Swiss Army Knife)
|
|
SQLiteCaches [<Scope=All|Filter>] This new command will "synchronize" your current caches table and create a corresponding "caches" table in the SQLite database (complete with index on "code"). You may view it as similar to doing a DbToSqLite() and selecting all the possible fields - but this command is a simple one liner that will be optimized for speed and the corresponding table is always created in the GSAK database (not a user created one). This would then allow you to do comprehensive sql queries in the macro language or SQLiteSpy. Scope: All - All records in the GSAK table are generated Filter - Only your current filter of records is generated (default) You can leave out the Scope parameter, which causes the default of "Filter" to be used. Note1: This command was created as a "fill in" until the caches table is available live (more information) Note2: This command also creates a view called "CachesAll" which includes all memo fields. Use this vew in your SQL if you need to access memo fields ($d_UserNote, $d_LongDescription, $d_ShortDescription, $d_TravelBugs, $d_Hints, $d_Url) |
|
Copyright 2004-2008 CWE Computer Services Privacy Policy Contact |