db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Knut Anders Hatlen <knut.hat...@oracle.com>
Subject Re: Error code 42X05. Table doesn't exist.Pls help with code.
Date Mon, 27 Jun 2011 15:47:15 GMT
IkeAbalogu <ikeabalogu@hotmail.com> writes:

> Thanks.I see the error.I am updating newrow because it is the newly inserted
> row that the trigger will update its previousbalance column.I will try to
> come with a where statement to get to the newly inserted row.Your help will
> still be appreciated.

Perhaps you could add a primary key column to the PRODUCTQUANTMONITOR
table and use that column in a WHERE clause in the UPDATE statement? The
primary key could be automatically generated by Derby using an identity
column:

  CREATE TABLE PRODUCTQUANTMONITOR (
    ID INT PRIMARY KEY GENERATED ALWAYS AS IDENTITY,
    ...)

-- 
Knut Anders

Mime
View raw message