>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
There's a big difference in SQL Server and VFP in the way that records are handled. VFP uses the record pointer to determine the record number. SQL Server is set based and uses the primary key. It's better to use the PK in these kind of situations.
>In addition, I have also noticed that RECCOUNT() doesn't show the number of records in a view correctly.
Again, this is a difference between VFP and SQL Server. If the data is being retrieved asynchronously, then both RECCOUNT() and _TALLY won't be accurate until the data transfer is complete.
George
Ubi caritas et amor, deus ibi est