RE: recno() function in tsql

2017-10-30 Thread Richard Kaye
I'm a charter member of the strange humor club... -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jürgen Wondzinski Sent: Sunday, October 29, 2017 8:02 AM To: profoxt...@leafe.com Subject: AW: recno() function in tsql Yea, you need to get

AW: recno() function in tsql

2017-10-29 Thread Jürgen Wondzinski
Yea, you need to get used again to my strange "black" humor... wOOdy -Ursprüngliche Nachricht- Von: ProFox [mailto:profox-boun...@leafe.com] Im Auftrag von Richard Kaye Gesendet: Freitag, 27. Oktober 2017 16:31 An: profox@leafe.com Betreff: RE: recno() function in tsql Now

RE: recno() function in tsql

2017-10-29 Thread Jürgen Wondzinski
-Ursprüngliche Nachricht- Von: ProFox [mailto:profox-boun...@leafe.com] Im Auftrag von Rafael Copquin Gesendet: Freitag, 27. Oktober 2017 20:49 An: profox@leafe.com Betreff: Re: WG: recno() function in tsql That works for dbf tables, but not for SQL Server tables Thanks Rafael Copquin El 27/10

Re: WG: recno() function in tsql

2017-10-27 Thread Rafael Copquin
That works for dbf tables, but not for SQL Server tables Thanks Rafael Copquin El 27/10/2017 a las 14:40, AndyHC escribió: fwiw this works - (use dbc, remote view, cursor adaptor, w.h.y for line 1  :- SELECT * FROM somewhere WHERE type = "myType" INTO CURSOR tmp SELECT RECNO() as id, *

Re: WG: recno() function in tsql

2017-10-27 Thread AndyHC
fwiw this works - (use dbc, remote view, cursor adaptor, w.h.y for line 1  :- SELECT * FROM somewhere WHERE type = "myType" INTO CURSOR tmp SELECT RECNO() as id, * FROM tmp ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

RE: recno() function in tsql

2017-10-27 Thread Richard Kaye
Now we're all really happy you've joined us, wOOdy. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jürgen Wondzinski Sent: Friday, October 27, 2017 7:02 AM To: profoxt...@leafe.com Subject: AW: recno() function in tsql ... Old farts stink

RE: recno() function in tsql

2017-10-27 Thread Jean Laeremans
dinary course of its > business. Until such time as the property in the goods passes to the buyer > the seller shall be entitled at any time > > -Original Message- > From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Jürgen > Wondzinski > Sent: 27 October 2017 10

AW: recno() function in tsql

2017-10-27 Thread Jürgen Wondzinski
... Old farts stink alike ... :) wOOdy -Ursprüngliche Nachricht- Von: ProFox [mailto:profox-boun...@leafe.com] Im Auftrag von Dave Crozier Gesendet: Freitag, 27. Oktober 2017 12:38 An: ProFox Email List <profox@leafe.com> Betreff: RE: recno() function in tsql Fools seldom

RE: recno() function in tsql

2017-10-27 Thread Dave Crozier
AW: recno() function in tsql Yep. Great minds think alike :) wOOdy -Ursprüngliche Nachricht- Von: ProFox [mailto:profox-boun...@leafe.com] Im Auftrag von Dave Crozier Gesendet: Freitag, 27. Oktober 2017 11:42 An: ProFox Email List <profox@leafe.com> Betreff: RE: recno() function i

AW: recno() function in tsql

2017-10-27 Thread Jürgen Wondzinski
Yep. Great minds think alike :) wOOdy -Ursprüngliche Nachricht- Von: ProFox [mailto:profox-boun...@leafe.com] Im Auftrag von Dave Crozier Gesendet: Freitag, 27. Oktober 2017 11:42 An: ProFox Email List <profox@leafe.com> Betreff: RE: recno() function in tsql Same solution as I

RE: recno() function in tsql

2017-10-27 Thread Dave Crozier
y in the goods passes to the buyer the seller shall be entitled at any time -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Jürgen Wondzinski Sent: 27 October 2017 10:43 To: 'ProFox Email List' <profox@leafe.com> Subject: AW: recno() function in

AW: recno() function in tsql

2017-10-27 Thread Jürgen Wondzinski
<profox@leafe.com> Betreff: Re: recno() function in tsql 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,

RE: recno() function in tsql

2017-10-27 Thread Dave Crozier
WG: recno() function in tsql Von: rafael.copquin [mailto:rafael.copq...@gmail.com] Gesendet: Donnerstag, 26. Oktober 2017 22:09 An: Jürgen Wondzinski <juer...@wondzinski.de> Betreff: RE: AW: AW: recno() function in tsql That's it. Thank you Rafael Enviado desde mi dispositivo Samsung

WG: recno() function in tsql

2017-10-27 Thread Jürgen Wondzinski
Von: rafael.copquin [mailto:rafael.copq...@gmail.com] Gesendet: Donnerstag, 26. Oktober 2017 22:09 An: Jürgen Wondzinski <juer...@wondzinski.de> Betreff: RE: AW: AW: recno() function in tsql That's it. Thank you Rafael Enviado desde mi dispositivo Samsung Mensaje or

AW: recno() function in tsql

2017-10-27 Thread Jürgen Wondzinski
-Ursprüngliche Nachricht- Von: Jürgen Wondzinski [mailto:juer...@wondzinski.de] Gesendet: Donnerstag, 26. Oktober 2017 17:19 An: 'Rafael Copquin' <rafael.copq...@gmail.com> Betreff: AW: AW: recno() function in tsql Hi Rafael, ah, you want a freshly generated SEQUENCE number o

WG: recno() function in tsql

2017-10-27 Thread Jürgen Wondzinski
-Ursprüngliche Nachricht- Von: Rafael Copquin [mailto:rafael.copq...@gmail.com] Gesendet: Donnerstag, 26. Oktober 2017 17:09 An: Jürgen Wondzinski <juer...@wondzinski.de> Betreff: Re: AW: recno() function in tsql Hi Woody It's been a long time! Welcome back! FYI, I always build

Re: recno() function in tsql

2017-10-26 Thread Stephen Russell
ote: > > > Look at the example in my earlier reply to WoodyRafael > > > Enviado desde mi dispositivo Samsung > > Mensaje original > De: Stephen Russell <srussell...@gmail.com> > Fecha: 26/10/2017 12:37 (GMT-03:00) > A: ProFox Email List &l

RE: recno() function in tsql

2017-10-26 Thread rafael.copquin
leafe.com> Asunto: RE: recno() function in tsql Rafael, Jurgen is correct but there is a "pseudo" way to do it if you simply want a unique row number to be generated if that helps. Use Row(Number) with the OVER(...)  segmentation construct Select   Row_NUMBER() over (Partition by <

Re: recno() function in tsql

2017-10-26 Thread rafael.copquin
Look at the example in my earlier reply to WoodyRafael  Enviado desde mi dispositivo Samsung Mensaje original De: Stephen Russell <srussell...@gmail.com> Fecha: 26/10/2017 12:37 (GMT-03:00) A: ProFox Email List <profox@leafe.com> Asunto: Re: recno() func

Re: recno() function in tsql

2017-10-26 Thread Stephen Russell
identifier, then you're out of > luck :) > > > wOOdy > > -Ursprüngliche Nachricht- > Von: ProFox [mailto:profox-boun...@leafe.com] Im Auftrag von Rafael > Copquin > Gesendet: Donnerstag, 26. Oktober 2017 16:34 > An: profox > Betreff: recno() function in ts

RE: recno() function in tsql

2017-10-26 Thread Dave Crozier
4 To: profox <profox@leafe.com> Subject: 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?

AW: recno() function in tsql

2017-10-26 Thread Jürgen Wondzinski
designed your SQL table without a unique identifier, then you're out of luck :) wOOdy -Ursprüngliche Nachricht- Von: ProFox [mailto:profox-boun...@leafe.com] Im Auftrag von Rafael Copquin Gesendet: Donnerstag, 26. Oktober 2017 16:34 An: profox Betreff: recno() function in tsql

recno() function in tsql

2017-10-26 Thread Rafael Copquin
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 --- Este correo electrónico ha sido comprobado en