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 0c67bda..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
@@ -1,8 +1,8 @@
 create or replace function xt.itemsrc_did_change() returns trigger as $$
-/* Copyright (c) 1999-2013 by OpenMFG LLC, d/b/a xTuple.
+/* 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."
  }