Subject RE: [firebird-support] ROW_NUMBER
Author Alan McDonald
> Hi, is there a way to have a RowNumber for each row returned by a
> query?
> like: select RowNum(), fld1, fld2 from MyTable order by 3, 2
> I know this is probably not good SQL, but the 3rd party visual
> component I'm using expects a numeric ID from the dataset.
> FB103
> Thanks Q

I suspect that what it really wnats is a primary key value. Not just a
number which can change each time you retrieve the data. In which case you
should use the PK field. What visual component set is it?