Hi all
Looking to make incremental data fetch (like in block sets of 1000 records per page/view) I have come to a conclusion I need to use SQL Server's Row_Number() and that works fine. But it's in a stored proc running on the server. I simply pass the starting number and the next 1000s are fetched.
First does anyone know if there's a way to define a remote view in vfp that would achieve the same outcome? And my stored procedure returns a set of records. It would be great not to lose the previous results. So the client can return the 2 lots of 1000 fetched. At the moment the cursor is refreshed with the new set. There must be a decent approach to make it additive.
Or any advice please if I am heading the wrong way, thank you
Mathias
Looking to make incremental data fetch (like in block sets of 1000 records per page/view) I have come to a conclusion I need to use SQL Server's Row_Number() and that works fine. But it's in a stored proc running on the server. I simply pass the starting number and the next 1000s are fetched.
First does anyone know if there's a way to define a remote view in vfp that would achieve the same outcome? And my stored procedure returns a set of records. It would be great not to lose the previous results. So the client can return the 2 lots of 1000 fetched. At the moment the cursor is refreshed with the new set. There must be a decent approach to make it additive.
Or any advice please if I am heading the wrong way, thank you
Mathias