Row_ID(n)

Please do not use to report errors- use your regional help desk.
Please mark posts as being for RPG or RDMLX (LANSA) developer.
To subscribe by email, display this forum, scroll to the end and select ‘Subscribe Forum’.
Post Reply
soapagent
Posts: 93
Joined: Mon Jul 16, 2012 6:19 pm

Row_ID(n)

Post by soapagent »

I am setting row id values in a table to store key values.

#COM_OWNER.Set_Table Name(tabMarkEdit) Row_N(#x) Row_Id_N(1) Row_Id(#SHTID.AsString)
#COM_OWNER.Set_Table Name(tabMarkEdit) Row_N(#x) Row_Id_N(2) Row_Id(#quesp.AsString)

I need to read through the whole table on submission but I can't see how to retrieve the row_id data.


#COM_OWNER.Get_SharedStateNum Variablename('SHTID_CT') Value(#SHTID_CT)
#COM_OWNER.Get_SharedStateNum Variablename('STDID_CT') Value(#STDID_CT)
#COM_OWNER.Get_SharedState Variablename('CLASS_CT') Value(#CLASS_CT)

#lastmark := *blank
#laststd := *blank

* Execute Subroutine(loadquest)

#COM_OWNER.Using Element('/Form.fields.' + 'MarkEdit' + '.fields')

#COM_OWNER.Get_Table Tablename(tabMarkEdit) Rowcount(#LISTCOUNT)

Begin_Loop Using(#x) From(2) To(#LISTCOUNT)

#COM_OWNER.Get_TextBox Name(tabMarkEdit + '.Row%' + #x.AsString + '.NewMark') Value(#MARKIN)

#COM_OWNER.Get_Table Tablename(tabMarkEdit) Currentrowid(#WRK2A) Row_Id_N(1)
#COM_OWNER.Get_Table Tablename(tabMarkEdit) Currentrowid(#WRK3A) Row_Id_N(2)

returns nothing and the documentation seems to say that CurrentRowId is only set when an entry is touched.

What have I missed?



The documenta
Paul

Re: Row_ID(n)

Post by Paul »

Row IDs are available to be read row by row if the Table contains input capable elements.

Try something like this;

Code: Select all

* Read through all the entries in Table 1, getting the Row IDs
Begin_Loop Using(#uEntry) To(#RowCount)

#TableRow := 'Table1.Row%' + #uEntry.AsString

#COM_OWNER.Get Property(#TableRow + '.ID%1') Into(#RowID1)
#COM_OWNER.Get Property(#TableRow + '.ID%2') Into(#RowID2)

* Do something with #RowID1 and #RowID2

End_Loop

soapagent
Posts: 93
Joined: Mon Jul 16, 2012 6:19 pm

Re: Row_ID(n)

Post by soapagent »

Thanks that worked.
Post Reply