The following shooudl do what you require.
<?xml version="1.0" ?>
<batchupdate menupath="LcBatchUpdates" title="LCBU10- Change Confidential flag for selected taxa "
description="Changes the Confidential flag for all occurrences in the database for the selected taxa. Works on a taxon name entered or as a quick report from the Taxon Dictionary. Picks up synonyms etc. providing they are properly linked in name server " >
<SQL>
<Where keytype="Default">
UPDATE Taxon_Occurrence set
<Condition field= "Confidential" operator="equal" type="OptionSet" name="Set Confidential Equals" >
<Option name="True" value = "1" />
<Option name="False" value = "0" />
</Condition>
FROM Taxon_Determination TDET
INNER JOIN Taxon_Occurrence TOCC
ON TOCC.Taxon_Occurrence_key = TDET.Taxon_Occurrence_key AND TDET.Preferred = 1
INNER JOIN
Index_Taxon_name ITN ON ITN.Taxon_List_Item_Key = TDET.Taxon_List_Item_Key
INNER JOIN
Index_Taxon_Name ITN2 ON ITN2.Recommended_Taxon_List_Item_Key = ITN.Recommended_Taxon_List_Item_Key
WHERE
<Condition field="ITN2.Actual_Name" operator="equal" type="Text" name="Taxon Name" entrycount="1" />
</Where>
<Where keytype="Taxon">
UPDATE Taxon_Occurrence set
<Condition field= "Confidential" operator="equal" type="OptionSet" name="Set Confidential Equals" >
<Option name="True" value = "1" />
<Option name="False" value = "0" />
</Condition>
FROM Taxon_Determination TDET
INNER JOIN Taxon_Occurrence TOCC
ON TOCC.Taxon_Occurrence_key = TDET.Taxon_Occurrence_key AND TDET.Preferred = 1
INNER JOIN
Index_Taxon_name ITN ON ITN.Taxon_List_Item_Key = TDET.Taxon_List_Item_Key
INNER JOIN
Index_Taxon_Name ITN2 ON ITN2.Recommended_Taxon_List_Item_Key = ITN.REcommended_Taxon_List_Item_Key
WHERE
ITN2.Taxon_List_Item_key = '%s'
</Where>
</SQL>
</batchupdate>
Mike Weideli
