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

That's because there is no such thing as a "recordnumber".

What is it that you're trying to do?

Martijn Tonies
Database Workbench - development tool for Firebird and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com