Click above to get retro games delivered to your door ever month!

 go bottom           Move the record pointer to the last logical record
------------------------------------------------------------------------------
 Syntax
   [!sAlias] go[to] bottom

 Arguments
   sAlias is the database to operate on.

 Description
   The go bottom command sets the record pointer to the last logical
   record in the specified or selected alias.

   go bottom respects the order of a controlling index file, filters or the
   deleted flag. To go to the first physical record in the alias, use go 1.

 Example
   #define EXAMPLE_DATABASE
   #include example.hdr

   proc Test_gobottom
   vardef
      char cName
   enddef
   /*
   The open and use command position the record
   pointer at the first logical record in the
   database. goto bottom must be programmed to
   get to the last record after an open or use.
   */
   use "stest.dbf" alias sTest
   goto bottom
   ? recno()
   close sTest
   // verify that the last physical record is in an index file
   open sTest index sIdxLN
   goto bottom
   cName := sTest->lastname
   seek cName
   if .not. found()
      reindex
   else
      ? "Index OK"
   endif
   endproc

   proc main
   Test_gobottom()
   endproc