j> How to write select that gives field of selected record number. I have
j> table just from one field "SomeField" how to get result:


j> RecNo SomeField
j> ----- --------------
j> 1 sdferfer
j> 2 ertertt dfgdfg
j> 3 df ;dlfklee
j> ...

personally I'd do it on the client: no point in transferring already known
values over the network. If you *need* it on the server, then either
add a physical field to the table or use a stored procedure. Please
also consider the possibility that, if you rely on that, your database
design might be flawed.

Ciao
--
Nando Dessena
======================================================
I support Firebird, I am a Firebird Foundation member!
Join today at http://www.firebirdsql.org/ff/foundation
======================================================