Difference between revisions of "DbQuery"
m (→New to 4.0) |
m (adding doc status category) |
||
Line 1: | Line 1: | ||
[[Category:Database Functions]] | [[Category:Database Functions]] | ||
+ | [[Category:Doc Status C]] <!-- For Lumina use, do not change --> | ||
Queries an ODBC database. | Queries an ODBC database. |
Revision as of 07:17, 24 April 2007
Queries an ODBC database.
{stub}
New to 4.0
In Analytica 4.0 (but not earlier releases), a local index can hold the record set. This means you can create a user-defined function that bundles several database query steps. For example:
Function DbFullTable(connectionStr, sql: text) Definition: Index Rows := DbQuery(connectionStr, sql); Index Cols := DbLabels(Rows); DbTable(Rows, Cols)
This user-defined function returns the full relational table in a single call, using local indexes, Rows and Cols.
Comments
Enable comment auto-refresher