I am trying to add a column to a table in the script to add a distinct value so I can show all lines in a table box. I am thinking of adding a column with numbers 1,2,3,4... how do I do that in the script?
do you mean something like using rowno ?
Rowno() as RowNumber
Retrieving data ...