| Subject | Sequenced record number in calculated field | 
|---|---|
| Author | Marcin Bury | 
| Post date | 2012-03-06T18:03:48Z | 
Hello All
I have added a calculated field to my IB_Query:
R_NO INTEGER
I'd like to populate it with number representing current record number
to achevie something like that:
R_NO Some_Field
1 Record no one
2 Record no two
3 Record no three
...
101 Record no one hundred one
In IB_Query CalculateField event I have tried so far:
AField.AsInteger := TIB_Query(Sender).RecNo
AField.AsInteger := TIB_Query(Sender).RowNum
AField.AsInteger := TIB_Query(Sender).BufferRowNum
but no luck...
TIA
Marcin
            I have added a calculated field to my IB_Query:
R_NO INTEGER
I'd like to populate it with number representing current record number
to achevie something like that:
R_NO Some_Field
1 Record no one
2 Record no two
3 Record no three
...
101 Record no one hundred one
In IB_Query CalculateField event I have tried so far:
AField.AsInteger := TIB_Query(Sender).RecNo
AField.AsInteger := TIB_Query(Sender).RowNum
AField.AsInteger := TIB_Query(Sender).BufferRowNum
but no luck...
TIA
Marcin