Small company logo:
   History
 
Advertising banner:
 
 Statement.MoveFirst
Home • Help • Customization Tools • FCAS • Language Reference • Statement.MoveFirst
 
Purpose
Moves the record pointer to the first record in the record set and updates bound columns.
The Move method automatically discards any changes on a modified or inserted record if the changes have not been written to the database with the Update method.
Syntax
DBStatement.MoveFirst
Compliance:
Level 2 (SQLExtendedFetch)
Example
The following example displays all contact names from a database from the first record to the last.
Sub DisplayContactNames(Contact as DBStatement)
        Contact.MoveFirst
        Do While Not Contact.EOF
                Print "Contact name:"; Contact.Column("name")
                Contact.MoveNext
        Loop
End Sub