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 _______________________________________________ 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.
