cancel
Showing results for 
Search instead for 
Did you mean: 

How to define the SI. No. for rows in matrix for the user defined form

Former Member
0 Kudos

Hi All,

Is there is any way to define the serial numbering for rows for a matrix in the user defined form?

Thanks in advance..

Suresh Yerra

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Thanks

Former Member
0 Kudos

Hi suresh,

Can you explain better what you are trying to accomplish?

Regards,

Vítor Vieira

Former Member
0 Kudos

Thanks Vitor Vieira.

At left most column of a matrix In user define form, I need to maintain S. No. for rows. In the add mode, initial form load, number 1 has to appear at left most column (S.No or #).

Thanks,

Suresh

Former Member
0 Kudos

Hi,

How r u filling ur matrix..? are u using record set..?? if ur using record set just bind the 1st col V_0 (or the name as in ur case)

to the sno in the sql query.

check the following sample query

select ROW_NUMBER() OVER(ORDER BY code Asc),* from OLCT

this query will give an additional row as output with the line no.

Or u can also use a for loop to fill that colunm.

Vasu Natari.

Edited by: vasu natari on Jul 28, 2009 7:09 AM

Former Member
0 Kudos

Hi

Just Bind ur # or S.No Column to LineId .AS a result the serial no will be generated automatically.in the add mode t wouldnt be coming but once its added it keeps on generating automatically

Rgds

Micheal