|
631.
|
|
|
@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
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
|
(no translation yet)
|
|
|
|
632.
|
|
|
@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
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
|
(no translation yet)
|
|
|
|
633.
|
|
|
@FUNCTION=NT_PHI
@SYNTAX=NT_PHI(n)
@DESCRIPTION=NT_PHI function calculates the number of integers less than or equal to @n that are relatively prime to @n.
@EXAMPLES=
@SEEALSO=NT_D, ITHPRIME, NT_SIGMA
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
|
(no translation yet)
|
|
|
|
634.
|
|
|
@FUNCTION=NT_MU
@SYNTAX=NT_MU(n)
@DESCRIPTION=NT_MU function (Möbius mu function) returns
0 if @n is divisible by the square of a prime .
Otherwise it returns:
-1 if @n has an odd number of different prime factors .
1 if @n has an even number of different prime factors .
* If @n = 1 NT_MU returns 1.
@EXAMPLES=
@SEEALSO=NT_D, ITHPRIME, NT_PHI
|
|
|
xgettext: you can translate the funny character as an 'o' if unicode is not available.
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
represents a space character.
Enter a space in the equivalent position in the translation.
|
|
|
|
(no translation yet)
|
|
|
|
Located in
../plugins/numtheory/numtheory.c:258
|
|
635.
|
|
|
@FUNCTION=NT_D
@SYNTAX=NT_D(n)
@DESCRIPTION=NT_D function calculates the number of divisors of @n.
@EXAMPLES=
@SEEALSO=ITHPRIME, NT_PHI, NT_SIGMA
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
|
(no translation yet)
|
|
|
|
636.
|
|
|
@FUNCTION=NT_SIGMA
@SYNTAX=NT_SIGMA(n)
@DESCRIPTION=NT_SIGMA function calculates the sum of the divisors of @n.
@EXAMPLES=
@SEEALSO=NT_D, ITHPRIME, NT_PHI
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
|
(no translation yet)
|
|
|
|
637.
|
|
|
@FUNCTION=ITHPRIME
@SYNTAX=ITHPRIME(i)
@DESCRIPTION=ITHPRIME function returns the @ith prime.
@EXAMPLES=
@SEEALSO=NT_D, NT_SIGMA
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
|
(no translation yet)
|
|
|
|
638.
|
|
|
@FUNCTION=ISPRIME
@SYNTAX=ISPRIME(i)
@DESCRIPTION=ISPRIME function returns TRUE if @i is prime and FALSE otherwise.
@EXAMPLES=
@SEEALSO=ITHPRIME, NT_D, NT_SIGMA
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
|
(no translation yet)
|
|
|
|
639.
|
|
|
@FUNCTION=PFACTOR
@SYNTAX=PFACTOR(n)
@DESCRIPTION=PFACTOR function returns the smallest prime factor of its argument.
The argument must be at least 2, or else a #VALUE! error is returned.
@EXAMPLES=
@SEEALSO=ITHPRIME
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
|
(no translation yet)
|
|
|
|
640.
|
|
|
@FUNCTION=NT_PI
@SYNTAX=NT_PI(n)
@DESCRIPTION=NT_PI function returns the number of primes less than or equal to @n.
@EXAMPLES=
@SEEALSO=ITHPRIME, NT_PHI, NT_D, NT_SIGMA
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
|
(no translation yet)
|
|
|