<MvGO>

   Also See:   MvDELETE MvPRIMARY MvUNDELETE MvREINDEX MvADD MvUPDATE MvPACK MvCLOSE MvOPEN MvCREATE MvMAKEINDEX MvFILTER MvFIND MvSKIP  

Report a language bug  |  Report a documentation error
Operating on an open database or query, this tag moves to the physical record in the database in NAME, regardless of how the database is indexed. If NAME is omitted, the record pointer for the primary database is moved.
Syntax 
<MvGO NAME = "string: {  expression } | literal"
      ROW = "numeric: { expression } | top | bottom"
      VIEW = "string: {  expression } | literal">
  • Empty Tag

Attributes

  • NAME: Optional Database alias. When a database is opened with MvOPEN, it is referenced in all other database commands by the alias. If  omitted, the records pointer for the primary database is moved. The database must be open.
  • ROW: Required numeric value or the keywords top or bottom which move the record pointer respectively, to the first and last database record.
  • VIEW: Optional odbc_view. Support for ODBC has been dropped so this attribute can be omitted.

Examples

The row number generally referrers to the row in physical, not indexed order. There are two exceptions to this: if the database is indexed, the special values 'top' and 'bottom' will move the record pointer to the first and last records in indexed order. It follows from this that 'top' and 'bottom' do not move the record pointer to the physical top and bottom of an indexed database. In this situation, you can achieve the same effect via the following:

This example moves the record pointer of the primary database, to the first or last physical record regardless of any open index.

Example:

<MvGO ROW="1">  <!-- move to the first physical record -->
<MvGO ROW="{ alias.d.totrec }">  <!-- move to the physical last record -->

This example moves the record pointer of the primary database to the first or last physical record, if an index is NOT open, or the first or last indexed record if index is open.

Example:

<MvGO ROW="top">
<MvGO ROW="bottom">

Often ROW="top" is used at the start of defined search functions to ensure that the search starts from the first record, otherwise, subsequent calls to the function may result in searching forward from an unknown position in the database.

Example:

<MvGO NAME="categories" ROW="top">
<MvFIND NAME="categories" VALUE="{ categories.d.id EQ l.id }" EXACT>
+ Add a note
User Annotations: MvGO