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
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
-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
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, *
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:
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
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
... 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
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
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
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
<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,
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
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
-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
-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
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
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 <
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
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
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?
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
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
23 matches
Mail list logo