Hi all

I've a VFP8 app talking to MSSQL. Is it save to use RECNO() to reposition my record in a remote view cursor after a SEEK as follows? :

LOCAL lnrecno
SELECT remote_view
lnrecno = RECNO()
SEEK .....
GO lnrecno

In addition, I have also noticed that RECCOUNT() doesn't show the number of records in a view correctly.

Your advice most appreciated.


Thanks & Best Regards