Project

General

Profile

Bug #2760

add Quick fix for common errors

Added by Michael Lee almost 12 years ago. Updated almost 10 years ago.

Status:
New
Priority:
Normal
Assignee:
Category:
EntryDB
Target version:
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.

History

#1 Updated by Michael Lee almost 12 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 almost 12 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 almost 12 years ago

back to new, not assigned

#4 Updated by Michael Lee over 11 years ago

milestone v206 is in the past, so moving these to v2.3

#5 Updated by Redmine Admin over 5 years ago

Original Bugzilla ID was 2760

Also available in: Atom PDF