db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <rick.hille...@oracle.com>
Subject Re: Error code 42X05. Table doesn't exist.Pls help with code.
Date Mon, 27 Jun 2011 13:11:22 GMT
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
> ;


Mime
View raw message