getrow()

In most cases, you don;t need the actual row ID.
In most cases, the row_id is the same as the Row Number.

When people ask this, it's usually because the row_number abnd row_id are not matching up, and THAT is usually the result of deleting rows from a DW.
It gets worse when people are deleting rows from a DW from within a loop.

Why? because the row numbers change IMMEDIATELY after a row is deleted. If you have to 10 rows and delete row 7, the remaining rows are now 1,2,3,4,5,6,7,8,9. Row 8 becomes row 7, row 9 becomes row 8, and row 10 becomes row 9.

Whenever you delete rows in a loop be sure to do so in reverse row order. Example:

FOR ll_row = ll_rowcount to 1 STEP -1

   ll_rc = dw_1.DeleteRow (ll_row)

NEXT
 

Later -

Olan

What do you mean by 'actual row id'?  If this is just the row number within the results set in a dw you can use the previous answers given.  If you mean an internal identity type column then you need to retrieve that with your other data from the database.

Hi David.

Try this:

1- Create a dummy column in the datawindow (e.g. "Select 0 as c_rowid");

2- Place the code below on the RetrieveRow datawindow event:

This.Object.c_rowid[row] = This.GetRowIDFromRow(row)

Regards,

Luiz

Hi,

I hope this help you.

Some code

long ll_Row

Any value

ll_Row = dw_name.GetRow()

now you can use ll_Row

dw_name.DeleteRow(ll_Row) 

value = dw_name.object.col_name[index]

Inside of datawindows on a compute field

getrow()