RecNo function

[Killeen]

Hello,

is there a RecNo() function within Delphi? Can't find it in the help
but I saw some references to such a function in certain posts.

Thanx,
Eric.

[Dan Brennand]

There is a RecNo property for datasets, such as the set of records
returned by a TQuery or TTable object. It can be used with Paradox and
dBase tables OK, but is not recommended for SQL databases. There is no
inherent record number in SQL server databases, as there is in Pdox
and dBase.

The ususal recommendation is not to use RecNo, even with Pdox and
dBase. Use keys and indexes, First, Last, Next, and Prior methods for
navigating through datasets.

This same discussion applies to RecordCount also. See the online help
for TQuery and TTable, finding the RecNo and RecordCount properties.

HTH,
Dan

On Tue, 06 Nov 2001 21:51:39 +0100, Killeen <eal...@bigfoot.com>
wrote:

--
Dan Brennand
CMDC systems, inc.
Configuration Management and Document Control:
visit us at www.cmdcsystems.com
[SPAM block: my e-mail address is DanB at CMDCsystems.com]

[Bambang Purwanto]

If you use TDataSet to indicate the active record in the dataset, use
TDataSet.RecNo function.

B.P.

"Killeen" <eal...@bigfoot.com> wrote in message
news:pajgut0ui867ufm89...@4ax.com...