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

Also available in: Atom PDF