Subject Re: [IBO] Record Number
Author Geoff Worboys
> Is there a RecordNumber property or function that I can not find?
> I do understand that this can only represent the "Fetch Number"
> of the current row in the current query; but that is all I need.

The internal IBO dataset does have a RowNum property, and this is
often equivalent to the "Fetch Number" - but not always. IBO has
various tricks for different sorts of datasets when it comes to
jumping to the end, incremental search etc.

> I have a client who "really" wants me to display this...

The question becomes... why? It is useless information and all
it will do is confuse people. They will start to say "the fourth
record is ...", only to discover it is a different row number in
other queries. Give it to them and they will start to use it
like the old dBase record numbers and that will help no one.

Educate them to use other forms of record identification and in
the long term everyone will be happier. Perhaps you can set
your application to highlight the field(s) they should use for
identification in some way if/where that is appropriate.

--
Geoff Worboys
Telesis Computing