Kbase P119002: SQL-92: Error (7587) creating an SQL-92 UPDATE event java
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
22/09/2006 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
Progress 9.1E
SYMPTOM(s):
SQL-92: Error (7587) creating an SQL-92 UPDATE event java
Syntax error (7587)
SQLState=42000
ErrorCode=-20003
[JDBC Progress Driver]:Syntax error (7587)
Executing SQL-92 code similar to:
CREATE TRIGGER PUB.UpdateCustomer
AFTER UPDATE OF Custnum, City, State, Country, PostalCode
ON PUB.Customer
REFERENCING NEWROW
FOR EACH ROW
IMPORT
import java.sql.Date ;
import java.math.BigDecimal ;
BEGIN
/* Other code goes here */
END
CAUSE:
The column list after the OF option should be parenthesized.
FIX:
Add parenthesis around the column list following the OF option:
CREATE TRIGGER PUB.UpdateCustomer
AFTER UPDATE OF (Custnum, City, State, Country, PostalCode, Balance)
ON PUB.Customer
REFERENCING NEWROW
FOR EACH ROW
IMPORT
import java.sql.Date ;
import java.math.BigDecimal ;
BEGIN
/* Other code goes here */
END