tdf#144712 Add extended tips to special database settings dialog

Change-Id: I897353be6b42d8d867e7cc6036b0e8555172b80e
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/122719
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>

1 files changed, 90 insertions, 0 deletions

diff --git a/dbaccess/uiconfig/ui/specialsettingspage.ui b/dbaccess/uiconfig/ui/specialsettingspage.ui
index 560689c9b975..9281d4cd479e 100644
--- a/dbaccess/uiconfig/ui/specialsettingspage.ui
+++ b/dbaccess/uiconfig/ui/specialsettingspage.ui
@@ -27,6 +27,11 @@
             <property name="no-show-all">True</property>
             <property name="use-underline">True</property>
             <property name="draw-indicator">True</property>
+            <child internal-child="accessible">
+              <object class="AtkObject" id="usesql92-atkobject">
+                <property name="AtkObject::accessible-description" translatable="yes" context="specialsettingspage|extended_tip|usesql92">Only allows characters that conform to the SQL92 naming convention in a name in a data source. All other characters are rejected. Each name must begin with a lowercase letter, an uppercase letter, or an underscore ( _ ). The remaining characters can be ASCII letters, numbers, and underscores.</property>
+              </object>
+            </child>
           </object>
           <packing>
             <property name="left-attach">0</property>
@@ -41,6 +46,11 @@
             <property name="no-show-all">True</property>
             <property name="use-underline">True</property>
             <property name="draw-indicator">True</property>
+            <child internal-child="accessible">
+              <object class="AtkObject" id="append-atkobject">
+                <property name="AtkObject::accessible-description" translatable="yes" context="specialsettings|extended_tip|append">Appends the alias to the table name in SELECT statements.</property>
+              </object>
+            </child>
           </object>
           <packing>
             <property name="left-attach">0</property>
@@ -55,6 +65,11 @@
             <property name="no-show-all">True</property>
             <property name="use-underline">True</property>
             <property name="draw-indicator">True</property>
+            <child internal-child="accessible">
+              <object class="AtkObject" id="useas-atkobject">
+                <property name="AtkObject::accessible-description" translatable="yes" context="specialsettingspage|extended_tip|useas">Some databases use the keyword "AS" between a name and its alias, while other databases use a whitespace. Enable this option to insert AS before the alias.</property>
+              </object>
+            </child>
           </object>
           <packing>
             <property name="left-attach">0</property>
@@ -69,6 +84,11 @@
             <property name="no-show-all">True</property>
             <property name="use-underline">True</property>
             <property name="draw-indicator">True</property>
+            <child internal-child="accessible">
+              <object class="AtkObject" id="useoj-atkobject">
+                <property name="AtkObject::accessible-description" translatable="yes" context="specialsettingsoage|extended_tip|useoj">Use escape sequences for outer joins. The syntax for this escape sequence is {oj outer-join}</property>
+              </object>
+            </child>
           </object>
           <packing>
             <property name="left-attach">0</property>
@@ -83,6 +103,11 @@
             <property name="no-show-all">True</property>
             <property name="use-underline">True</property>
             <property name="draw-indicator">True</property>
+            <child internal-child="accessible">
+              <object class="AtkObject" id="ignoreprivs-atkobject">
+                <property name="AtkObject::accessible-description" translatable="yes" context="specialsettingspage|extended_tip|ignoreprivs">Ignores access privileges that are provided by the database driver.</property>
+              </object>
+            </child>
           </object>
           <packing>
             <property name="left-attach">0</property>
@@ -97,6 +122,11 @@
             <property name="no-show-all">True</property>
             <property name="use-underline">True</property>
             <property name="draw-indicator">True</property>
+            <child internal-child="accessible">
+              <object class="AtkObject" id="replaceparams-atkobject">
+                <property name="AtkObject::accessible-description" translatable="yes" context="specialsettingspage|extended_tip|replaceparams">Replaces named parameters in a data source with a question mark (?).</property>
+              </object>
+            </child>
           </object>
           <packing>
             <property name="left-attach">0</property>
@@ -111,6 +141,11 @@
             <property name="no-show-all">True</property>
             <property name="use-underline">True</property>
             <property name="draw-indicator">True</property>
+            <child internal-child="accessible">
+              <object class="AtkObject" id="displayver-atkobject">
+                <property name="AtkObject::accessible-description" translatable="yes" context="specialsettingspage|extended_tip|displayver">Displays the internal version number of the record in the database table.</property>
+              </object>
+            </child>
           </object>
           <packing>
             <property name="left-attach">0</property>
@@ -125,6 +160,11 @@
             <property name="no-show-all">True</property>
             <property name="use-underline">True</property>
             <property name="draw-indicator">True</property>
+            <child internal-child="accessible">
+              <object class="AtkObject" id="usecatalogname-atkobject">
+                <property name="AtkObject::accessible-description" translatable="yes" context="specialsettingspage|extended_tip|usecatalogname">Uses the current data source of the catalog. This option is useful when the ODBC data source is a database server. Do not select this option if the ODBC data source is a dBASE driver.</property>
+              </object>
+            </child>
           </object>
           <packing>
             <property name="left-attach">0</property>
@@ -139,6 +179,11 @@
             <property name="no-show-all">True</property>
             <property name="use-underline">True</property>
             <property name="draw-indicator">True</property>
+            <child internal-child="accessible">
+              <object class="AtkObject" id="useschemaname-atkobject">
+                <property name="AtkObject::accessible-description" translatable="yes" context="specialsettingspage|extended_tip|useschemaname">Allows you to use the schema name in SELECT statements.</property>
+              </object>
+            </child>
           </object>
           <packing>
             <property name="left-attach">0</property>
@@ -153,6 +198,11 @@
             <property name="no-show-all">True</property>
             <property name="use-underline">True</property>
             <property name="draw-indicator">True</property>
+            <child internal-child="accessible">
+              <object class="AtkObject" id="createindex-atkobject">
+                <property name="AtkObject::accessible-description" translatable="yes" context="specialsettingspage|extended_tip|createindex">Creates an index with ASC or DESC statements.</property>
+              </object>
+            </child>
           </object>
           <packing>
             <property name="left-attach">0</property>
@@ -167,6 +217,11 @@
             <property name="no-show-all">True</property>
             <property name="use-underline">True</property>
             <property name="draw-indicator">True</property>
+            <child internal-child="accessible">
+              <object class="AtkObject" id="eol-atkobject">
+                <property name="AtkObject::accessible-description" translatable="yes" context="specialsettingspage|extended_tip|eol">Select to use the CR + LF code pair to end every text line (preferred for DOS and Windows operating systems).</property>
+              </object>
+            </child>
           </object>
           <packing>
             <property name="left-attach">0</property>
@@ -181,6 +236,11 @@
             <property name="no-show-all">True</property>
             <property name="use-underline">True</property>
             <property name="draw-indicator">True</property>
+            <child internal-child="accessible">
+              <object class="AtkObject" id="ignorecurrency-atkobject">
+                <property name="AtkObject::accessible-description" translatable="yes" context="specialsettingspage|extended_tip|ignorecurrency">Only for Oracle JDBC connections. When enabled it specifies that no column is treated as a currency field. The field type returned from the database driver is discarded.</property>
+              </object>
+            </child>
           </object>
           <packing>
             <property name="left-attach">0</property>
@@ -195,6 +255,11 @@
             <property name="no-show-all">True</property>
             <property name="use-underline">True</property>
             <property name="draw-indicator">True</property>
+            <child internal-child="accessible">
+              <object class="AtkObject" id="inputchecks-atkobject">
+                <property name="AtkObject::accessible-description" translatable="yes" context="specialsettingspage|extended_tip|inputchecks">When you enter a new record or update an existing record in a form, and you leave a field empty which is bound to a database column which requires input, then you will see a message complaining about the empty field.</property>
+              </object>
+            </child>
           </object>
           <packing>
             <property name="left-attach">0</property>
@@ -209,6 +274,11 @@
             <property name="no-show-all">True</property>
             <property name="use-underline">True</property>
             <property name="draw-indicator">True</property>
+            <child internal-child="accessible">
+              <object class="AtkObject" id="useodbcliterals-atkobject">
+                <property name="AtkObject::accessible-description" translatable="yes" context="specialsettingspage|extended_tip|useodbcliterals">Use date/time literals that conform to ODBC standard.</property>
+              </object>
+            </child>
           </object>
           <packing>
             <property name="left-attach">0</property>
@@ -223,6 +293,11 @@
             <property name="no-show-all">True</property>
             <property name="use-underline">True</property>
             <property name="draw-indicator">True</property>
+            <child internal-child="accessible">
+              <object class="AtkObject" id="primarykeys-atkobject">
+                <property name="AtkObject::accessible-description" translatable="yes" context="specialsettingspage|extended_tip|primarykeys">Enable to overrule Base's heuristics used to detect whether the database supports primary keys.</property>
+              </object>
+            </child>
           </object>
           <packing>
             <property name="left-attach">0</property>
@@ -237,6 +312,11 @@
             <property name="no-show-all">True</property>
             <property name="use-underline">True</property>
             <property name="draw-indicator">True</property>
+            <child internal-child="accessible">
+              <object class="AtkObject" id="resulttype-atkobject">
+                <property name="AtkObject::accessible-description" translatable="yes" context="specialsettingspage|extended_tip|resulttype">Use the database driver different scroll capabilities of a result set.</property>
+              </object>
+            </child>
           </object>
           <packing>
             <property name="left-attach">0</property>
@@ -274,6 +354,11 @@
                   <item translatable="yes" context="specialsettingspage|comparison">Mixed</item>
                   <item translatable="yes" context="specialsettingspage|comparison">MS Access</item>
                 </items>
+                <child internal-child="accessible">
+                  <object class="AtkObject" id="comparison-atkobject">
+                    <property name="AtkObject::accessible-description" translatable="yes" context="specialsettingspage|extended_tip|comparison">Select the type of Boolean comparison that you want to use.</property>
+                  </object>
+                </child>
               </object>
               <packing>
                 <property name="left-attach">1</property>
@@ -301,6 +386,11 @@
                 <property name="activates-default">True</property>
                 <property name="truncate-multiline">True</property>
                 <property name="adjustment">adjustment1</property>
+                <child internal-child="accessible">
+                  <object class="AtkObject" id="rows-atkobject">
+                    <property name="AtkObject::accessible-description" translatable="yes" context="specialsettingspage|extended_tip|rows">Select the number of rows to let the driver detect the data type.</property>
+                  </object>
+                </child>
               </object>
               <packing>
                 <property name="left-attach">1</property>