Re: Which SQL commands support OpenOffice Base?

2014-04-23 Thread Alexandro Colorado 
Some very good documentation on using base is on the forums.
https://forum.openoffice.org/en/forum/viewforum.php?f=83&sid=5afbe506f0a8c7c597dc6e637a086e39

On 4/23/14, F C. Costero  wrote:
> Hello!
> If you create a Base file using the menu File -> New -> Database -> Create
> a New Database, you will get a Base file that runs HSQLDB version 1.8 as an
> embedded database. The SQL documentation for that is here:
> http://www.hsqldb.org/doc/1.8/guide/ch09.html. I would not recommend using
> the embedded mode for critical work because of the possibility of data
> loss. The data loss is not due to instability of HSQLDB but to the nature
> of the embedded mode.
> If you create a Base file using the menu File -> New -> Database -> Connect
> to an Existing Database, you can connect to an external database through
> JDBC, ODBC or any of the other listed methods. This means you can connect
> to any database engine of your choosing and use its version of SQL.
> More detailed answers are best provided on the user mailing list or on the
> forums at https://forum.openoffice.org/
> Best regards,
> Francis
>
>
> On Wed, Apr 23, 2014 at 3:40 AM, Dima Sidorenko
> wrote:
>
>> Hello!.
>>
>> Which SQL commands support OpenOffice Base?, What server database used in
>> OpenOffice Base?, Dialects which are supported in OpenOffice Base?
>>
>> Sincerely,
>>
>> Sidorenko Dmitriy.
>>
>


-- 
Alexandro Colorado
Apache OpenOffice Contributor
http://www.openoffice.org

-
To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
For additional commands, e-mail: dev-h...@openoffice.apache.org

Re: Which SQL commands support OpenOffice Base?

2014-04-23 Thread F C. Costero 
Hello!
If you create a Base file using the menu File -> New -> Database -> Create
a New Database, you will get a Base file that runs HSQLDB version 1.8 as an
embedded database. The SQL documentation for that is here:
http://www.hsqldb.org/doc/1.8/guide/ch09.html. I would not recommend using
the embedded mode for critical work because of the possibility of data
loss. The data loss is not due to instability of HSQLDB but to the nature
of the embedded mode.
If you create a Base file using the menu File -> New -> Database -> Connect
to an Existing Database, you can connect to an external database through
JDBC, ODBC or any of the other listed methods. This means you can connect
to any database engine of your choosing and use its version of SQL.
More detailed answers are best provided on the user mailing list or on the
forums at https://forum.openoffice.org/
Best regards,
Francis


On Wed, Apr 23, 2014 at 3:40 AM, Dima Sidorenko
wrote:

> Hello!.
>
> Which SQL commands support OpenOffice Base?, What server database used in
> OpenOffice Base?, Dialects which are supported in OpenOffice Base?
>
> Sincerely,
>
> Sidorenko Dmitriy.
>

Re: Which SQL commands support OpenOffice Base?

2014-04-23 Thread Yakov Reztsov 

Hi,

Wed, 23 Apr 2014 14:40:09 +0500 от Dima Sidorenko <>:
>Hello!.
>
>Which SQL commands support OpenOffice Base?, What server database used in
>OpenOffice Base?, Dialects which are supported in OpenOffice Base?
>
>Sincerely,
>
>Sidorenko Dmitriy.
>

https://wiki.openoffice.org/wiki/Built-in_functions_and_Stored_Procedures



-- 

Yakov Reztsov

Which SQL commands support OpenOffice Base?

2014-04-23 Thread Dima Sidorenko 
Hello!.

Which SQL commands support OpenOffice Base?, What server database used in
OpenOffice Base?, Dialects which are supported in OpenOffice Base?

Sincerely,

Sidorenko Dmitriy.