Rafael,
as soon as you got your SQL-Query from the Server it will be in a cursor at your VFP client. Therefor that cursor indeed has a recno(), and that's what Andy is talking about. Thus Andy's solution is totally useful, as long as you need that result only at the VFP side.
wOOdy
-----Ursprüngliche Nachricht----- Von: ProFox [mailto:profox-bounces@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/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, * FROM tmp