i want to add a field in a table that contains the record number of the
line.
this field will be the key field because my data are so bad without
unique key.
so the idea is to create a field then update the field with rownumber
for each row.
thanks
julien
Martijn Tonies a écrit :

> 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 <http://www.upscene.com>
> My thoughts:
> http://blog.upscene.com/martijn/ <http://blog.upscene.com/martijn/>
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
> <http://www.databasedevelopmentforum.com>
>
>