source/text/shared/02/01170102.xhp | 20 ++++++++++----------
source/text/shared/02/01170203.xhp | 29 +++++++++++++++--------------
2 files changed, 25 insertions(+), 24 deletions(-)
New commits:
commit 4b523164742b4eaffb576c0b1f507cf42f236ad5
Author: Gabor Kelemen <kelem...@gnome.hu>
AuthorDate: Tue Jul 2 01:05:50 2019 +0200
Commit: Gabor Kelemen <kelemen.gab...@nisz.hu>
CommitDate: Tue Jul 2 09:28:25 2019 +0200
Fix ahelp HIDs in form control Data pages
Change-Id: Iec13edc72bc5b1dbc83f73be142662917a6505cf
Reviewed-on: https://gerrit.libreoffice.org/74982
Tested-by: Jenkins
Reviewed-by: Gabor Kelemen <kelemen.gab...@nisz.hu>
diff --git a/source/text/shared/02/01170102.xhp
b/source/text/shared/02/01170102.xhp
index 65664d9f0..350ef1093 100644
--- a/source/text/shared/02/01170102.xhp
+++ b/source/text/shared/02/01170102.xhp
@@ -51,7 +51,7 @@
<section id="Section23">
<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_REFVALUE"
id="bm_id3147327" localize="false"/>
<paragraph role="heading" id="hd_id3159121" xml-lang="en-US"
level="2">Reference value (on)<comment>UFI: moved section from 01170101,
changed name</comment></paragraph>
- <paragraph role="paragraph" id="par_id3163812" xml-lang="en-US"><ahelp
hid="HID_PROP_REFVALUE" visibility="hidden">You can enter a reference value for
the web form, which will be remitted to a server when sending the form. With
database forms, the value entered is written in the database field, assigned to
the control field.</ahelp> You can assign a reference value to option buttons
and check boxes. The reference value will be remitted to a server when sending
the web form. With database forms the value entered here will be written in the
database assigned to the control field.</paragraph>
+ <paragraph role="paragraph" id="par_id3163812" xml-lang="en-US"><ahelp
hid="." visibility="hidden">You can enter a reference value for the web form,
which will be remitted to a server when sending the form. With database forms,
the value entered is written in the database field, assigned to the control
field.</ahelp> You can assign a reference value to option buttons and check
boxes. The reference value will be remitted to a server when sending the web
form. With database forms the value entered here will be written in the
database assigned to the control field.</paragraph>
<paragraph role="paragraph" id="par_id3150225"
xml-lang="en-US"><emph>Reference values for web forms</emph></paragraph>
<paragraph role="paragraph" id="par_id3147611" xml-lang="en-US">Reference
values are useful if you design a web form and the information on the status of
the control is to be transmitted to a server. If the control is clicked by the
user, the corresponding reference value is sent to the server.</paragraph>
<paragraph role="paragraph" id="par_id3149570" xml-lang="en-US">For example,
if you have two control fields for the options "feminine" and "masculine", and
assign a reference value of 1 to the field "feminine" and the value 2 to the
"masculine" field, the value 1 is transmitted to the server if a user clicks
the "feminine" field and value 2 is sent if the "masculine" field is
clicked.</paragraph>
@@ -61,7 +61,7 @@
<section id="Section1">
<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_CONTROLSOURCE"
id="bm_id3157976" localize="false"/>
<paragraph role="heading" id="hd_id3148455" xml-lang="en-US" level="2">Data
field</paragraph>
- <paragraph role="paragraph" id="par_id3155852" xml-lang="en-US"><ahelp
hid="HID_PROP_CONTROLSOURCE" visibility="hidden">Specifies the field of the
data source table to which the control refers.</ahelp> With database forms, you
can link controls with the data fields.</paragraph>
+ <paragraph role="paragraph" id="par_id3155852" xml-lang="en-US"><ahelp
hid="." visibility="hidden">Specifies the field of the data source table to
which the control refers.</ahelp> With database forms, you can link controls
with the data fields.</paragraph>
<paragraph role="paragraph" id="par_id3153224" xml-lang="en-US">You have
several possibilities:</paragraph>
<list type="ordered">
<listitem>
@@ -97,7 +97,7 @@
<section id="Section2">
<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_BOUNDCOLUMN"
id="bm_id3150297" localize="false"/>
<paragraph role="heading" id="hd_id3154664" xml-lang="en-US" level="2">Bound
field</paragraph>
- <paragraph role="paragraph" id="par_id3148475" xml-lang="en-US"><ahelp
hid="HID_PROP_BOUNDCOLUMN" visibility="hidden">Use an index to specify the
table field or table SQL query to link to the field that is provided under
<emph>Data field</emph>. Valid values for this property are 1, 2, 3, and so
on.</ahelp><comment>UFI: issue #i32749#</comment></paragraph>
+ <paragraph role="paragraph" id="par_id3148475" xml-lang="en-US"><ahelp
hid="." visibility="hidden">Use an index to specify the table field or table
SQL query to link to the field that is provided under <emph>Data field</emph>.
Valid values for this property are 1, 2, 3, and so on.</ahelp><comment>UFI:
issue #i32749#</comment></paragraph>
<paragraph role="note" id="par_idN10AD2" xml-lang="en-US">If you delete the
contents of the <emph>Bound field</emph> cell in the property browser, the
first field of the result set is used to display and to exchange
data.<comment>UFI: issue #i32749#</comment></paragraph>
<paragraph role="paragraph" id="par_id3154588" xml-lang="en-US">This
property for list boxes defines which data field of a linked table is displayed
in the form.</paragraph>
<paragraph role="paragraph" id="par_id3151213" xml-lang="en-US">If a list
box in the form is to display contents of a table linked to the form table,
then define in the <emph>Type of list contents</emph> field if the display is
determined by an SQL command or the (linked) table is accessed. With the
<emph>Bound field</emph> property, you use an index to specify to which data
field of the query or of the table the list field is linked.</paragraph>
@@ -184,14 +184,14 @@
<section id="Section3">
<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_LISTSOURCETYPE"
id="bm_id3153316" localize="false"/>
<paragraph role="heading" id="hd_id3149772" xml-lang="en-US" level="2">Type of
list contents</paragraph>
- <paragraph role="paragraph" id="par_id3154419" xml-lang="en-US"><ahelp
hid="HID_PROP_LISTSOURCETYPE" visibility="hidden">Determines the data to fill
the lists in list and combo boxes.</ahelp> Determines the data to fill the
lists in list and combo boxes.</paragraph>
+ <paragraph role="paragraph" id="par_id3154419" xml-lang="en-US"><ahelp
hid="." visibility="hidden">Determines the data to fill the lists in list and
combo boxes.</ahelp> Determines the data to fill the lists in list and combo
boxes.</paragraph>
<paragraph role="paragraph" id="par_id3153326" xml-lang="en-US">With the
"Valuelist" option, all entries entered in the <emph>List entries</emph> field
of the <link href="text/shared/02/01170101.xhp"
name="General"><emph>General</emph></link> tab appear in the control. For
database forms, you can use reference values (see the <link
href="text/shared/02/01170102.xhp" name=" References Using Value
Lists"><emph>References Using Value Lists</emph></link> section).</paragraph>
<paragraph role="paragraph" id="par_id3153067" xml-lang="en-US">If the
content of the control is read from a database, you can determine the type of
the data source with the other options. For example, you can choose between
tables and queries.</paragraph>
</section>
<section id="Section4">
<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_LISTSOURCE"
id="bm_id3148839" localize="false"/>
<paragraph role="heading" id="hd_id3153820" xml-lang="en-US" level="2">List
content</paragraph>
- <paragraph role="paragraph" id="par_id3159171" xml-lang="en-US"><ahelp
hid="HID_PROP_LISTSOURCE">With database forms, specifies the data source for
the list content of the form-element. This field can be used to define a value
list for documents without a database connection.</ahelp></paragraph>
+ <paragraph role="paragraph" id="par_id3159171" xml-lang="en-US"><ahelp
hid=".">With database forms, specifies the data source for the list content of
the form-element. This field can be used to define a value list for documents
without a database connection.</ahelp></paragraph>
<paragraph role="paragraph" id="par_id3168456" xml-lang="en-US">In the case
of database forms, the data source determines the entries of the list or combo
box. Depending on the selected type, you have a choice between different data
sources under <emph>List content</emph>, provided that these objects exist in
your database. All available database objects of the type selected under
<emph>Type of list contents</emph> are offered here. If you have selected the
"Value List" option as the type, you can use references for database forms. If
the display of the control is controlled by an SQL command, the SQL statement
is entered here.</paragraph>
<paragraph role="paragraph" id="par_id3155870" xml-lang="en-US">Examples of
SQL statements:</paragraph>
<paragraph role="paragraph" id="par_id3144504" xml-lang="en-US">For list
boxes, an SQL statement may have the following form:</paragraph>
@@ -267,19 +267,19 @@
<section id="Section5">
<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_EMPTY_IS_NULL"
id="bm_id3150628" localize="false"/>
<paragraph role="heading" id="hd_id3148901" xml-lang="en-US" level="2">Empty
string is NULL</paragraph>
- <paragraph role="paragraph" id="par_id3145357" xml-lang="en-US"><ahelp
hid="HID_PROP_EMPTY_IS_NULL">Defines how an empty string input should be
handled. If set to "Yes", an input string of length zero will be treated as a
value NULL. If set to "No", any input will be treated as-is without any
conversion.</ahelp></paragraph>
+ <paragraph role="paragraph" id="par_id3145357" xml-lang="en-US"><ahelp
hid=".">Defines how an empty string input should be handled. If set to "Yes",
an input string of length zero will be treated as a value NULL. If set to "No",
any input will be treated as-is without any conversion.</ahelp></paragraph>
<paragraph role="paragraph" id="par_id0820200812403467" xml-lang="en-US">An
empty string is a string of length zero (<emph>""</emph>). Normally, a value
NULL is not the same as an empty string. In general, a term NULL is used to
denote an undefined value, an unknown value, or "no value has been entered
yet."</paragraph>
<paragraph role="paragraph" id="par_id0820200812403455"
xml-lang="en-US">Database systems vary and they might handle a value NULL
differently. Refer to documentations of the database that you are
using.</paragraph>
</section>
<section id="Section6">
<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_FILTERPROPOSAL"
id="bm_id3149393" localize="false"/>
<paragraph role="heading" id="hd_id3161653" xml-lang="en-US" level="2">Filter
proposal</paragraph>
- <paragraph role="paragraph" id="par_id3151221" xml-lang="en-US"><variable
id="filtervorschlag"><ahelp hid="HID_PROP_FILTERPROPOSAL">While designing your
form, you can set the "Filter proposal" property for each text box in the
<emph>Data</emph> tab of the corresponding <emph>Properties</emph> dialog. In
subsequent searches in the filter mode, you can select from all information
contained in these fields.</ahelp> The field content can then be selected using
the <emph>AutoComplete</emph> function. Note, however, that this function
requires a greater amount of memory space and time, especially when used in
large databases and should therefore be used sparingly.</variable></paragraph>
+ <paragraph role="paragraph" id="par_id3151221" xml-lang="en-US"><variable
id="filtervorschlag"><ahelp hid=".">While designing your form, you can set the
"Filter proposal" property for each text box in the <emph>Data</emph> tab of
the corresponding <emph>Properties</emph> dialog. In subsequent searches in the
filter mode, you can select from all information contained in these
fields.</ahelp> The field content can then be selected using the
<emph>AutoComplete</emph> function. Note, however, that this function requires
a greater amount of memory space and time, especially when used in large
databases and should therefore be used sparingly.</variable></paragraph>
</section>
<section id="Section9">
<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_BOUND_CELL"
id="bm_id4214300" localize="false"/>
<paragraph role="heading" id="par_idN10EE3" xml-lang="en-US" level="2">Linked
cell</paragraph>
- <paragraph role="paragraph" id="par_idN10EE7" xml-lang="en-US"><ahelp
hid="HID_PROP_BOUND_CELL">Specifies the reference to a linked cell on a
spreadsheet. The live state or contents of the control are linked to the cell
contents.</ahelp> The following tables list the controls and their
corresponding link type:</paragraph>
+ <paragraph role="paragraph" id="par_idN10EE7" xml-lang="en-US"><ahelp
hid=".">Specifies the reference to a linked cell on a spreadsheet. The live
state or contents of the control are linked to the cell contents.</ahelp> The
following tables list the controls and their corresponding link
type:</paragraph>
<paragraph role="heading" id="par_idN10EF7" xml-lang="en-US" level="3">Check
box with linked cell</paragraph>
<table id="tbl_id4947965">
<tablerow>
@@ -674,7 +674,7 @@
<section id="Section8">
<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_CELL_EXCHANGE_TYPE"
id="bm_id5563219" localize="false"/>
<paragraph role="heading" id="par_idN11163" xml-lang="en-US"
level="2">Contents of the linked cell</paragraph>
- <paragraph role="paragraph" id="par_idN11167" xml-lang="en-US"><ahelp
hid="HID_PROP_CELL_EXCHANGE_TYPE">Select the mode of linking a list box with a
linked cell on a spreadsheet.</ahelp></paragraph>
+ <paragraph role="paragraph" id="par_idN11167" xml-lang="en-US"><ahelp
hid=".">Select the mode of linking a list box with a linked cell on a
spreadsheet.</ahelp></paragraph>
<list type="ordered">
<listitem>
<paragraph role="paragraph" id="par_idN11179"
xml-lang="en-US"><emph>Linked contents:</emph> Synchronize the text contents of
the selected list box entry with the cell contents. Select "The selected
entry".</paragraph>
@@ -687,7 +687,7 @@
<section id="Section7">
<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_LIST_CELL_RANGE"
id="bm_id9886165" localize="false"/>
<paragraph role="heading" id="par_idN1118B" xml-lang="en-US" level="2">Source
cell range<comment>UFI: in the spec, this is "Source range of the list". Named
it as seen in 680m38</comment></paragraph>
- <paragraph role="paragraph" id="par_idN111A1" xml-lang="en-US"><ahelp
hid="HID_PROP_LIST_CELL_RANGE">Enter a cell range that contains the entries for
a list box or combo box on a spreadsheet.</ahelp> If you enter a multi-column
range, only the contents of the leftmost column are used to fill the
control.</paragraph>
+ <paragraph role="paragraph" id="par_idN111A1" xml-lang="en-US"><ahelp
hid=".">Enter a cell range that contains the entries for a list box or combo
box on a spreadsheet.</ahelp> If you enter a multi-column range, only the
contents of the leftmost column are used to fill the control.</paragraph>
</section>
</sort>
</body>
diff --git a/source/text/shared/02/01170203.xhp
b/source/text/shared/02/01170203.xhp
index 841598405..0edbfd2c7 100644
--- a/source/text/shared/02/01170203.xhp
+++ b/source/text/shared/02/01170203.xhp
@@ -45,11 +45,11 @@
<sort>
<section id="Section1">
<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_DATASOURCE"
id="bm_id3153146" localize="false"/><paragraph role="heading" id="hd_id3154810"
xml-lang="en-US" level="2">Data source<comment>UFI: was
Database</comment></paragraph>
-<paragraph role="paragraph" id="par_id3152349" xml-lang="en-US"><ahelp
hid="HID_PROP_DATASOURCE">Defines the data source to which the form should
refer.</ahelp> If you click the <emph>...</emph> button, you call the <link
href="text/shared/01/01020000.xhp" name="Open"><emph>Open</emph></link> dialog,
where you can choose a data source.</paragraph>
+<paragraph role="paragraph" id="par_id3152349" xml-lang="en-US"><ahelp
hid=".">Defines the data source to which the form should refer.</ahelp> If you
click the <emph>...</emph> button, you call the <link
href="text/shared/01/01020000.xhp" name="Open"><emph>Open</emph></link> dialog,
where you can choose a data source.</paragraph>
</section>
<section id="Section2">
<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_CURSORSOURCE"
id="bm_id3150275" localize="false"/><paragraph role="heading" id="hd_id3146948"
xml-lang="en-US" level="2">Content<comment>UFI: was Data
source</comment></paragraph>
-<paragraph role="paragraph" id="par_id3155922" xml-lang="en-US"><ahelp
hid="HID_PROP_CURSORSOURCE">Determines the content to be used for the form. The
content can be an existing table or a query (previously created in the
database), or it can be defined by an SQL-statement. Before you enter a content
you have to define the exact type in <emph>Content
type</emph>.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3155922" xml-lang="en-US"><ahelp
hid=".">Determines the content to be used for the form. The content can be an
existing table or a query (previously created in the database), or it can be
defined by an SQL-statement. Before you enter a content you have to define the
exact type in <emph>Content type</emph>.</ahelp></paragraph>
<paragraph role="paragraph" id="par_id3149657" xml-lang="en-US">If you have
selected either "Table" or "Query" in <emph>Content type</emph>, the box lists
all the tables and queries set up in the selected database.</paragraph>
</section>
<section id="Section3">
@@ -59,31 +59,32 @@
</section>
<section id="Section4">
<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_ESCAPE_PROCESSING"
id="bm_id3144433" localize="false"/><paragraph role="heading" id="hd_id3158409"
xml-lang="en-US" level="2">Analyze SQL command</paragraph>
-<paragraph role="paragraph" id="par_id3145171" xml-lang="en-US"><ahelp
hid="HID_PROP_ESCAPE_PROCESSING">Specifies whether the SQL statement is to be
analyzed by %PRODUCTNAME.</ahelp> If set to Yes, you can click the
<emph>...</emph> button next to the <emph>Content</emph> list box. This will
open a window where you can graphically create a database query. When you close
that window, the SQL statement for the created query will be inserted in the
<emph>Content</emph> list box.</paragraph>
+<paragraph role="paragraph" id="par_id3145171" xml-lang="en-US"><ahelp
hid=".">Specifies whether the SQL statement is to be analyzed by
%PRODUCTNAME.</ahelp> If set to Yes, you can click the <emph>...</emph> button
next to the <emph>Content</emph> list box. This will open a window where you
can graphically create a database query. When you close that window, the SQL
statement for the created query will be inserted in the <emph>Content</emph>
list box.</paragraph>
</section>
<section id="Section5">
-<!-- removed HID HID_PROP_FILTER_CRITERIA --><paragraph role="heading"
id="hd_id3154684" xml-lang="en-US" level="2">Filter</paragraph>
-<paragraph role="paragraph" id="par_id3150449" xml-lang="en-US"><ahelp
hid="HID_PROP_FILTER_CRITERIA">Enter the required conditions for filtering the
data in the form. The filter specifications follow SQL rules without using the
WHERE clause.</ahelp> For example, if you want to display all records with the
"Mike" forename, type into the data field: Forename = 'Mike'. You can also
combine conditions: Forename = 'Mike' OR Forename = 'Peter'. All records
matching either of these two conditions will be displayed.</paragraph>
+<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_FILTER"
id="bm_id3144434" localize="false"/>
+<paragraph role="heading" id="hd_id3154684" xml-lang="en-US"
level="2">Filter</paragraph>
+<paragraph role="paragraph" id="par_id3150449" xml-lang="en-US"><ahelp
hid=".">Enter the required conditions for filtering the data in the form. The
filter specifications follow SQL rules without using the WHERE clause.</ahelp>
For example, if you want to display all records with the "Mike" forename, type
into the data field: Forename = 'Mike'. You can also combine conditions:
Forename = 'Mike' OR Forename = 'Peter'. All records matching either of these
two conditions will be displayed.</paragraph>
<paragraph role="paragraph" id="par_id3156212" xml-lang="en-US">The filter
function is available in user mode through the <link
href="text/shared/02/12030000.xhp"
name="AutoFilter"><emph>AutoFilter</emph></link> and <link
href="text/shared/02/12090000.xhp" name="Default Filter"><emph>Default
Filter</emph></link> icons on the <link href="text/shared/main0213.xhp"
name="Form Navigation Bar"><emph>Form Navigation</emph> Bar</link>.</paragraph>
</section>
<section id="Section6">
<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_SORT_CRITERIA"
id="bm_id3151353" localize="false"/><paragraph role="heading" id="hd_id3156005"
xml-lang="en-US" level="2">Sort</paragraph>
-<paragraph role="paragraph" id="par_id3163712" xml-lang="en-US"><ahelp
hid="HID_PROP_SORT_CRITERIA">Specifies the conditions to sort the data in the
form. The specification of the sorting conditions follows SQL rules without the
use of the ORDER BY clause.</ahelp> For example, if you want all records of a
database to be sorted in one field in an ascending order and in another field
in a descending order, enter Forename ASC, Name DESC (presuming Forename and
Name are the names of the data fields).</paragraph>
+<paragraph role="paragraph" id="par_id3163712" xml-lang="en-US"><ahelp
hid=".">Specifies the conditions to sort the data in the form. The
specification of the sorting conditions follows SQL rules without the use of
the ORDER BY clause.</ahelp> For example, if you want all records of a database
to be sorted in one field in an ascending order and in another field in a
descending order, enter Forename ASC, Name DESC (presuming Forename and Name
are the names of the data fields).</paragraph>
<paragraph role="paragraph" id="par_id3156444" xml-lang="en-US">The
appropriate icons on the <link href="text/shared/main0213.xhp" name="Form
Navigation Bar"><emph>Form Navigation</emph> Bar</link> can be used in User
mode to sort: <link href="text/shared/02/12010000.xhp" name="Sort
Ascending"><emph>Sort Ascending</emph></link>, <link
href="text/shared/02/12020000.xhp" name="Sort Descending"><emph>Sort
Descending</emph></link>, <link href="text/shared/02/12100100.xhp"
name="Sort"><emph>Sort</emph></link>.</paragraph>
</section>
<section id="Section7">
<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_DATAENTRY"
id="bm_id3154129" localize="false"/><paragraph role="heading" id="hd_id3148616"
xml-lang="en-US" level="2">Add data only</paragraph>
-<paragraph role="paragraph" id="par_id3153139" xml-lang="en-US"><ahelp
hid="HID_PROP_DATAENTRY">Determines if the form only allows the addition of new
data (Yes) or if it allows other properties as well (No).</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3153139" xml-lang="en-US"><ahelp
hid=".">Determines if the form only allows the addition of new data (Yes) or if
it allows other properties as well (No).</ahelp></paragraph>
<paragraph role="note" id="par_id3148575" xml-lang="en-US">If <emph>Add data
only</emph> is set to "Yes", changing or deleting data is not
possible.</paragraph>
</section>
<section id="Section8">
<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_NAVIGATION"
id="bm_id3155418" localize="false"/><paragraph role="heading" id="hd_id3148455"
xml-lang="en-US" level="2">Navigation bar</paragraph>
-<paragraph role="paragraph" id="par_id3157976" xml-lang="en-US"><ahelp
hid="HID_PROP_NAVIGATION">Specifies whether the navigation functions in the
lower form bar can be used.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3157976" xml-lang="en-US"><ahelp
hid=".">Specifies whether the navigation functions in the lower form bar can be
used.</ahelp></paragraph>
<paragraph role="paragraph" id="par_id3149485" xml-lang="en-US">The "Parent
Form" option is used for subforms. If you choose this option for a subform, you
can navigate using the records of the main form if the cursor is placed in the
subform. A subform is linked to the parent form by a 1:1 relationship, so
navigation is always performed in the parent form.</paragraph>
</section>
<section id="Section9">
<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_CYCLE"
id="bm_id3151282" localize="false"/><paragraph role="heading" id="hd_id3151051"
xml-lang="en-US" level="2">Cycle</paragraph>
-<paragraph role="paragraph" id="par_id3154944" xml-lang="en-US"><ahelp
hid="HID_PROP_CYCLE">Determines how the navigation should be done using the tab
key.</ahelp> Using the tab key, you can move forward in the form. If you
simultaneously press the Shift key, the navigation will follow the opposite
direction. If you reach the last (or the first) field and press the tab key
again, it can have various effects. Define the key control with the following
options:</paragraph>
+<paragraph role="paragraph" id="par_id3154944" xml-lang="en-US"><ahelp
hid=".">Determines how the navigation should be done using the tab key.</ahelp>
Using the tab key, you can move forward in the form. If you simultaneously
press the Shift key, the navigation will follow the opposite direction. If you
reach the last (or the first) field and press the tab key again, it can have
various effects. Define the key control with the following options:</paragraph>
<table id="tbl_id3150658">
<tablerow>
<tablecell colspan="" rowspan="">
@@ -129,19 +130,19 @@
</section>
<section id="Section10">
<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_ALLOW_ADDITIONS"
id="bm_id3155445" localize="false"/><paragraph role="heading" id="hd_id3155064"
xml-lang="en-US" level="2">Allow additions</paragraph>
-<paragraph role="paragraph" id="par_id3154360" xml-lang="en-US"><ahelp
hid="HID_PROP_ALLOW_ADDITIONS">Determines if data can be
added.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3154360" xml-lang="en-US"><ahelp
hid=".">Determines if data can be added.</ahelp></paragraph>
</section>
<section id="Section11">
<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_ALLOW_EDITS"
id="bm_id3083286" localize="false"/><paragraph role="heading" id="hd_id3156054"
xml-lang="en-US" level="2">Allow modifications</paragraph>
-<paragraph role="paragraph" id="par_id3156377" xml-lang="en-US"><ahelp
hid="HID_PROP_ALLOW_EDITS"> Determines if the data can be
modified.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3156377" xml-lang="en-US"><ahelp
hid="."> Determines if the data can be modified.</ahelp></paragraph>
</section>
<section id="Section12">
<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_ALLOW_DELETIONS"
id="bm_id3153924" localize="false"/><paragraph role="heading" id="hd_id3149019"
xml-lang="en-US" level="2">Allow deletions</paragraph>
-<paragraph role="paragraph" id="par_id3148995" xml-lang="en-US"><ahelp
hid="HID_PROP_ALLOW_DELETIONS">Determines if the data can be
deleted.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3148995" xml-lang="en-US"><ahelp
hid=".">Determines if the data can be deleted.</ahelp></paragraph>
</section>
<section id="Section13">
<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_MASTERFIELDS"
id="bm_id3147097" localize="false"/><paragraph role="heading" id="hd_id3153714"
xml-lang="en-US" level="2">Link master fields</paragraph>
-<paragraph role="paragraph" id="par_id3147339" xml-lang="en-US"><ahelp
hid="HID_PROP_MASTERFIELDS">If you create a <link
href="text/shared/02/01170203.xhp" name="subform">subform</link>, enter the
data field of the parent form responsible for the synchronization between
parent and subform.</ahelp> To enter multiple values, press Shift + Enter after
each input line.<comment>UFI: fixes #i22439#</comment></paragraph>
+<paragraph role="paragraph" id="par_id3147339" xml-lang="en-US"><ahelp
hid=".">If you create a <link href="text/shared/02/01170203.xhp"
name="subform">subform</link>, enter the data field of the parent form
responsible for the synchronization between parent and subform.</ahelp> To
enter multiple values, press Shift + Enter after each input line.<comment>UFI:
fixes #i22439#</comment></paragraph>
<paragraph role="paragraph" id="par_id3149568" xml-lang="en-US">The subform is
based on an <link href="text/shared/00/00000005.xhp#sql" name="SQL">SQL</link>
query; more specifically, on a <link
href="text/shared/explorer/database/02010100.xhp" name="Parameter
Query">Parameter Query</link>. If a field name is entered in the <emph>Link
master fields</emph> box, the data contained in that field in the main form is
read to a variable that you must enter in <emph>Link slave fields</emph>. In an
appropriate SQL statement, this variable is compared to the table data that the
subform refers to. Alternatively, you can enter the column name in the
<emph>Link master fields</emph> box.</paragraph>
<paragraph role="paragraph" id="par_id3156089" xml-lang="en-US">Consider the
following example:</paragraph>
<paragraph role="paragraph" id="par_id3151017" xml-lang="en-US">The database
table on which the form is based is, for example, a customer database
("Customer"), where every customer has been given a unique number in a data
field named "Cust_ID". A customer's orders are maintained in another database
table. You now want to see each customer's orders after entering them into the
form. In order to do this you should create a subform. Under <emph>Link master
fields</emph> enter the data field from the customer database which clearly
identifies the customer, that is, Cust_ID. Under <emph>Link slave fields</emph>
enter the name of a variable which is to accept the data of the field Cust_ID,
for example, x.</paragraph>
@@ -154,7 +155,7 @@
</section>
<section id="Section14">
<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_SLAVEFIELDS"
id="bm_id3145789" localize="false"/><paragraph role="heading" id="hd_id3150648"
xml-lang="en-US" level="2">Link slave fields</paragraph>
-<paragraph role="paragraph" id="par_id3149923" xml-lang="en-US"><ahelp
hid="HID_PROP_SLAVEFIELDS">If you create a subform, enter the variable where
possible values from the parent form field can be stored.</ahelp> If a subform
is based on a query, enter the variable that you defined in the query. If you
create a form using an SQL statement entered in the <emph>Data source</emph>
field, enter the variable you used in the statement. You can choose any
variable name. If you want to enter multiple values, press Shift +
Enter.</paragraph>
+<paragraph role="paragraph" id="par_id3149923" xml-lang="en-US"><ahelp
hid=".">If you create a subform, enter the variable where possible values from
the parent form field can be stored.</ahelp> If a subform is based on a query,
enter the variable that you defined in the query. If you create a form using an
SQL statement entered in the <emph>Data source</emph> field, enter the variable
you used in the statement. You can choose any variable name. If you want to
enter multiple values, press Shift + Enter.</paragraph>
<paragraph role="paragraph" id="par_id3155114" xml-lang="en-US">If, for
example, you specified the Customer_ID database field as a parent field under
<emph>Link master fields</emph>, then you can define under <emph>Link slave
fields</emph> the name of the variable in which the values of the Customer_ID
database field are to be stored. If you now specify an SQL statement in the
<emph>Data source</emph> box using this variable, the relevant values are
displayed in the subform.</paragraph>
</section>
</sort>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
