I'm working on a Recorder 6 database that has a few records with lower case letters in the grid reference of the sample. The records were imported from Excel using the import wizard when the database was at version 6.14.5.218. The database has since been updated to 6.18.1.260.
When the records are viewed using the GUI all appears fine the grid references are displayed with upper case letters, the anomaly only became apparent when using Mike's LCReturnEastingsV2 and LCReturnNorthingsV2 functions to export some records. When the records were plotted in GIS the records with the lower case letters were mapped thousands of miles off as the were allocated negative eastings and northings.
Two things
- Does it matter that some grid references are lower case - do any other database functions rely on upper case values?
If not, simply creating a copy of the above mentioned functions then adding 'set @SpatialRef = UPPER(@SpatialRef)' solves the problem.
If so I'll use:
then I'll run the update query on the SURVEY_EVENT and LOCATION tables
Have I missed any tables that might contain the imported grid ?
- can anyone confirm that lower case grid reference letters are converted to upper case by the current import wizard or is this issue something to watch for in the future?
Thanks
Ian