issue #24607: make sure we hit the proper error message

[xtuple] / enyo-client / extensions / source / purchasing / database / source / xt / trigger_functions / itemsrc_did_change.sql

diff --git a/enyo-client/extensions/source/purchasing/database/source/xt/trigger_functions/itemsrc_did_change.sql b/enyo-client/extensions/source/purchasing/database/source/xt/trigger_functions/itemsrc_did_change.sql
index a971185..253ea0e 100644 (file)
--- a/enyo-client/extensions/source/purchasing/database/source/xt/trigger_functions/itemsrc_did_change.sql
+++ b/enyo-client/extensions/source/purchasing/database/source/xt/trigger_functions/itemsrc_did_change.sql
@@ -2,7 +2,7 @@ create or replace function xt.itemsrc_did_change() returns trigger as $$
 /* Copyright (c) 1999-2014 by OpenMFG LLC, d/b/a xTuple.
    See www.xm.ple.com/CPAL for the full text of the software license. */
 
- if (NEW.itemsrc_vend_item_number.length === 0) {
+ if (!NEW.itemsrc_vend_item_number || NEW.itemsrc_vend_item_number.length === 0) {
    throw "Vendor Item Number is required."
  }