Look at the example in my earlier reply to WoodyRafael
Enviado desde mi dispositivo Samsung
-------- Mensaje original --------
De: Stephen Russell <[email protected]>
Fecha: 26/10/2017 12:37 (GMT-03:00)
A: ProFox Email List <[email protected]>
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 <[email protected]>
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:[email protected]] 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: [email protected]
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/cajidmylqngsxhuudkspcr5s9yoncwgtydrfdjraqr1mqrf6...@mail.gmail.com
** 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.
_______________________________________________
Post Messages to: [email protected]
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/[email protected]
** 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.
