Kbase P62364: When using SQL-92, a record is inserted into a table and sub
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
13/01/2004 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1x
FACT(s) (Environment):
Using SQL-92 to insert records into a table
SYMPTOM(s):
When record is inserted into a table all records in the table are updated
There is a trigger defined to execute after each insert of a record into the table
CAUSE:
The Java insert trigger that is defined to execute after each insert of a record into the table executes a vanilla UPDATE TableName SET Field = Value statement. This UPDATE statement affects every record in the table.
FIX:
Modify the Java trigger so that it uses a prepared statement to update a single record (i.e. the record that was inserted)