Move First, move Prev, Move Next, Move Last

[GammelNok]

I have an excellent function in Access 2000 that performs the above, Enabling buttons on EOF and BOF.
Trying to get the same result in SQL Server does not work too well.

Has anybody got stored procedures to perform the above

Any help appeciated on this steep learning curve

Regards
Hans

 

[markVII]

You could use SQL cursors that behave almost identical to ADO recordsets you are referring to. Use scrollable cursor. There are catches associated with it though (like data refresh and such). Also, SQL Server cursors are VERY expensive in terms of system resources.

If SQL Cursor is not an option, then you'll have to query your data using some kind of unique sequencer, like IDENTITY column.