Project

General

Profile

Actions

Bug #2773

closed

function attempt to update nulls badly

Added by Michael Lee almost 16 years ago. Updated almost 16 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 "...

Actions #1

Updated by Michael Lee almost 16 years ago

better yet, If Not IsNull(!ObsBasalArea) Then

doens't even run sql if null then.

Actions #2

Updated by Redmine Admin over 9 years ago

Original Bugzilla ID was 2773

Actions

Also available in: Atom PDF