Difference between revisions of "DbQuery"

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


You are not allowed to post comments.