Return-Path: X-Original-To: apmail-db-derby-user-archive@www.apache.org Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 354BE4C3E for ; Mon, 27 Jun 2011 13:12:14 +0000 (UTC) Received: (qmail 84966 invoked by uid 500); 27 Jun 2011 13:12:12 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 84513 invoked by uid 500); 27 Jun 2011 13:12:11 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 84506 invoked by uid 99); 27 Jun 2011 13:12:11 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 27 Jun 2011 13:12:11 +0000 X-ASF-Spam-Status: No, hits=-1.5 required=5.0 tests=RCVD_IN_DNSWL_MED,SPF_PASS,UNPARSEABLE_RELAY,UPPERCASE_50_75 X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [148.87.113.121] (HELO rcsinet10.oracle.com) (148.87.113.121) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 27 Jun 2011 13:12:02 +0000 Received: from rtcsinet22.oracle.com (rtcsinet22.oracle.com [66.248.204.30]) by rcsinet10.oracle.com (Switch-3.4.4/Switch-3.4.2) with ESMTP id p5RDBef6009896 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK) for ; Mon, 27 Jun 2011 13:11:42 GMT Received: from acsmt357.oracle.com (acsmt357.oracle.com [141.146.40.157]) by rtcsinet22.oracle.com (8.14.4+Sun/8.14.4) with ESMTP id p5RDBd3k027169 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Mon, 27 Jun 2011 13:11:39 GMT Received: from abhmt110.oracle.com (abhmt110.oracle.com [141.146.116.62]) by acsmt357.oracle.com (8.12.11.20060308/8.12.11) with ESMTP id p5RDBXPG003991 for ; Mon, 27 Jun 2011 08:11:33 -0500 Received: from richard-hillegas-computer.local (/10.159.19.166) by default (Oracle Beehive Gateway v4.0) with ESMTP ; Mon, 27 Jun 2011 06:11:33 -0700 Message-ID: <4E08817A.2080801@oracle.com> Date: Mon, 27 Jun 2011 06:11:22 -0700 From: Rick Hillegas User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US; rv:1.9.2.13) Gecko/20101207 Thunderbird/3.1.7 MIME-Version: 1.0 To: Derby Discussion Subject: Re: Error code 42X05. Table doesn't exist.Pls help with code. References: <31936869.post@talk.nabble.com> In-Reply-To: <31936869.post@talk.nabble.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Source-IP: rtcsinet22.oracle.com [66.248.204.30] X-CT-RefId: str=0001.0A090206.4E08818E.00BE:SCFSTAT5015188,ss=1,re=-4.000,fgs=0 Can you share your schema and the error message you are seeing? That will help people advise you. Thanks, -Rick On 6/27/11 5:20 AM, IkeAbalogu wrote: > CREATE TRIGGER NEWBALANCE > AFTER INSERT ON APP.PRODUCTQUANTMONITOR > REFERENCING NEW AS NEWROW > FOR EACH ROW > UPDATE NEWROW SET PREVIOUS_BALANCE = > CASE > WHEN (SELECT COUNT (NEWROW.FK1_SUPPLYID) FROM APP.PRODUCTQUANTMONITOR) = 1 > THEN (SELECT QUANTITY FROM APP.PRODUCTSUPPLY WHERE SUPPLYID = > NEWROW.FK1_SUPPLYID) > ELSE (SELECT MIN(DISTINCT BALANCE) FROM PRODUCTQUANTMONITOR WHERE > FK1_SUPPLYID = NEWROW.FK1_SUPPLYID > AND TANKNUMBER = NEWROW.TANKNUMBER) > END > ;