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:[email protected]] Im Auftrag von Rafael Copquin Gesendet: Freitag, 27. Oktober 2017 20:49 An: [email protected] 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 > _______________________________________________ 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.
