Project

General

Profile

Actions

Bug #2760

open

add Quick fix for common errors

Added by Michael Lee about 17 years ago. Updated about 15 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.

Actions #1

Updated by Michael Lee about 17 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));

Actions #2

Updated by Michael Lee about 17 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));

Actions #3

Updated by Michael Lee about 17 years ago

back to new, not assigned

Actions #4

Updated by Michael Lee over 16 years ago

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

Actions #5

Updated by Redmine Admin about 11 years ago

Original Bugzilla ID was 2760

Actions

Also available in: Atom PDF