Very Computer

by **Roman Fis** » Sun, 31 Dec 1899 09:00:00

When i try to use TTable's RecNo property with MSSQL server's tables this
property alwayl returns -1.
Doe's anybody knows any resolution for this problem
(Win2K, MSSQLServer 7, Delphi 4)
TIA.
Roman.

by **Dan Brenna** » Sun, 19 Nov 2000 10:03:05

SQL tables don't have record numbers, so the TTable object returns -1.
As a general rule, record numbers are to be avoided, especially in SQL
apps.

If you really need a record number, there are several methods that
have been used successfully. Just what do you need it for? Would a
count of all records do the job? If you need to return to a particular
record, for example, a bookmark should do the trick.

HTH,
Dan

Quote:>When i try to use TTable's RecNo property with MSSQL server's tables this
>property alwayl returns -1.
>Doe's anybody knows any resolution for this problem
>(Win2K, MSSQLServer 7, Delphi 4)
>TIA.
>Roman.

--
Dan Brennand
CMDC systems, inc.
Configuration Management and Document Control:
visit us at www.cmdcsystems.com

Very Computer

MSSQL Server

MSSQL Server

MSSQL Server