<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Help Inconsistent with Settings Window"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=144712">144712</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Help Inconsistent with Settings Window
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>7.2.1.1 rc
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>minor
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Documentation
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>flywire0@gmail.com
</td>
</tr>
<tr>
<th>CC</th>
<td>olivier.hallot@libreoffice.org
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="https://bugs.documentfoundation.org/attachment.cgi?id=175248" name="attach_175248" title="Base_External_Table_Advanced-Settings">attachment 175248</a> <a href="https://bugs.documentfoundation.org/attachment.cgi?id=175248&action=edit" title="Base_External_Table_Advanced-Settings">[details]</a></span>
Base_External_Table_Advanced-Settings
In Base requires a SQLite database with a table in it - see
<a href="https://wiki.documentfoundation.org/Documentation/HowTo/Base/Connect_to_SQLite">https://wiki.documentfoundation.org/Documentation/HowTo/Base/Connect_to_SQLite</a>
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</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>