I have a tEDBTable that is active, and contains one record. After
Table.First, I get Table.Recno = 0. In my old, preEDB days, that used to be
1. Is this a bug, or does Recno use 0-based counting?

When using Paradox tables, you can position a table on the nth record using
'Table.RecNo := n;'. Is this also possible with tEDBTables?

RJ

"Royke" <royke@canada.com> wrote in message
news:37434CB8-6692-4008-B477-DD95215D6346@news.elevatesoft.com...
>I have a tEDBTable that is active, and contains one record. After
>Table.First, I get Table.Recno = 0. In my old, preEDB days, that used to be
>1. Is this a bug, or does Recno use 0-based counting?
>
> When using Paradox tables, you can position a table on the nth record
> using 'Table.RecNo := n;'. Is this also possible with tEDBTables?
>
> RJ

I did some more checking: RecNo is always zero (if there are 1 or more
records).

RJ,

<< I have a tEDBTable that is active, and contains one record. After
Table.First, I get Table.Recno = 0. In my old, preEDB days, that used to be
1. Is this a bug, or does Recno use 0-based counting? >>

RecNo always returns 0 because EDB does not support logical or physical row
numbering.

<< When using Paradox tables, you can position a table on the nth record
using 'Table.RecNo := n;'. Is this also possible with tEDBTables? >>

Yes, but it uses brute-force navigation so don't count on it being
super-fast on extremely large tables.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


What about the internal record number - is that accessible / usable?

Roy Lambert

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
news:19973AC6-1C2F-4694-9ED3-810EFABFD8FE@news.elevatesoft.com...
> RJ,
>
> << I have a tEDBTable that is active, and contains one record. After
> Table.First, I get Table.Recno = 0. In my old, preEDB days, that used to
> be 1. Is this a bug, or does Recno use 0-based counting? >>
>
> RecNo always returns 0 because EDB does not support logical or physical
> row numbering.

Does this means that I can write off our nice status bar that says 'Record x
of xx' ? Or is there some other way to do this?

RJ

> << When using Paradox tables, you can position a table on the nth record
> using 'Table.RecNo := n;'. Is this also possible with tEDBTables? >>
>
> Yes, but it uses brute-force navigation so don't count on it being
> super-fast on extremely large tables.
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>

Roy,

<< What about the internal record number - is that accessible / usable? >>

There aren't any internal row numbers in EDB.

--
Tim Young
Elevate Software
www.elevatesoft.com

RJ,

<< Does this means that I can write off our nice status bar that says
'Record x of xx' ? >>

Yes:

http://www.elevatesoft.com/scripts/newsgrp.dll?action=openmsg&group=16&msg=66&page=1#msg66

And the same holds for an accurate scrollbar in grids.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


><< What about the internal record number - is that accessible / usable? >>
>
>There aren't any internal row numbers in EDB.

Interesting. Was there at one time or is my memory failing totally?

Roy Lambert

Roy,

<< Interesting. Was there at one time or is my memory failing totally? >>

There was a row ID column, but that's a different thing altogether.

--
Tim Young
Elevate Software
www.elevatesoft.com