Navigating a database via buttons

Results 1 to 2 of 2

Thread: Navigating a database via buttons

  1. #1
    Join Date
    Dec 1969

    Default Navigating a database via buttons

    I want to be able to give the user the functionality of traversing the database with the following four buttons. Move First, Move Next, Move Previous and Move Last. I have tried this with disasterous consequences. On MoveFirst and MoveLast they both come up with the message of <BR><BR>"Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record."<BR><BR>rather than display the record. Move Next works once but then if you request move next it just displays the current record again. While move previous just errors.<BR><BR>Does anybody have any experience of such functionality, that works?!? <BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Navigating a database via buttons

    This woiuld be dependant on the cursor type you use when opening the recordset. Are youtrying to do this on the client, or server side? <BR><BR>Maybe look into client side browsing?<BR><BR>or, find another way to display the record you want to see, Ie do it with sequel. Like if you have an ID field in your db that is a consecutive autonumber, on entry to the page, select the MIn(AutoNumber), will return first record, then movePrevious = Select * from Table where AutoNumber = (CurrentAutoNumber - 1)<BR><BR>and so on!<BR><BR>Move first is Select Min(Autonuimber, nextfield, nextfield<BR>MoveLast is Slect Max(AutoNumber)<BR><BR>Thats All I can suggest!<BR>HTH<BR>Dave

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts