I haven't thought of the term recno() in decades. It is a temporary pointer to a specific row but why would you not use your PKey as an identifier?
On Thu, Oct 26, 2017 at 10:00 AM, Jürgen Wondzinski juergen@wondzinski.de wrote:
In SQL each record has to have a PrimaryKey (Field) for identifying it, since SQL doesn't know of records, it knows about result-sets instead.
The RECNO() in xBase is just the same concept: a unique identifier for the current session, not meant for a longterm relation setting. If you designed your SQL table without a unique identifier, then you're out of luck :)
wOOdy
-----Ursprüngliche Nachricht----- Von: ProFox [mailto:profox-bounces@leafe.com] Im Auftrag von Rafael Copquin Gesendet: Donnerstag, 26. Oktober 2017 16:34 An: profox Betreff: recno() function in tsql
Is there an equivalent to the VFP recno() function in T-SQL?
I'd like to create the following select statement in T-SQL:
select recno(),otherfields..... from database.dbo.table
If there is not, what would be a substitute?
Rafael Copquin
[excessive quoting removed by server]