Extension: |
|
Extension ID: |
org.sistema.oo.JaguarAddIn |
Release date: |
28/11/2007 - 15:07 |
Version: |
1.0.0 |
System Independent |
|
Compatibility: |
2.x, 3.0, 3.1, 3.2, 3.3, 3.4 |
Binary type: |
OOo extension (.oxt) |
Adds the SQLREQUEST function to CALC. This function is similar to the SQL.REQUEST function of MS-Excel.
SQLREQUEST is an array function. This means that it results in an array containing the data returned by the data source. The online help of Calc includes the "Array Functions" section explaining how to use them.
The following is an example of a typical call using the MySQL J/Connector driver:
=SQLREQUEST("com.mysql.jdbc.Driver";"jdbc:mysql://server_ip_address/?user=name&password=abc";"SELECT * FROM table")
Release notes.