|Subject||RE: [firebird-support] ROW_NUMBER|
> Hi, is there a way to have a RowNumber for each row returned by aI suspect that what it really wnats is a primary key value. Not just a
> 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.
> Thanks Q
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?