>I have a view of remote data that contains one record (the table is to large to download all of it locally each time). How do I requery the view to go to the next record (or previous) record. The primary key is sequential but records can be deleted so the primary key could be 1,2,3,99,203, etc. I thought about taking the current record's primary key and then in a loop add 1 to it until a record is found but this does not seem very efficient. I would appreciate any help.
>
>Thanks
You can simulate this by requesting one record from SQL-Server. It can be done either in Remore View Data Fetch settings or ,if you use SQL stored procedure @@ROWCOUNT=1. The query itself will look like:
Select .... Where Table.Id > nId && or
nId is curent record 'number'
Edward Pikman
Independent Consultant