MSSQL Server

MSSQL Server

Post 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.
 
 
 

MSSQL Server

Post 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