I have a data table that uses a query to return data from the database. I want to be able to number the rows returned, to give them a ranking.

Here is the query:

SELECT Score, Name, Position, CurrentAge
From database.table
Where Team = "A"

The scores are ordered correctly, but the results look like:

25, John, C, 18
36, Joe, LF, 19
etc

I'd like to show as

1, 25, John, C, 18
2, 36, Joe, LF, 19
etc.

Any advice would be greatly appreciated.

Hello,

It is possible to use this solution.

Regards,
ARI Soft

The code results in an error 15:

"unknown expr_type in expression subtree[0] user_variable"

Any other advice?

What query do you use?

Regards,
ARI Soft

I've tried several of those examples. Anything with user-defined variables throws that same error.

Update "ARI Smart Content" to v. 2.2.30 and try again. It should help.

Regards,
ARI Soft