Dear HBSMR users
Some time ago we announced that a patch for HBSMR v2.10 with a corrected version of the MonDCQry01 query was available for downloading from our web site.
This query is used from "Save Snapshot" on the Monument Index form, where it is titled "Dublin Core Mons01: Mon table".
The query can be used for providing data to ADS, or for general exporting purposes.
Unfortunately, there seems to have been an error in the process of uploading to our web site, and if you downloaded this patch it is possible that you got the wrong version again!
The correct patch is now definitely on our web site, and should be installed before using this functionality. If you do not install this patch, the old query may not output all your monument records correctly.
An alternative quicker method of installing the patch, for those System Administrators happy to change query designs manually, is to paste the following text into the SQL View of the MonDCQry01 query (replacing all the existing text). Make a backup copy first.
SELECT Mon.MonUID, Mon.Name AS DC_Title, Format(DMax("[ModDate]","AuditTrail","[Code] = '" & [Mon].[MonUID] & "' and [Type] = 'MON'"),"Medium Date") AS DC_Date_Updated
FROM Mon
ORDER BY Val(Mid([MonUID],3));
Please contact me if you want to discuss this.
Best wishes
Crispin
~~~~~~~~~~~~~~~~~~~~~
Crispin Flower
exeGesIS SDM Ltd.
Great House Barn
Talgarth
Powys
LD3 0AH
Tel: 01874 712145/711145
Fax: 01874 711156
email: [log in to unmask]
URL: www.esdm.co.uk
~~~~~~~~~~~~~~~~~~~~~
This E-mail and any files transmitted with it are private and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient, the E-mail and any files have been transmitted to you in error and any copying, distribution or other use of the information contained in them is strictly prohibited.
Nothing in this E-mail message amounts to a contractual or other legal commitment on the part of exeGesIS SDM Ltd unless confirmed by a signed communication.
exeGesIS SDM Ltd will make every effort to keep its network free of viruses. However, the recipient of this message will need to scan this message, and any attachments, for viruses, as exeGesIS SDM Ltd can take no responsibility for any computer virus that might be transferred by this e-mail.
|