Hi,
i don't know if my trouble is about sql or about firebird but i would
like to return the record number of each record in a table,
so a kind of :
"select field1, field2..., recnumber as myfield from mytable.

i try also with rownumber etc... but no success

Thanks for your help
Julien