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
|