-----Ursprüngliche Nachricht----- Von: Jürgen Wondzinski [mailto:juergen@wondzinski.de] Gesendet: Donnerstag, 26. Oktober 2017 17:19 An: 'Rafael Copquin' rafael.copquin@gmail.com Betreff: AW: AW: recno() function in tsql
Hi Rafael,
ah, you want a freshly generated SEQUENCE number of your foundset. See this:
https://stackoverflow.com/questions/13100000/how-can-i-create-a-temporary-se...
wOOdy
-----Ursprüngliche Nachricht----- Von: Rafael Copquin [mailto:rafael.copquin@gmail.com] Gesendet: Donnerstag, 26. Oktober 2017 17:09 An: Jürgen Wondzinski Betreff: Re: AW: recno() function in tsql
Hi Woody
It's been a long time! Welcome back!
FYI, I always build all my tables with autoincrementing primary keys. In this particular case the table I am dealing with has 10000 records. The primary keys go from 1 to 10000.
But i want to select a small set based on a date range (it is a sales table)
I just want the first column of the selected cursor to contain the record number and the other columns the rest of the data.
So I should be getting something like this:
RecordNo ID Date etc
1 5421 2017-06-15
2 5422 2017-06-15
3 5423 2017-06-16
etc
Rafael
El 26/10/2017 a las 12:00, Jürgen Wondzinski escribió:
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]