Dynamic Tables
Dynamic Tables
Data can be retrieved from an ODBC data source table through the Dynamic Table access method, which allows access to a single record set in an ODBC data source table via record tags. The record tags correspond to their respective columns in the data source table, and are dynamically controlled via internal control tags (which are accessible from a client application). This allows users to work with a particular record set in the table. The table below displays a list of the internal control tags that can be used to access the data.
|
Dynamic Table Control Tags
|
Access
|
Description
|
|---|---|---|
|
Move
|
Read/Write
|
Move a specified number of records forward (positive value) or backward (negative value) in a table.
|
|
MovePrev
|
Read/Write
|
Move to the previous record (on write complete).
|
|
MoveNext
|
Read/Write
|
Move to the next record (on write complete).
|
|
MoveLast
|
Read/Write
|
Move to the last record in the table (on write complete).
|
|
MoveFirst
|
Read/Write
|
Move to the first record in the table (on write complete).
|
|
CurrentRecord
|
Read Only
|
The index of the record that is currently being accessed.
|
|
RecordCount
|
Read Only
|
Number of records are in the table.
|
The basic flow of defining a dynamic table is shown in the diagram below. Click on each step for instructions.
