gnumeric r16449 - in branches/gnumeric-1-8: . doc doc/C doc/de plugins/applix plugins/corba plugins/derivatives plugins/dif plugins/excel plugins/fn-complex plugins/fn-database plugins/fn-date plugins/fn-eng plugins/fn-erlang plugins/fn-financial plugins/fn-info plugins/fn-logical plugins/fn-lookup plugins/fn-math plugins/fn-r plugins/fn-random plugins/fn-stat plugins/fn-string plugins/fn-tsa plugins/gb plugins/gda plugins/gnome-db plugins/gnome-glossary plugins/guile plugins/html plugins/lotus-123 plugins/mps plugins/numtheory plugins/numtheory/doc plugins/oleo plugins/openoffice plugins/paradox plugins/perl-loader plugins/plan-perfect plugins/psiconv plugins/py-func plugins/python-loader plugins/qpro plugins/sample_datasource plugins/sc plugins/sylk plugins/uihello plugins/xbase po po-functions src/dialogs src/tools src/tools/solver src/tools/solver/glpk src/tools/solver/lp_solve src/widgets test tools
- From: mortenw svn gnome org
- To: svn-commits-list gnome org
- Subject: gnumeric r16449 - in branches/gnumeric-1-8: . doc doc/C doc/de plugins/applix plugins/corba plugins/derivatives plugins/dif plugins/excel plugins/fn-complex plugins/fn-database plugins/fn-date plugins/fn-eng plugins/fn-erlang plugins/fn-financial plugins/fn-info plugins/fn-logical plugins/fn-lookup plugins/fn-math plugins/fn-r plugins/fn-random plugins/fn-stat plugins/fn-string plugins/fn-tsa plugins/gb plugins/gda plugins/gnome-db plugins/gnome-glossary plugins/guile plugins/html plugins/lotus-123 plugins/mps plugins/numtheory plugins/numtheory/doc plugins/oleo plugins/openoffice plugins/paradox plugins/perl-loader plugins/plan-perfect plugins/psiconv plugins/py-func plugins/python-loader plugins/qpro plugins/sample_datasource plugins/sc plugins/sylk plugins/uihello plugins/xbase po po-functions src/dialogs src/tools src/tools/solver src/tools/solver/glpk src/tools/solver/lp_solve src/widgets test tools
- Date: Fri, 7 Mar 2008 02:53:39 +0000 (GMT)
Author: mortenw
Date: Fri Mar 7 02:53:38 2008
New Revision: 16449
URL: http://svn.gnome.org/viewvc/gnumeric?rev=16449&view=rev
Log:
1.8.2
Modified:
branches/gnumeric-1-8/ChangeLog
branches/gnumeric-1-8/doc/C/ChangeLog
branches/gnumeric-1-8/doc/C/func.defs
branches/gnumeric-1-8/doc/C/functions.xml
branches/gnumeric-1-8/doc/ChangeLog
branches/gnumeric-1-8/doc/de/ChangeLog
branches/gnumeric-1-8/plugins/applix/ChangeLog
branches/gnumeric-1-8/plugins/corba/ChangeLog
branches/gnumeric-1-8/plugins/derivatives/ChangeLog
branches/gnumeric-1-8/plugins/dif/ChangeLog
branches/gnumeric-1-8/plugins/excel/ChangeLog
branches/gnumeric-1-8/plugins/fn-complex/ChangeLog
branches/gnumeric-1-8/plugins/fn-database/ChangeLog
branches/gnumeric-1-8/plugins/fn-date/ChangeLog
branches/gnumeric-1-8/plugins/fn-eng/ChangeLog
branches/gnumeric-1-8/plugins/fn-erlang/ChangeLog
branches/gnumeric-1-8/plugins/fn-financial/ChangeLog
branches/gnumeric-1-8/plugins/fn-info/ChangeLog
branches/gnumeric-1-8/plugins/fn-logical/ChangeLog
branches/gnumeric-1-8/plugins/fn-lookup/ChangeLog
branches/gnumeric-1-8/plugins/fn-math/ChangeLog
branches/gnumeric-1-8/plugins/fn-r/ChangeLog
branches/gnumeric-1-8/plugins/fn-random/ChangeLog
branches/gnumeric-1-8/plugins/fn-stat/ChangeLog
branches/gnumeric-1-8/plugins/fn-string/ChangeLog
branches/gnumeric-1-8/plugins/fn-tsa/ChangeLog
branches/gnumeric-1-8/plugins/gb/ChangeLog
branches/gnumeric-1-8/plugins/gda/ChangeLog
branches/gnumeric-1-8/plugins/gnome-db/ChangeLog
branches/gnumeric-1-8/plugins/gnome-glossary/ChangeLog
branches/gnumeric-1-8/plugins/guile/ChangeLog
branches/gnumeric-1-8/plugins/html/ChangeLog
branches/gnumeric-1-8/plugins/lotus-123/ChangeLog
branches/gnumeric-1-8/plugins/mps/ChangeLog
branches/gnumeric-1-8/plugins/numtheory/ChangeLog
branches/gnumeric-1-8/plugins/numtheory/doc/ChangeLog
branches/gnumeric-1-8/plugins/oleo/ChangeLog
branches/gnumeric-1-8/plugins/openoffice/ChangeLog
branches/gnumeric-1-8/plugins/paradox/ChangeLog
branches/gnumeric-1-8/plugins/perl-loader/ChangeLog
branches/gnumeric-1-8/plugins/plan-perfect/ChangeLog
branches/gnumeric-1-8/plugins/psiconv/ChangeLog
branches/gnumeric-1-8/plugins/py-func/ChangeLog
branches/gnumeric-1-8/plugins/python-loader/ChangeLog
branches/gnumeric-1-8/plugins/qpro/ChangeLog
branches/gnumeric-1-8/plugins/sample_datasource/ChangeLog
branches/gnumeric-1-8/plugins/sc/ChangeLog
branches/gnumeric-1-8/plugins/sylk/ChangeLog
branches/gnumeric-1-8/plugins/uihello/ChangeLog
branches/gnumeric-1-8/plugins/xbase/ChangeLog
branches/gnumeric-1-8/po-functions/ChangeLog
branches/gnumeric-1-8/po/ChangeLog
branches/gnumeric-1-8/src/dialogs/ChangeLog
branches/gnumeric-1-8/src/tools/ChangeLog
branches/gnumeric-1-8/src/tools/solver/ChangeLog
branches/gnumeric-1-8/src/tools/solver/glpk/ChangeLog
branches/gnumeric-1-8/src/tools/solver/lp_solve/ChangeLog
branches/gnumeric-1-8/src/widgets/ChangeLog
branches/gnumeric-1-8/test/ChangeLog
branches/gnumeric-1-8/tools/ChangeLog
Modified: branches/gnumeric-1-8/doc/C/func.defs
==============================================================================
--- branches/gnumeric-1-8/doc/C/func.defs (original)
+++ branches/gnumeric-1-8/doc/C/func.defs Fri Mar 7 02:53:38 2008
@@ -1007,16 +1007,6 @@
@SEEALSO=DVAR
@CATEGORY=Database
- FUNCTION=EXECSQL
- SYNTAX=EXECSQL(dsn,username,password,sql)
- DESCRIPTION=The EXECSQL function lets you execute a command in a database server, and show the results returned in current sheet. It uses libgda as the means for accessing the databases.
-For using it, you need first to set up a libgda data source.
- EXAMPLES=
-To get all the data from the table "Customers" present in the "mydatasource" GDA data source, you would use:
-EXECSQL("mydatasource","username","password","SELECT * FROM customers")
- SEEALSO=READDBTABLE
-
- CATEGORY=Database
@FUNCTION=GETPIVOTDATA
@SYNTAX=GETPIVOTDATA(pivot_table,field_name)
@DESCRIPTION=GETPIVOTDATA function fetches summary data from a pivot table. @pivot_table is a cell range containing the pivot table. @field_name is the name of the field of which you want the summary data.
@@ -1027,16 +1017,6 @@
@SEEALSO=
- CATEGORY=Database
- FUNCTION=READDBTABLE
- SYNTAX=READDBTABLE(dsn,username,password,table)
- DESCRIPTION=The READDBTABLE function lets you get the contents of a table, as stored in a database. For using it, you need first to set up a libgda data source.
-Note that this function returns all the rows in the given table. If you want to get data from more than one table or want a more precise selection (conditions), use the EXECSQL function.
- EXAMPLES=
-To get all the data from the table "Customers" present in the "mydatasource" GDA data source, you would use:
-READDBTABLE("mydatasource","username","password","customers")
- SEEALSO=EXECSQL
-
@CATEGORY=Date/Time
@FUNCTION=DATE
@SYNTAX=DATE (year,month,day)
Modified: branches/gnumeric-1-8/doc/C/functions.xml
==============================================================================
--- branches/gnumeric-1-8/doc/C/functions.xml (original)
+++ branches/gnumeric-1-8/doc/C/functions.xml Fri Mar 7 02:53:38 2008
@@ -2337,38 +2337,6 @@
</para>
</refsect1>
</refentry>
- <refentry id="gnumeric-EXECSQL">
- <refmeta>
- <refentrytitle>
- <function>EXECSQL</function>
- </refentrytitle>
- </refmeta>
- <refnamediv>
- <refname>
- <function>EXECSQL</function>
- </refname>
- <refpurpose/>
- </refnamediv>
- <refsynopsisdiv>
- <synopsis><function>EXECSQL</function>(<parameter>dsn</parameter>,<parameter>username</parameter>,<parameter>password</parameter>,<parameter>sql</parameter>)</synopsis>
- </refsynopsisdiv>
- <refsect1>
- <title>Description</title>
- <para>The <function>EXECSQL</function> function lets you execute a command in a database server, and show the results returned in current sheet. It uses libgda as the means for accessing the databases.</para>
- <para>For using it, you need first to set up a libgda data source.</para>
- </refsect1>
- <refsect1>
- <title>Examples</title>
- <para/>
- <para>To get all the data from the table "Customers" present in the "mydatasource" GDA data source, you would use:</para>
- <para><function>EXECSQL</function>("mydatasource","username","password","SELECT * FROM customers")</para>
- </refsect1>
- <refsect1>
- <title>See also</title>
- <para><link linkend="gnumeric-READDBTABLE"><function>READDBTABLE</function></link>.
- </para>
- </refsect1>
- </refentry>
<refentry id="gnumeric-GETPIVOTDATA">
<refmeta>
<refentrytitle>
@@ -2403,38 +2371,6 @@
</para>
</refsect1>
</refentry>
- <refentry id="gnumeric-READDBTABLE">
- <refmeta>
- <refentrytitle>
- <function>READDBTABLE</function>
- </refentrytitle>
- </refmeta>
- <refnamediv>
- <refname>
- <function>READDBTABLE</function>
- </refname>
- <refpurpose/>
- </refnamediv>
- <refsynopsisdiv>
- <synopsis><function>READDBTABLE</function>(<parameter>dsn</parameter>,<parameter>username</parameter>,<parameter>password</parameter>,<parameter>table</parameter>)</synopsis>
- </refsynopsisdiv>
- <refsect1>
- <title>Description</title>
- <para>The <function>READDBTABLE</function> function lets you get the contents of a table, as stored in a database. For using it, you need first to set up a libgda data source.</para>
- <para>Note that this function returns all the rows in the given table. If you want to get data from more than one table or want a more precise selection (conditions), use the EXECSQL function.</para>
- </refsect1>
- <refsect1>
- <title>Examples</title>
- <para/>
- <para>To get all the data from the table "Customers" present in the "mydatasource" GDA data source, you would use:</para>
- <para><function>READDBTABLE</function>("mydatasource","username","password","customers")</para>
- </refsect1>
- <refsect1>
- <title>See also</title>
- <para><link linkend="gnumeric-EXECSQL"><function>EXECSQL</function></link>.
- </para>
- </refsect1>
- </refentry>
</sect1>
<sect1 id="CATEGORY_DateTime">
<title>Date/Time</title>
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]