recno method doesn't work

Neil McCarthy

Delphi Developer

Thu, 29 Mar 2001 03:00:00 GMT

recno method doesn't work

Anyone know why the following:

table1.First;
while not table1.EOF do
begin
Showmessage(
'Record '+IntToStr(Table1.RecNo)+' of '+
IntToStr(Table1.RecordCount));
table1.Next;
end;

returns -1 every time?

Per-Eric Jenshage

Delphi Developer

Fri, 30 Mar 2001 03:00:00 GMT

Re:recno method doesn't work

This is a copy of the reference in VCL.HLP for RecNo:

Applies to

TTable, TQuery, TStoredProc components

Declaration

property RecNo: Longint;

Description

Run-time and read-only. The RecNo property returns a record number for the
current record in the dataset. Record numbers are only available for
Paradox and dBASE tables; the concept isn't supported by most SQL servers
so a table in a SQL database always returns -1 for RecNo.

Per-Eric Jenshagen

Quote

Neil McCarthy wrote:
> Anyone know why the following:

> table1.First;
> while not table1.EOF do
> begin
> Showmessage(
> 'Record '+IntToStr(Table1.RecNo)+' of '+
> IntToStr(Table1.RecordCount));
> table1.Next;
> end;

> returns -1 every time?

Brian Bushay Tea

Delphi Developer

Sat, 31 Mar 2001 03:00:00 GMT

Re:recno method doesn't work

Quote

>Anyone know why the following:
>table1.First;
> while not table1.EOF do
> begin
>Showmessage(
> 'Record '+IntToStr(Table1.RecNo)+' of '+
> IntToStr(Table1.RecordCount));
> table1.Next;
> end;

>returns -1 every time?

-1 is what you get when the dataset does not support RecNo
for instance a Paradox table with a filter applied will not support RecNo

--
Brian Bushay (TeamB)
Bbus...@DataGuidance.com

Other Threads

1. Table1.RecNo doesn't work

2. Why RecNo doesn't work with Access

3. Why RecNo doesn't work with Access97?

4. TQuery's locate method doesn't work properly

5. Seek method for ADO dataset doesn't work for me

6. RichEdit PaintTo method doesn't seem to work

7. tstrings property's write method doesn't get called on insert

8. WORKING DIRECTORY: Doesn't work

9. Post doesn't work with Indy, works with ICS

10. why filecopy(string,'test.txt',err) doesn't work