The number of rows in a table is available for a field using the field's token. For instance, for a table with the token name EMPLOYEE, [REQD.P.EMPLOYEE] is the number of table entries. The value for the field NAME in the first table entry is [REQD.T.EMPLOYEE.TE="1".VP.NAME]. This works fine for getting values from multiple tables in the request. These are read-only tokens, though. They do not work with ksc_store, which is unfortunate.
This won' work either, the SQL condition will fail (or incorrect calculation) if table component have 2 or more rows with same employee name in [REQD.T.EMPLOYEE.TE="1".VP.NAME] field. (just an example).
Rigth now the only feasible solution, which currently I am using is
Create a Oracle sequence
On Table component CREATE event, poupulate the sequence in new ID coulmn (this will be always unique)
Now using this ID filed, I am identifying the correct TC row.
The only problem in this is that, I cannot hide it. Incase it is hidden then on REQUEST save, this field is set to NULL.
Cheers.. Utkarsh Mishra
-- Remember to give Kudos to answers! (click the KUDOS star)