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 <[email protected]> wrote: > > > 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/cajidmyj7ub5n8qhd6xrsga20dnj3tgdxmombguf62vcn56l...@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.
