Project

General

Profile

Bug #3298

Entry fields overlapping on level 1 plots, if level 3 plots are added first

Added by Michael Lee over 12 years ago. Updated over 12 years ago.

Status:
Resolved
Priority:
Normal
Assignee:
Category:
EntryDB
Target version:
Start date:
05/15/2008
Due date:
% Done:

0%

Estimated time:
Bugzilla-Id:
3298

Description

This is the strangest error I've seen that I've been able to fix on a database. If you added a level 3 plot first in a list of plots, when you go to the level 1 plot, some fields on the plot data form overlap, where the size and modules of a plot are specified.

It turns out that some SQL was executing that used a field that was in the main form currently active rather than the correct field. It was accidentally mistyped in the SQL but found a place to read from.

Incorrect SQL:
DoCmd.RunSQL "update observation set entry_plotLayoutType=IIf([cvs_Level]<3,1,3) where entry_plotLayoutType is null;"

correct SQL:
DoCmd.RunSQL "update observation set entry_plotLayoutType=IIf([cust_cvs_samplingLevel]<3,1,3) where entry_plotLayoutType is null;"

History

#1 Updated by Michael Lee over 12 years ago

Fixed, release candidate 3., v224

#2 Updated by Michael Lee over 12 years ago

also fixed in v226_mid2

#3 Updated by Redmine Admin over 7 years ago

Original Bugzilla ID was 3298

Also available in: Atom PDF