Navigation
Purpose: |
Display the next record in the table. When a query is active, only records matching the search criteria will be displayed. |
Category: |
Navigation |
Syntax: |
dbpNext "database id" "table" database id The name assigned to the database. table The name of the table. |
Example: |
dbpNext "AddrBook" "Contacts" |
SQL Equivalent: |
N/A |
Purpose: |
Display the previous record in the table. When a query is active, only records matching the search criteria will be displayed. |
Category: |
Navigation |
Syntax: |
dbpPrev "database id" "table" database id The name assigned to the database. table The name of the table. |
Example: |
dbpPrev "AddrBook" "Contacts" |
SQL Equivalent: |
N/A |
Purpose: |
Display the first record in the table. When a query is active, only records matching the search criteria will be displayed. |
Category: |
Navigation |
Syntax: |
dbpFirst "database id" "table" database id The name assigned to the database. table The name of the table. |
Example: |
dbpFirst "AddrBook" "Contacts" |
SQL Equivalent: |
N/A |
Purpose: |
Display the last record in the table. When a query is active, only records matching the search criteria will be displayed. |
Category: |
Navigation |
Syntax: |
dbpLast "database id" "table" database id The name assigned to the database. table The name of the table. |
Example: |
dbpLast "AddrBook" "Contacts" |
SQL Equivalent: |
N/A |
Purpose: |
Display a specific record based on its sequential position in the table. Note: A record's relative position in the table may change depending on the active query and sort settings. |
Category: |
Navigation |
Syntax: |
dbpGotoRecot "database id" "table" "record num" database id The name assigned to the database. table The name of the table. record num The index number of the record you want to display. This is the record's sequential position in the database based on the current query and sort settings (first record = 1). |
Example: |
dbpGotoRecord "AddrBook" "Contacts" "10" |
SQL Equivalent: |
N/A |