DbTable
| Release: |
• 4.6 • 5.0 • 5.1 • 5.2 • 5.3 • 5.4 • 6.0 • 6.1 • 6.2 • 6.3 • 6.4 • 6.5 • • 6.6 • 7.0 • 7.1 • 7.2 |
|---|
(Requires Analytica Developer or Power Player)
DbTable(dbIndex, column)
DbTable(dbIndex, columnList)
DbTable(dbIndex, columnIndex)
DbTable() is used to get at the data within a result table. The first argument, «dbIndex», must be the name of a Variable (normally an index) in your Analytica model that is defined with a DbQuery() statement. If the second argument, «column», is a text value, it identifies the name of a column label in the result table, in which case DbTable() returns a 1-D array (indexed by dbIndex) with the data for that column.
If the second argument is a list of text values (the «columnList» form), then DbTable() returns a 2-D table with records indexed by dbIndex, and columns implicitly indexed (i.e., self-indexed/null-indexed).
If the second argument is the name of an Analytica Variable (usually an index) whose value evaluates to a list of text values, those text values become the column headings for a 2-D table with columns indexed by «columnIndex», and rows indexed by dbIndex. With this last form, «columnIndex» may be defined as DbLabels(dbIndex).
Library
Database Functions