Subject Re: [firebird-support] Record numbering
Author Nando Dessena
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.

Nando Dessena
I support Firebird, I am a Firebird Foundation member!
Join today at