From 83116a281eae69d3f6e9a4b9882dbc30a724264c Mon Sep 17 00:00:00 2001 From: Steve Hackbarth Date: Mon, 29 Sep 2014 16:12:49 -0400 Subject: [PATCH] issue #24607: make sure we hit the proper error message --- .../database/source/xt/trigger_functions/itemsrc_did_change.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) 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 a971185de..253ea0e15 100644 --- 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." } -- 2.39.2