Look at the example in my earlier reply to WoodyRafael
Enviado desde mi dispositivo Samsung
-------- Mensaje original -------- De: Stephen Russell srussell705@gmail.com Fecha: 26/10/2017 12:37 (GMT-03:00) A: ProFox Email List profox@leafe.com Asunto: Re: recno() function in tsql
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]
_______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAJidMYLqnGsXhUUdkspCR5S9YonCwGtYDRFd... ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.