Project

General

Profile

Actions
Copy link

Bug #2773

closed

function attempt to update nulls badly

Added by Michael Lee almost 18 years ago. Updated almost 18 years ago.

Status:
Resolved
Priority:
Normal
Assignee:
Michael Lee
Category:
EntryDB
Target version:
x2007-June
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
Copy link
 #1

Updated by Michael Lee almost 18 years ago

better yet, If Not IsNull(!ObsBasalArea) Then

doens't even run sql if null then.

Actions
Copy link
 #2

Updated by Redmine Admin over 11 years ago

Original Bugzilla ID was 2773

Actions
Copy link

Also available in: Atom PDF