History  | 
MoveFirst (database statements) 
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 
 | ||