Table 6-2 Record Operations Available for VAOperation Property
|
0 - Open
|
Opens the associated Pervasive.SQL data file.
|
|
1 - Close
|
Closes the associated Pervasive.SQL data file.
|
|
2 - Insert
|
Inserts the contents of the current record buffer as a new record.
|
|
3 - Update
|
Updates the current record with the contents of the record buffer.
|
|
4 - Delete
|
Deletes the current record.
|
|
5 - Get Equal
|
Retrieves the first record in the current index path with a key value which exactly matches the key value specified.
|
|
6 - Get Next
|
Retrieves the next record in the current index path.
|
|
7 - Get Previous
|
Retrieves the previous record in the current index path.
|
|
8 - Get Greater
|
Retrieves first the record in the current index path with a key value greater than the key value specified.
|
|
9 - Get Greater or
Equal
|
Retrieves the first record in the current index path with a key value greater than or equal to the key value specified.
|
|
10 - Get Less
|
Retrieves the last record in the current index path with a key value less than the key value specified.
|
|
11 - Get Less or
Equal
|
Retrieves the last record in the current index path with a key value less than or equal to the key value specified.
|
|
12 - Get First
|
Retrieves the first record in the current index path.
|
|
13 - Get Last
|
Retrieves the last record in the current index path.
|
