[Libreoffice-bugs] [Bug 144712] New: Help Inconsistent with Settings Window

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=144712

            Bug ID: 144712
           Summary: Help Inconsistent with Settings Window
           Product: LibreOffice
           Version: 7.2.1.1 rc
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: minor
          Priority: medium
         Component: Documentation
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: flywire0 at gmail.com
                CC: olivier.hallot at libreoffice.org

Created attachment 175248
  --> https://bugs.documentfoundation.org/attachment.cgi?id=175248&action=edit
Base_External_Table_Advanced-Settings

In Base requires a SQLite database with a table in it - see
https://wiki.documentfoundation.org/Documentation/HowTo/Base/Connect_to_SQLite

1. run following SQL in Tools → SQL

CREATE TABLE org(
  name TEXT PRIMARY KEY,
  boss TEXT REFERENCES org
) WITHOUT ROWID;
INSERT INTO org VALUES('Alice',NULL);

2. Right-Click a Table, Database, Advanced Settings

==========

1. Help topic is not in same order as Settings Window which makes it harder to
use.
2. Note: Help 14 "Ignore currency field information" App description is
"Respect the result set type from the database driver"

==========

Help App Description
1    1   Use SQL92 naming constraints
2    3   Use keyword AS before table alias names
3    11  End text lines with CR + LF
4    2   Append the table alias name in SELECT statements
5    4   Use Outer Join syntax '{OJ }'
6    5   Ignore the privileges from the database driver
7    6   Replace named parameters with ?
8    7   Display version columns (when available)
9    8   Use the catalog name in SELECT statements
10   9   Use the schema name in SELECT statements
11   10  Create index with ASC or DESC statement
12   16  Comparison of Boolean values
13   12  Form data input checks for required fields
14   15  Ignore currency field information
15   13  Use ODBC conformant date/time literals
16   14  Supports primary keys

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210925/f1711cc6/attachment.htm>