Create a config extension to change a string-list value
Hello. There is a document in the wiki <https://wiki.documentfoundation.org/images/b/b0/LibreOffice_config_extension_writing.pdf> explaining how to create a configuration extensions. In this document it is said that the valid property values are string, boolean, int, short, long, double, binary. Also in the Chapter 15 - Configuration Management <https://wiki.documentfoundation.org/Documentation/DevGuide/Configuration_Management> of the Developers Guide that the same types are supported. But if you search for some config values in Expert configuration, the type may be different of the supported types, for example you con see string-list (or depend on version []string). I’m not able to change any of the string-list configurations with a Configuration extension, don’t mind what of the supported types I use, always fails. How should I change a string-list value? I use something like this, but changing oor:type="xs:string-list" for every of the valid types, and with or without label: oor:name="Common" oor:package="org.openoffice.Office" xmlns:oor="http://openoffice.org/2001/registry; xmlns:xs="http://www.w3.org/2001/XMLSchema;>oor:name="Security">oor:name="SecureURL" oor:type="xs:string-list" oor:finalized="false">"$(work)/BD" Regards -- *Juan C. Sanz*
core.git: connectivity/source
connectivity/source/drivers/firebird/Connection.cxx| 75 + connectivity/source/drivers/firebird/Connection.hxx| 15 -- connectivity/source/drivers/firebird/PreparedStatement.cxx |3 connectivity/source/drivers/firebird/Statement.cxx |5 4 files changed, 38 insertions(+), 60 deletions(-) New commits: commit 829374381d9c9191746d528b52411ad757e39a08 Author: Juan c. Sanz AuthorDate: Mon Nov 6 23:59:16 2023 +0100 Commit: Caolán McNamara CommitDate: Thu Feb 1 14:14:28 2024 +0100 tdf#117118 - Saves data automatically in Firebird embedded database Saves data when disposing connection regardless of whether or not the save button is pressed. Solve Linux problems reported after previous patch (commit 9227fbabe0a33134f56aefdd8ec16024f006a659) was reverted. Change-Id: Idc02930c894560dfdb40265c253ee7c5557fe18b Reviewed-on: https://gerrit.libreoffice.org/c/core/+/159019 Tested-by: Jenkins Tested-by: Caolán McNamara Reviewed-by: Caolán McNamara diff --git a/connectivity/source/drivers/firebird/Connection.cxx b/connectivity/source/drivers/firebird/Connection.cxx index 9b1c83874f5d..5a2be8872485 100644 --- a/connectivity/source/drivers/firebird/Connection.cxx +++ b/connectivity/source/drivers/firebird/Connection.cxx @@ -339,12 +339,6 @@ void Connection::construct(const OUString& url, const Sequence< PropertyValue >& } } -void Connection::notifyDatabaseModified() -{ -if (m_xParentDocument.is()) // Only true in embedded mode -m_xParentDocument->setModified(true); -} - //- XServiceInfo - IMPLEMENT_SERVICE_INFO(Connection, "com.sun.star.sdbc.drivers.firebird.Connection", "com.sun.star.sdbc.Connection") @@ -822,42 +816,9 @@ void SAL_CALL Connection::documentEventOccured( const DocumentEvent& Event ) if ( !(m_bIsEmbedded && m_xEmbeddedStorage.is()) ) return; -SAL_INFO("connectivity.firebird", "Writing .fbk from running db"); -try -{ -runBackupService(isc_action_svc_backup); -} -catch (const SQLException& e) -{ -auto a = cppu::getCaughtException(); -throw WrappedTargetRuntimeException(e.Message, e.Context, a); -} - - -Reference< XStream > xDBStream(m_xEmbeddedStorage->openStreamElement(our_sFBKLocation, -ElementModes::WRITE)); - -// TODO: verify the backup actually exists -- the backup service -// can fail without giving any sane error messages / telling us -// that it failed. -using namespace ::comphelper; -Reference< XComponentContext > xContext = comphelper::getProcessComponentContext(); -Reference< XInputStream > xInputStream; -if (!xContext.is()) -return; - -xInputStream = -OStorageHelper::GetInputStreamFromURL(m_sFBKPath, xContext); -if (xInputStream.is()) -OStorageHelper::CopyInputToOutput( xInputStream, -xDBStream->getOutputStream()); - -// remove old fdb file if exists -uno::Reference< ucb::XSimpleFileAccess > xFileAccess = -ucb::SimpleFileAccess::create(xContext); -if (xFileAccess->exists(m_sFirebirdURL)) -xFileAccess->kill(m_sFirebirdURL); +storeDatabase(); } + // XEventListener void SAL_CALL Connection::disposing(const EventObject& /*rSource*/) { @@ -938,13 +899,43 @@ void Connection::disposing() evaluateStatusVector(status, u"isc_detach_database", *this); } } -// TODO: write to storage again? + +storeDatabase(); cppu::WeakComponentImplHelperBase::disposing(); m_pDatabaseFileDir.reset(); } +void Connection::storeDatabase() +{ +MutexGuard aGuard(m_aMutex); +if (m_bIsEmbedded && m_xEmbeddedStorage.is()) +{ +SAL_INFO("connectivity.firebird", "Writing .fbk from running db"); +try +{ +runBackupService(isc_action_svc_backup); +} +catch (const SQLException& e) +{ +auto a = cppu::getCaughtException(); +throw WrappedTargetRuntimeException(e.Message, e.Context, a); +} +Reference xDBStream( +m_xEmbeddedStorage->openStreamElement(our_sFBKLocation, ElementModes::WRITE)); +using namespace ::comphelper; +Reference xContext = comphelper::getProcessComponentContext(); +Reference xInputStream; +if (!xContext.is()) +return; +xInputStream = OStorageHelper::GetInputStreamFromURL(m_sFBKPath, xContext); +if (xInputStream.is()) +OStorageHelper::CopyInputToOutput(xInputStream, xDBStream->getOutputStream()); +} +} + +
[Libreoffice-commits] core.git: Branch 'libreoffice-7-6' - connectivity/source
connectivity/source/drivers/firebird/Connection.cxx| 89 + connectivity/source/drivers/firebird/Connection.hxx| 14 +- connectivity/source/drivers/firebird/PreparedStatement.cxx |3 connectivity/source/drivers/firebird/Statement.cxx |5 4 files changed, 58 insertions(+), 53 deletions(-) New commits: commit 149735f7bfbd8bdfeb405f281af0d1c17d8327ec Author: Juan C. Sanz AuthorDate: Wed Sep 20 23:41:33 2023 +0200 Commit: Xisco Fauli CommitDate: Thu Sep 21 07:08:05 2023 +0200 Revert "tdf#117118 - Saves data automatically in Firebird embedded database" This reverts commit 9227fbabe0a33134f56aefdd8ec16024f006a659. Reason for revert: This patch generate a new bug, so I revert it until further investigation Change-Id: I4d613db8cef5363c6b276b8646147443871c312a Reviewed-on: https://gerrit.libreoffice.org/c/core/+/157117 Tested-by: Jenkins Reviewed-by: Xisco Fauli diff --git a/connectivity/source/drivers/firebird/Connection.cxx b/connectivity/source/drivers/firebird/Connection.cxx index 4e2bce41267c..5b8cdb7b16d6 100644 --- a/connectivity/source/drivers/firebird/Connection.cxx +++ b/connectivity/source/drivers/firebird/Connection.cxx @@ -339,6 +339,11 @@ void Connection::construct(const OUString& url, const Sequence< PropertyValue >& } } +void Connection::notifyDatabaseModified() +{ +if (m_xParentDocument.is()) // Only true in embedded mode +m_xParentDocument->setModified(true); +} //- XServiceInfo - IMPLEMENT_SERVICE_INFO(Connection, "com.sun.star.sdbc.drivers.firebird.Connection", @@ -817,7 +822,41 @@ void SAL_CALL Connection::documentEventOccured( const DocumentEvent& Event ) if ( !(m_bIsEmbedded && m_xEmbeddedStorage.is()) ) return; -storeDatabase(); +SAL_INFO("connectivity.firebird", "Writing .fbk from running db"); +try +{ +runBackupService(isc_action_svc_backup); +} +catch (const SQLException& e) +{ +auto a = cppu::getCaughtException(); +throw WrappedTargetRuntimeException(e.Message, e.Context, a); +} + + +Reference< XStream > xDBStream(m_xEmbeddedStorage->openStreamElement(our_sFBKLocation, +ElementModes::WRITE)); + +// TODO: verify the backup actually exists -- the backup service +// can fail without giving any sane error messages / telling us +// that it failed. +using namespace ::comphelper; +Reference< XComponentContext > xContext = comphelper::getProcessComponentContext(); +Reference< XInputStream > xInputStream; +if (!xContext.is()) +return; + +xInputStream = +OStorageHelper::GetInputStreamFromURL(m_sFBKPath, xContext); +if (xInputStream.is()) +OStorageHelper::CopyInputToOutput( xInputStream, +xDBStream->getOutputStream()); + +// remove old fdb file if exists +uno::Reference< ucb::XSimpleFileAccess > xFileAccess = +ucb::SimpleFileAccess::create(xContext); +if (xFileAccess->exists(m_sFirebirdURL)) +xFileAccess->kill(m_sFirebirdURL); } // XEventListener void SAL_CALL Connection::disposing(const EventObject& /*rSource*/) @@ -899,59 +938,13 @@ void Connection::disposing() evaluateStatusVector(status, u"isc_detach_database", *this); } } - -storeDatabase(); +// TODO: write to storage again? cppu::WeakComponentImplHelperBase::disposing(); m_pDatabaseFileDir.reset(); } -void Connection::storeDatabase() -{ -MutexGuard aGuard(m_aMutex); - -if (m_bIsEmbedded && m_xEmbeddedStorage.is()) -{ -SAL_INFO("connectivity.firebird", "Writing .fbk from running db"); -try -{ -runBackupService(isc_action_svc_backup); -} -catch (const SQLException& e) -{ -auto a = cppu::getCaughtException(); -throw WrappedTargetRuntimeException(e.Message, e.Context, a); -} - -Reference xDBStream( -m_xEmbeddedStorage->openStreamElement(our_sFBKLocation, ElementModes::WRITE)); - -using namespace ::comphelper; -Reference xContext = comphelper::getProcessComponentContext(); -Reference xInputStream; -if (!xContext.is()) -return; - -xInputStream = OStorageHelper::GetInputStreamFromURL(m_sFBKPath, xContext); -if (xInputStream.is()) -OStorageHelper::CopyInputToOutput(xInputStream, xDBStream->getOutputStream()); - -// remove old fdb and fbk files if exist -uno::Reference xFileAccess -= ucb::SimpleFileAccess::create(xContext); -if (xFileAccess->exists(m_sFireb
[Libreoffice-commits] core.git: connectivity/source
connectivity/source/drivers/firebird/Connection.cxx| 89 + connectivity/source/drivers/firebird/Connection.hxx| 14 +- connectivity/source/drivers/firebird/PreparedStatement.cxx |3 connectivity/source/drivers/firebird/Statement.cxx |5 4 files changed, 58 insertions(+), 53 deletions(-) New commits: commit fbf71a4c21106fbed7c070ba940809fd84c76dfe Author: Juan C. Sanz AuthorDate: Wed Sep 20 23:41:33 2023 +0200 Commit: Xisco Fauli CommitDate: Thu Sep 21 07:07:58 2023 +0200 Revert "tdf#117118 - Saves data automatically in Firebird embedded database" This reverts commit 9227fbabe0a33134f56aefdd8ec16024f006a659. Reason for revert: This patch generate a new bug, so I revert it until further investigation Change-Id: I4d613db8cef5363c6b276b8646147443871c312a Reviewed-on: https://gerrit.libreoffice.org/c/core/+/157116 Tested-by: Jenkins Reviewed-by: Xisco Fauli diff --git a/connectivity/source/drivers/firebird/Connection.cxx b/connectivity/source/drivers/firebird/Connection.cxx index 4e2bce41267c..5b8cdb7b16d6 100644 --- a/connectivity/source/drivers/firebird/Connection.cxx +++ b/connectivity/source/drivers/firebird/Connection.cxx @@ -339,6 +339,11 @@ void Connection::construct(const OUString& url, const Sequence< PropertyValue >& } } +void Connection::notifyDatabaseModified() +{ +if (m_xParentDocument.is()) // Only true in embedded mode +m_xParentDocument->setModified(true); +} //- XServiceInfo - IMPLEMENT_SERVICE_INFO(Connection, "com.sun.star.sdbc.drivers.firebird.Connection", @@ -817,7 +822,41 @@ void SAL_CALL Connection::documentEventOccured( const DocumentEvent& Event ) if ( !(m_bIsEmbedded && m_xEmbeddedStorage.is()) ) return; -storeDatabase(); +SAL_INFO("connectivity.firebird", "Writing .fbk from running db"); +try +{ +runBackupService(isc_action_svc_backup); +} +catch (const SQLException& e) +{ +auto a = cppu::getCaughtException(); +throw WrappedTargetRuntimeException(e.Message, e.Context, a); +} + + +Reference< XStream > xDBStream(m_xEmbeddedStorage->openStreamElement(our_sFBKLocation, +ElementModes::WRITE)); + +// TODO: verify the backup actually exists -- the backup service +// can fail without giving any sane error messages / telling us +// that it failed. +using namespace ::comphelper; +Reference< XComponentContext > xContext = comphelper::getProcessComponentContext(); +Reference< XInputStream > xInputStream; +if (!xContext.is()) +return; + +xInputStream = +OStorageHelper::GetInputStreamFromURL(m_sFBKPath, xContext); +if (xInputStream.is()) +OStorageHelper::CopyInputToOutput( xInputStream, +xDBStream->getOutputStream()); + +// remove old fdb file if exists +uno::Reference< ucb::XSimpleFileAccess > xFileAccess = +ucb::SimpleFileAccess::create(xContext); +if (xFileAccess->exists(m_sFirebirdURL)) +xFileAccess->kill(m_sFirebirdURL); } // XEventListener void SAL_CALL Connection::disposing(const EventObject& /*rSource*/) @@ -899,59 +938,13 @@ void Connection::disposing() evaluateStatusVector(status, u"isc_detach_database", *this); } } - -storeDatabase(); +// TODO: write to storage again? cppu::WeakComponentImplHelperBase::disposing(); m_pDatabaseFileDir.reset(); } -void Connection::storeDatabase() -{ -MutexGuard aGuard(m_aMutex); - -if (m_bIsEmbedded && m_xEmbeddedStorage.is()) -{ -SAL_INFO("connectivity.firebird", "Writing .fbk from running db"); -try -{ -runBackupService(isc_action_svc_backup); -} -catch (const SQLException& e) -{ -auto a = cppu::getCaughtException(); -throw WrappedTargetRuntimeException(e.Message, e.Context, a); -} - -Reference xDBStream( -m_xEmbeddedStorage->openStreamElement(our_sFBKLocation, ElementModes::WRITE)); - -using namespace ::comphelper; -Reference xContext = comphelper::getProcessComponentContext(); -Reference xInputStream; -if (!xContext.is()) -return; - -xInputStream = OStorageHelper::GetInputStreamFromURL(m_sFBKPath, xContext); -if (xInputStream.is()) -OStorageHelper::CopyInputToOutput(xInputStream, xDBStream->getOutputStream()); - -// remove old fdb and fbk files if exist -uno::Reference xFileAccess -= ucb::SimpleFileAccess::create(xContext); -if (xFileAccess->exists(m_sFireb
SQL parser
Hi all, Can somebody answer a couple of questions? Why if LO (I think) only parses SELECT queries, why do we have so many rules for other types of queries (INSERT, UPDATE, etc.) that are never parsed because they can only be executed in direct SQL? Is there any way to check if changes made in /s//qlbison.y/ or/sqlflex.l/ are working correctly? Or a way to see the resut of a request? Thanks. -- *Juan C. Sanz*
[Libreoffice-commits] core.git: Branch 'libreoffice-7-6' - helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit c831ab929d7f39be4be2cc96b72ca3de3e825a6b Author: Juan C. Sanz AuthorDate: Mon Jul 3 13:47:17 2023 +0200 Commit: Gerrit Code Review CommitDate: Mon Jul 3 13:47:17 2023 +0200 Update git submodules * Update helpcontent2 from branch 'libreoffice-7-6' to 71e1ee638af1e19eceaf242338c811f7300869d6 - Add new content to the PostgreSQL connection page Change-Id: I350aa8090026bd151c4a22e9b326dbe5ce304763 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/153831 Tested-by: Jenkins Reviewed-by: Olivier Hallot (cherry picked from commit 040ae26192794bb54ff3db3dc537599d3e72d27f) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/153896 diff --git a/helpcontent2 b/helpcontent2 index 78a8f021db09..71e1ee638af1 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit 78a8f021db09750967e6a757da5d94b5a87cbb9c +Subproject commit 71e1ee638af1e19eceaf242338c811f7300869d6
[Libreoffice-commits] help.git: Branch 'libreoffice-7-6' - source/text
source/text/sdatabase/dabawiz02pgsql.xhp | 21 ++--- 1 file changed, 18 insertions(+), 3 deletions(-) New commits: commit 71e1ee638af1e19eceaf242338c811f7300869d6 Author: Juan C. Sanz AuthorDate: Fri Jun 30 21:03:06 2023 +0200 Commit: Olivier Hallot CommitDate: Mon Jul 3 13:47:17 2023 +0200 Add new content to the PostgreSQL connection page Change-Id: I350aa8090026bd151c4a22e9b326dbe5ce304763 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/153831 Tested-by: Jenkins Reviewed-by: Olivier Hallot (cherry picked from commit 040ae26192794bb54ff3db3dc537599d3e72d27f) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/153896 diff --git a/source/text/sdatabase/dabawiz02pgsql.xhp b/source/text/sdatabase/dabawiz02pgsql.xhp index 3b111bf766..92990dacbf 100644 --- a/source/text/sdatabase/dabawiz02pgsql.xhp +++ b/source/text/sdatabase/dabawiz02pgsql.xhp @@ -23,9 +23,24 @@ PostgreSQL Connection Specifies the options for connecting to PostgreSQL databases. - -DBMS/driver-specific connection string -Enter the driver specific connection string. The connection string is sequence of keyword/value pairs separated by spaces. For example + +Direct connection to PostgreSQL databases +The data for the direct connection to a PostgreSQL database can be provided in two different ways: +Fill in the data +Connection data can be provided by filling in the top three text boxes. Ask the database administrator for the correct data. + + +Database name: type the name of the specific database. + + +Server: provide the URL or IP address of the DBMS server. + + +Port number: enter the port number of the DBMS server. + + +DBMS/driver-specific connection string +Instead of entering the data in the text boxes as explained above, or if you need to specify more parameter for the connection, you can enter the driver specific connection string. The connection string is a sequence of keyword/value pairs separated by spaces. For example dbname=MyDatabase host=myHost port=5432 where
[Libreoffice-commits] core.git: helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit ff9ca1a96b868c955144fd6fc347f2be72be2e48 Author: Juan C. Sanz AuthorDate: Mon Jul 3 12:48:09 2023 +0200 Commit: Gerrit Code Review CommitDate: Mon Jul 3 12:48:09 2023 +0200 Update git submodules * Update helpcontent2 from branch 'master' to 00fdaa24ea0de17c8036c3dd594890d6bf666d16 - Add new content to the PostgreSQL connection page Change-Id: I350aa8090026bd151c4a22e9b326dbe5ce304763 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/153831 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/helpcontent2 b/helpcontent2 index ed6df33b5151..00fdaa24ea0d 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit ed6df33b51517b0abe9a763fd5bea45ba7dd0b9b +Subproject commit 00fdaa24ea0de17c8036c3dd594890d6bf666d16
[Libreoffice-commits] help.git: source/text
source/text/sdatabase/dabawiz02pgsql.xhp | 21 ++--- 1 file changed, 18 insertions(+), 3 deletions(-) New commits: commit 00fdaa24ea0de17c8036c3dd594890d6bf666d16 Author: Juan C. Sanz AuthorDate: Fri Jun 30 21:03:06 2023 +0200 Commit: Olivier Hallot CommitDate: Mon Jul 3 12:48:09 2023 +0200 Add new content to the PostgreSQL connection page Change-Id: I350aa8090026bd151c4a22e9b326dbe5ce304763 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/153831 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/source/text/sdatabase/dabawiz02pgsql.xhp b/source/text/sdatabase/dabawiz02pgsql.xhp index 3b111bf766..92990dacbf 100644 --- a/source/text/sdatabase/dabawiz02pgsql.xhp +++ b/source/text/sdatabase/dabawiz02pgsql.xhp @@ -23,9 +23,24 @@ PostgreSQL Connection Specifies the options for connecting to PostgreSQL databases. - -DBMS/driver-specific connection string -Enter the driver specific connection string. The connection string is sequence of keyword/value pairs separated by spaces. For example + +Direct connection to PostgreSQL databases +The data for the direct connection to a PostgreSQL database can be provided in two different ways: +Fill in the data +Connection data can be provided by filling in the top three text boxes. Ask the database administrator for the correct data. + + +Database name: type the name of the specific database. + + +Server: provide the URL or IP address of the DBMS server. + + +Port number: enter the port number of the DBMS server. + + +DBMS/driver-specific connection string +Instead of entering the data in the text boxes as explained above, or if you need to specify more parameter for the connection, you can enter the driver specific connection string. The connection string is a sequence of keyword/value pairs separated by spaces. For example dbname=MyDatabase host=myHost port=5432 where
[Libreoffice-commits] help.git: AllLangHelp_sdatabase.mk source/text
AllLangHelp_sdatabase.mk |1 source/text/sdatabase/dabawiz00.xhp| 28 +++ source/text/sdatabase/dabawiz01.xhp| 10 -- source/text/sdatabase/dabawiz02access.xhp |4 - source/text/sdatabase/dabawiz02firebird.xhp| 89 + source/text/sdatabase/dabawiz02oracle.xhp |2 source/text/sdatabase/dabawiz02spreadsheet.xhp |2 source/text/sdatabase/dabawiz02text.xhp|2 8 files changed, 110 insertions(+), 28 deletions(-) New commits: commit cac1b0946ef184d11028d3f4f6e767f3e454ffd2 Author: Juan C Sanz AuthorDate: Fri Mar 3 21:06:11 2023 -0300 Commit: Olivier Hallot CommitDate: Sun Mar 5 11:44:08 2023 + tdf#153940 New Help page for Firebird external connection * New help page by Juan C. Sanz * Connection Help pages refactoring by ohallot. Change-Id: I344644473985df809d2bc31be42b8a21467771f9 Signed-off-by: Olivier Hallot Reviewed-on: https://gerrit.libreoffice.org/c/help/+/148203 Tested-by: Jenkins diff --git a/AllLangHelp_sdatabase.mk b/AllLangHelp_sdatabase.mk index 1ab70ab906..9ee532b252 100644 --- a/AllLangHelp_sdatabase.mk +++ b/AllLangHelp_sdatabase.mk @@ -64,6 +64,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,sdatabase,\ helpcontent2/source/text/sdatabase/dabawiz02ado \ helpcontent2/source/text/sdatabase/dabawiz02connection \ helpcontent2/source/text/sdatabase/dabawiz02dbase \ +helpcontent2/source/text/sdatabase/dabawiz02firebird \ helpcontent2/source/text/sdatabase/dabawiz02jdbc \ helpcontent2/source/text/sdatabase/dabawiz02mysql \ helpcontent2/source/text/sdatabase/dabawiz02odbc \ diff --git a/source/text/sdatabase/dabawiz00.xhp b/source/text/sdatabase/dabawiz00.xhp index b8b001787f..59240fdfcb 100644 --- a/source/text/sdatabase/dabawiz00.xhp +++ b/source/text/sdatabase/dabawiz00.xhp @@ -37,7 +37,9 @@ dBASE; database settings (Base) jdbc; database settings (Base) odbc; database settings (Base) -spreadsheets;as databases (base) +Firebird; database settings (Base) +PostgreSQL; database settings (Base) +spreadsheets;as databases (Base) mw added "(Base)" to all entries @@ -51,19 +53,17 @@ -ODBC settings -Set up text file connection - - -Set up Microsoft Access connection -Set up ADO connection - - -Set up dBASE connection -Set up JDBC connection -Set up Oracle database connection -Set up MariaDB and MySQL connection -Set up Spreadsheet connection + + + + + + + + + + + diff --git a/source/text/sdatabase/dabawiz01.xhp b/source/text/sdatabase/dabawiz01.xhp index 0a8b98b8ec..bd37152ac6 100644 --- a/source/text/sdatabase/dabawiz01.xhp +++ b/source/text/sdatabase/dabawiz01.xhp @@ -57,15 +57,7 @@ Select the database type for the existing database connection. The Outlook, Evolution, KDE Address Book, and Seamonkey database types do not need additional information. For other database types, the wizard contains additional pages to specify the required information. The next wizard page is one of the following pages: + -Set up text file connection -Set up Microsoft Access or Microsoft Access 2007 connection -Set up ADO connection -Set up JDBC connection -Set up Oracle database connection - - -ODBC settings -Set up Spreadsheet connection diff --git a/source/text/sdatabase/dabawiz02access.xhp b/source/text/sdatabase/dabawiz02access.xhp index 7eda1c5aa9..66873122f1 100644 --- a/source/text/sdatabase/dabawiz02access.xhp +++ b/source/text/sdatabase/dabawiz02access.xhp @@ -26,8 +26,8 @@ Access databases (base) Microsoft Office;Access databases (base) -mw added 2 new index entriesMicrosoft Access Connection - +mw added 2 new index entries +Microsoft Access Connection Specifies the settings for importing a database file in Microsoft Access or Access 2007 format. See also the English Wiki page https://wiki.documentfoundation.org/MSA-Base_Faq;>https://wiki.documentfoundation.org/MSA-Base_Faq. Microsoft Access database file diff --git a/source/text/sdatabase/dabawiz02firebird.xhp b/source/text/sdatabase/dabawiz02firebird.xhp new file mode 100644 index 00..b2206ef395 --- /dev/null +++ b/source/text/sdatabase/dabawiz02firebird.xhp @@ -0,0 +1,89 @@ + + + + + + +Firebird Connection +/text/sdatabase/dabawiz02firebird.xhp + + + + +Firebird server;setup connection +Firebird connection +database connection;Firebird server + + + +Firebird Connection +Specifies the options for connecting to Firebird external databases. + + +Creating a new Firebird database file + + +Choose File - New - Database and select Connect to an existing database. Click on Next. + + +Click on Create. The Save as dialog opens. Enter a suitable name and location for the database file, and click on Save. The path of the new file is displayed in the wizard text bo
[Libreoffice-commits] core.git: helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit 2e6084dc61040ea113540146ef0709da5e9aa337 Author: Juan C Sanz AuthorDate: Sun Mar 5 08:44:08 2023 -0300 Commit: Gerrit Code Review CommitDate: Sun Mar 5 11:44:08 2023 + Update git submodules * Update helpcontent2 from branch 'master' to cac1b0946ef184d11028d3f4f6e767f3e454ffd2 - tdf#153940 New Help page for Firebird external connection * New help page by Juan C. Sanz * Connection Help pages refactoring by ohallot. Change-Id: I344644473985df809d2bc31be42b8a21467771f9 Signed-off-by: Olivier Hallot Reviewed-on: https://gerrit.libreoffice.org/c/help/+/148203 Tested-by: Jenkins diff --git a/helpcontent2 b/helpcontent2 index 793e57c7e3ee..cac1b0946ef1 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit 793e57c7e3ee1d20e7fcd199dc35af133539b6fa +Subproject commit cac1b0946ef184d11028d3f4f6e767f3e454ffd2
[Libreoffice-commits] core.git: extensions/source forms/source toolkit/source vcl/source
extensions/source/propctrlr/standardcontrol.cxx |4 ++-- forms/source/component/Date.cxx |2 +- toolkit/source/controls/unocontrolmodel.cxx |4 ++-- toolkit/source/controls/unocontrols.cxx |4 ++-- vcl/source/app/weldutils.cxx|4 ++-- vcl/source/control/field2.cxx |4 ++-- 6 files changed, 11 insertions(+), 11 deletions(-) New commits: commit 5d40ced9e8b0aa1e4c07aea56ed8c1bdaa89705f Author: Juan C. Sanz AuthorDate: Thu Sep 8 00:14:39 2022 +0200 Commit: Noel Grandin CommitDate: Thu Sep 8 10:24:01 2022 +0200 Revert "tdf#150569 Modify hardcoded dates to extend the range of accepted dates" This reverts commit b20594f2fc8f6f9fdbf0b257b4e74d95a8d90139. Reason for revert: Further testing has shown some errors in other ways of displaying the data Change-Id: Ic4909f8571c8730ab3ba622c7fad99f2646616ca Reviewed-on: https://gerrit.libreoffice.org/c/core/+/139566 Tested-by: Jenkins Reviewed-by: Noel Grandin diff --git a/extensions/source/propctrlr/standardcontrol.cxx b/extensions/source/propctrlr/standardcontrol.cxx index 1c88f98ecf8c..95b4143c76b8 100644 --- a/extensions/source/propctrlr/standardcontrol.cxx +++ b/extensions/source/propctrlr/standardcontrol.cxx @@ -99,8 +99,8 @@ namespace pcr m_xEntryFormatter.reset(new weld::DateFormatter(*m_xEntry)); m_xEntryFormatter->SetStrictFormat(true); -m_xEntryFormatter->SetMin(::Date(1, 1, 0001)); -m_xEntryFormatter->SetMax(::Date(31, 12, )); +m_xEntryFormatter->SetMin(::Date(1, 1, 1600)); +m_xEntryFormatter->SetMax(::Date(1, 1, )); m_xEntryFormatter->SetExtDateFormat(ExtDateFieldFormat::SystemShort); m_xEntryFormatter->EnableEmptyField(true); diff --git a/forms/source/component/Date.cxx b/forms/source/component/Date.cxx index e2be9e2ef8c1..3305e7695dff 100644 --- a/forms/source/component/Date.cxx +++ b/forms/source/component/Date.cxx @@ -86,7 +86,7 @@ ODateModel::ODateModel(const Reference& _rxFactory) try { if ( m_xAggregateSet.is() ) -m_xAggregateSet->setPropertyValue( PROPERTY_DATEMIN, Any(util::Date(1, 1, 0001)) ); +m_xAggregateSet->setPropertyValue( PROPERTY_DATEMIN, Any(util::Date(1, 1, 1800)) ); } catch( const Exception& ) { diff --git a/toolkit/source/controls/unocontrolmodel.cxx b/toolkit/source/controls/unocontrolmodel.cxx index efd25aa998e7..986f55efbc50 100644 --- a/toolkit/source/controls/unocontrolmodel.cxx +++ b/toolkit/source/controls/unocontrolmodel.cxx @@ -226,8 +226,8 @@ css::uno::Any UnoControlModel::ImplGetDefaultValue( sal_uInt16 nPropId ) const case BASEPROPERTY_PUSHBUTTONTYPE: aDefault <<= sal_Int16(0) /*PushButtonType::STANDARD*/; break; case BASEPROPERTY_MOUSE_WHEEL_BEHAVIOUR:aDefault <<= sal_Int16(awt::MouseWheelBehavior::SCROLL_FOCUS_ONLY); break; -case BASEPROPERTY_DATEMAX: aDefault <<= util::Date( 31, 12, );break; -case BASEPROPERTY_DATEMIN: aDefault <<= util::Date( 1, 1, 0001 ); break; +case BASEPROPERTY_DATEMAX: aDefault <<= util::Date( 31, 12, 2200 );break; +case BASEPROPERTY_DATEMIN: aDefault <<= util::Date( 1, 1, 1900 ); break; case BASEPROPERTY_TIMEMAX: aDefault <<= util::Time(0, 0, 59, 23, false); break; case BASEPROPERTY_TIMEMIN: aDefault <<= util::Time(); break; case BASEPROPERTY_VALUEMAX_DOUBLE: aDefault <<= double(100); break; diff --git a/toolkit/source/controls/unocontrols.cxx b/toolkit/source/controls/unocontrols.cxx index de764e7b8be1..3bc095cf3f03 100644 --- a/toolkit/source/controls/unocontrols.cxx +++ b/toolkit/source/controls/unocontrols.cxx @@ -3433,8 +3433,8 @@ stardiv_Toolkit_UnoControlDateFieldModel_get_implementation( UnoDateFieldControl::UnoDateFieldControl() { -mnFirst = util::Date( 1, 1, 0001 ); -mnLast = util::Date( 31, 12, ); +mnFirst = util::Date( 1, 1, 1900 ); +mnLast = util::Date( 31, 12, 2200 ); mbLongFormat = TRISTATE_INDET; } diff --git a/vcl/source/app/weldutils.cxx b/vcl/source/app/weldutils.cxx index 8e916ce984b9..f17aed238ae8 100644 --- a/vcl/source/app/weldutils.cxx +++ b/vcl/source/app/weldutils.cxx @@ -444,8 +444,8 @@ void DateFormatter::Init() SetOutputHdl(LINK(this, DateFormatter, FormatOutputHdl)); SetInputHdl(LINK(this, DateFormatter, ParseInputHdl)); -SetMin(Date(1, 1, 0001)); -SetMax(Date(31, 12, )); +SetMin(Date(1, 1, 1900)); +SetMax(Date(31, 12, 2200)); } void DateFormatter::SetExtDateFormat(ExtDateFieldFormat eFormat) diff --git a/vcl/source/control/field2.cxx b/vcl/source/control/field2.cxx index 6a
Wrong direct connection to a firebird server
Hello. Since LibreOffice version 7.0, when the username/password step was added, there is the possibility to connect to a Firebird server from Base. To do this in the Database Wizard you can select "Connect to an existing database" and "Firebird file". On step 2, on "Data source URL" you can write something like "server1:databaseName" or "server1:/datadir/datafile.fdb". On step 3, you should provide a username and password that are allowed to connect to the database provided in step 2. In this way (I think) a "direct" connection is established, through the Firebird internal driver. According to the document in https://www.ibphoenix.com/files/Embedded_fb3.pdf, the Engine12.dll library (or libengine12.so), allow the three "providers" (Remote, Engine12 and Loopback) and the selection of the necessary one is done depending on the connection string, so that if you use "server:database" you should be connected by "Remote". But, as it seems from the tests I have done, somehow, the internal driver is modifying this behavior, because the "server:database" connection should be multi-user, however, although the connection is correctly established, the database is locked (as if an embedded connection had been established instead of Remote) and does not allow editing of the data by multiple users simultaneously. I don't know if this behavior has been implemented this way intentionally or it is a bug, but in any case, it would be convenient to be able to establish a direct connection (with the internal driver) in Remote mode (and also in loopback mode) which would be an undeniable benefit for the user who could easily scale from a Firebird data file to a server and multiuser one, without having to establish the cumbersome JDBC or ODBC connections. Are my assumptions correct?, should I report a bug? Regards -- *Juan C. Sanz*
Re: Errors after pull
El 11/11/2021 a las 16:26, Michael Stahl escribió: On 11.11.21 16:05, Juan C. Sanz wrote: C:/cygwin/home/jc/lode/dev/core/sal/rtl/bootstrap.cxx: warning C4651: Se especific□ '/D_HAS_AUTO_PTR_ETC' para el encabezado precompilado pero no para la compilaci□n actual this is due to a recent change that have removed '/D_HAS_AUTO_PTR_ETC' - in this case, all PCHs need to be rebuilt for this so you might as well do "make clean". After a "make clean" and a new (very long) "make" I've done a new pull and next a new make that works as expected. Thanks Regards -- Juan C.
Re: Errors after pull
El 11/11/2021 a las 13:53, Ilmari Lauhakangas escribió: On 11.11.2021 14.44, Juan C. Sanz wrote: I have been able to compile LibreOffice on Windows 10 with the lode installation. The problem I am having, is that every time I do a pull to update the code, when compiling again I get several errors, sometimes missing dll, sometimes other different errors. The only way I have found to avoid those errors, is to do a make --clean, but of course, that makes me start a complete compilation again. Is there a way to avoid compiling all over again? Am I doing something wrong? Please let us know the error output. Ilmari Last time the error was: $ make C:/cygwin/home/jc/lode/opt/bin/make -j 4 -rs -f C:/cygwin/home/jc/lode/dev/core/Makefile.gbuild build [build DEP] LNK:Library/sal3.dll [build CXX] sal/rtl/bootstrap.cxx C:/cygwin/home/jc/lode/dev/core/sal/rtl/bootstrap.cxx: error C2220: la siguiente advertencia se trata como un error C:/cygwin/home/jc/lode/dev/core/sal/rtl/bootstrap.cxx: warning C4651: Se especific□ '/D_HAS_AUTO_PTR_ETC' para el encabezado precompilado pero no para la compilaci□n actual Nota: inclusi□n del archivo: C:\cygwin\home\jc\lode\dev\core\config_host\config_features.h Nota: inclusi□n del archivo: C:\cygwin\home\jc\lode\dev\core\config_host\config_folders.h Nota: inclusi□n del archivo: C:\cygwin\home\jc\lode\dev\core\include\o3tl/lru_map.hxx Nota: inclusi□n del archivo: C:\PROGRA~2\MICROS~2\2019\COMMUN~1\VC\Tools\MSVC\1429~1.301\Include\cassert Nota: inclusi□n del archivo: C:\PROGRA~2\WI3CF2~1\10\Include\10.0.19041.0\ucrt\assert.h [build UPK] libgpg-error-1.37.tar.bz2 [build PAT] glm make[1]: *** [C:/cygwin/home/jc/lode/dev/core/solenv/gbuild/LinkTarget.mk:333: C:/cygwin/home/jc/lode/dev/core/workdir/CxxObject/sal/rtl/bootstrap.o] Error 2 make[1]: *** Waiting for unfinished jobs make: *** [Makefile:288: build] Error 2 But it is not always the same. Many times it complains about missing or unwriteable .dll files. -- *Juan C. *
Errors after pull
Hello I have been able to compile LibreOffice on Windows 10 with the lode installation. The problem I am having, is that every time I do a pull to update the code, when compiling again I get several errors, sometimes missing dll, sometimes other different errors. The only way I have found to avoid those errors, is to do a make --clean, but of course, that makes me start a complete compilation again. Is there a way to avoid compiling all over again? Am I doing something wrong? -- Juan C.
Firebird driver
Hello. I would like to know more about connecting to firebird databases. Could someone tell me which driver (the firebird one, not the libreoffice one) and where to get information about it? Regards -- *Juan C. Sanz*
Help with connection wizard
Hello. I am working on a firebird connection patch that allows remote connection to a firebird server. Now I need to create a page in the database connection wizard to use that connection, but I have no idea where to start. Can anyone give me any hints? Regards -- *Juan C. Sanz*
Licence statement
All of my past & future contributions to LibreOffice may be licensed under the MPLv2/LGPLv3+ dual license. -- *Juan C. Sanz*
License statement
All of my past & future contributions to LibreOffice may be licensed under the MPLv2/LGPLv3+ dual license. -- *Juan C. Sanz*