Bug #2760
add Quick fix for common errors
0%
Description
need a quick fix for longitude is positive
also for filling in default of 10cm for minimum stem size.
History
#1 Updated by Michael Lee over 14 years ago
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));
#2 Updated by Michael Lee over 14 years ago
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));
#3 Updated by Michael Lee over 14 years ago
back to new, not assigned
#4 Updated by Michael Lee about 14 years ago
milestone v206 is in the past, so moving these to v2.3
#5 Updated by Redmine Admin over 8 years ago
Original Bugzilla ID was 2760