I only see Jurgen's statement, noting from you in my current email. Then this popped in as I was writing. "Yes. After I read Woody's example I checked the SQL help an now see how to use it.tksRafael "
On Thu, Oct 26, 2017 at 3:10 PM, rafael.copquin rafael.copquin@gmail.com wrote:
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]