Difference between revisions of "DbQuery"
| Line 8: | Line 8: | ||
In Analytica 4.0 (but not in Analytica 3.x and earlier), 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: | In Analytica 4.0 (but not in Analytica 3.x and earlier), 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 : | + | Function DbFullTable( connectionStr,sql : text ) |
Definition: | Definition: | ||
Index Row := DbQuery(connectionStr,sql); | Index Row := DbQuery(connectionStr,sql); | ||
Revision as of 19:10, 7 March 2007
Queries an ODBC database.
{stub}
New to 4.0
In Analytica 4.0 (but not in Analytica 3.x and earlier), 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 Row := DbQuery(connectionStr,sql);
Index Column := DbLabels(Row);
DbTable(Row,Column)
This user-defined function returns the full relational table in a single call, using local indexes, Rows and Columns.
Comments
Enable comment auto-refresher