Update Records - Synonyms to accepted binomials

Please read the whole page before continuing.

This UPDATE query updates records where a synonym is recorded, with the current, accepted binomial. MapMate prefixes synonyms, which includes trinomials (subspecies, forms, varieties and aberrants), with '=' and refers the synonym to the binomial.

The query was tested on a database of 60,000+ records, and successfully updated 4 records that fitted the criteria.

The query will only update records owned by the current "Centre".

Only run this query if you are absolutely sure you wish to update all synonymised records with the accepted binomial.

Examples

=Apodia bifractella will be updated to Apodia martinii Dark Seedhead Moth.
=Xanthorhoe fluctuata fluctuata will be updated to Xanthorhoe fluctuata Garden Carpet.
=Allophyes oxyacanthae ab. capucina will be updated to Allophyes oxyacanthae Green-brindled Crescent.

You MUST ABSOLUTELY take a system backup via the replicator, or at the very least make a copy of your Records table in your My MapMate\Data\Records folder before running this query. If you choose to copy the Records table to "Records - Copy", it will be easy to revert it back to "Records", if required.

To create the new query:

Open the Analysis tab in MapMate and select User queries.
Double-click <new user query>.
Enter the new query name UPDATE Records - Synonyms to accepted binomials.
Overwrite the default query text with:

UPDATE Records INNER JOIN [Taxa\Default] ON Records.[*Taxon] = [Taxa\Default].[_guk] SET Records.[*Taxon] = [Taxa\Default].[**RefersTo], Records.[_gen] = -val([thisgen]) WHERE Records.[*Taxon] <> [Taxa\Default].[**RefersTo] AND Right(Records.[_guk], 3) = [thiscuk];

Save the new query.

The query requires no user parameters. When the query is run, you will be advised how many records are affected.

To confirm changes:

Select View, Species Checklist (or just type Ctrl-T).
Select the My Taxa tab.
Click on the binocular icon and type in the species name you wish to check and click OK.
In turn, right-click on the species binomial and synonym below it, and select Show records.
On occasion the query may not work. If the query has not made the changes, rerun the query.

You may need to rebuild your atlases to effect changes.