Project

General

Profile

Bug #2773

function attempt to update nulls badly

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

Status:
Resolved
Priority:
Normal
Assignee:
Category:
EntryDB
Target version:
Start date:
02/12/2007
Due date:
% Done:

0%

Estimated time:
Bugzilla-Id:
2773

Description

these functions try to update nulls to values that can be null, throwing off the SQL:
sas_updateTaxonImportanceCalcFields
sas_updateObservation_calcFields

fix to this: "set field = " & nz(!someOtherField,"null") & " where "...

History

#1 Updated by Michael Lee over 12 years ago

better yet, If Not IsNull(!ObsBasalArea) Then

doens't even run sql if null then.

#2 Updated by Redmine Admin over 6 years ago

Original Bugzilla ID was 2773

Also available in: Atom PDF