Bug #2760
open
add Quick fix for common errors
Added by Michael Lee almost 18 years ago.
Updated almost 16 years ago.
Description
need a quick fix for longitude is positive
also for filling in default of 10cm for minimum stem size.
Fix negative long:
UPDATE observation SET observation.authorE = "-" & [authorE]
WHERE (((Left(Trim([authorE]),1))<>"-"));
Fix default size not filled in:
UPDATE entry_plots_stems SET entry_plots_stems.minimumHt = 10
WHERE (((entry_plots_stems.minimumHt) Is Null) AND ((entry_plots_stems.cvs_level)=2 Or (entry_plots_stems.cvs_level)=3));
fix no date in stems:
UPDATE entry_plots_stems INNER JOIN observation ON entry_plots_stems.plotID = observation.OBSERVATION_ID SET entry_plots_stems.[date] = [obsStartDate]
WHERE (((entry_plots_stems.date) Is Null));
back to new, not assigned
milestone v206 is in the past, so moving these to v2.3
Original Bugzilla ID was 2760
Also available in: Atom
PDF