>Does SQL Server tables have a Record # similar to vfp's recno() funtion ?
>
>Thanks For Your Help !
>Stephen J. Hunt
In general, a database server does not have a record number. You must identify records by their primary key.
Precisely because there is no such thing as a record number, it is important that the table does, indeed, have a key which identifies each record uniquely.
Of course, if you get the data over a remote view, the records will have a recno() in VFP - but there is no guarantee that the record will have the same number next time.
About the primary keys, you may want to take a look at my article
http://www.utmag.com/wconnect/wc.dll?9,7,10,1599HTH,
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)