Naomi,

here is an other way to come to the result (thanks to Brad Schulz)

lnMyNum = 0
SELECT myTable, GetRunningNumber() AS MySeq FROM myTable INTO CURSOR MyCursor NOFILTER

FUNCTION GetRunningNumber
lnMyNum = lnMyNum+1
RETURN lnMyNum
ENDFUNC

Best Regards,

Koen