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

[excessive quoting removed by server]