8.03.404 BAQs - calc column to display row number of returned datase

I'm trying to do something (relatively simple in SQL) via a BAQ: create a calculated column that returns the sequential row # of each row in the returned data set.

Checking the Epicor Knowledge Base led me to the (massive) Progress guide where I found keyword CURRENT-RESULT-ROW() - which appears to be intended to do exactly what I want - but it created an error when I analyzed the BAQ syntax.

I dug further and realized it also requires a DEFINE (queryname) AS (querytable) SCROLLING statement to function - but the BAQ Designer is getting in the way and confounding all my efforts to define my query as SCROLLING.

Anyone have any experience with doing something like this?

Much appreciated if you can head me in the right direction.


Rob Brown

Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ