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