Actions
Bug #2760
openadd Quick fix for common errors
Start date:
02/05/2007
Due date:
% Done:
0%
Estimated time:
Bugzilla-Id:
2760
Description
need a quick fix for longitude is positive
also for filling in default of 10cm for minimum stem size.
Updated by Michael Lee almost 18 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));
Updated by Michael Lee almost 18 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));
Updated by Michael Lee over 17 years ago
milestone v206 is in the past, so moving these to v2.3
Actions