MacroDelete <Action=DelCurrent|DelScope|Commit>
The MacroDelete command now somewhat supersedes the Delete command and also enables you to delete records from the logs, waypoints, corrected and attributes tables
As the physical deleting of records is the "slow" part, this command is broken into two phases:
1. The flagging of records to delete (actions DelCurrent and DelScope)
2. The actual delete of those flagged records (action Commit)
This enables you to quickly flag records to delete, then finally do the physical delete to remove them when you are ready.
This command works on your currently active table, and "Action" has 3 possible values:
DelCurrent - Flag the current record for delete
DelScope - Flag all the records in the current scope for delete
Commit - Complete all flagged deletes. Note: Commit here relates specifically to this command only. That is, the physical update of the database is not actually done until the current transaction (if there is one) is committed.
As the "Caches" table does not really have a "scope" the use of DelScope when "Caches" is the active table, allows you to delete all records in your current subset/filter
Example 1 - Delete all child waypoints for the current cache
table active=waypoints scope=parent macrodelete action=delscope macrodelete action=commit |
Example 2 - Delete all child waypoints for a filter. In this example we use a Mfilter just for caches with "river" in the name
Mfilter where=Regex("river",name) If $_FilterCount > 0 While not($_eol) table active=waypoints scope=parent macrodelete action=delscope # don't do the commit here because there may be more to do table active=caches goto position=next endwhile # now the slow part - physically remove all the deleted child waypoints table active=waypoints scope=all macrodelete action=commit table active=caches # not really required here, but should be included if you have more code after the endif EndIf |
Example 3 - Delete all child waypoints in the current database:
table active=waypoints scope=all macrodelete action=delscope macrodelete action=commit |
Example 4 - Delete all Parking waypoints
table active=waypoints scope=all while not($_eol) if $d_cType = "Parking Area" MacroDelete action=DelCurrent endif Goto Position=Next EndWhile # now remove the flagged deletes MacroDelete action=commit |
Note1: When you use the actions DelScope or DelCurrent, you are only flagging the record for delete in memory. The actual delete is not performed until you issue a Commit for the corresponding table. If you end your macro without doing a Commit, your flagged deletes will be cleared from memory and lost - effectively changing nothing in your database.
For those familiar with database languages, consider this a type of "transaction" where the changes are all (commit used) or nothing (no commit)
You can use the commit action anytime before the macro ends to complete the transaction.
If you have uncommitted deletes for the caches table and another table(s), make sure you do the commit for the other tables first.
That is, when doing deletes to multiple tables, always issue the commit for the caches table last (the order between logs and waypoints does not matter)
Like the Delete command, the MacroDelete command also cascades deletes when you commit deletes to the caches table. That is, when a cache is removed from the database, all corresponding waypoints and logs are also removed.
Note2: when deleting logs, you should always follow up with the ResyncLogs command to make sure all log totals are correctly recalculated.
Also see the Delete command
Alpha List Category List