Kbase P81589: SQL: Where does the first argument of the 'getValue' method of the NEWROW object in an SQL INSERT tr
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/05/2009 |
|
Status: Verified
GOAL:
SQL: Where does the first argument of the 'getValue' method of the NEWROW object in an SQL INSERT trigger come from?
GOAL:
Where does the col_num argument come from in SQL NEWROW object method 'getValue ( col_num , sql_data_type )'?
FACT(s) (Environment):
All Supported Operating Systems
DSA Categories
Progress 9.x
OpenEdge 10.x
FIX:
In the "getValue" for NEWROW (or OLDROW) object method, the "col_num" means the column number(1 oriented) in the row set of the table on which a Java row trigger is created with OLDROW or NEWROW for insert or update.
That is the columns are returned in the same order as when a SELECT * from pub.TableName is executed.