LibreOffice Help - master/text/shared/02 — Sinhala @ TDF Weblate - LibreOffice: <bookmark_value>forms; data</bookmark_value><bookmark_value>data; forms and subforms</bookmark_value><bookmark_value>forms; subforms</bookmark_value><bookmark_value>subforms; description</bookmark

Translation

Context 01170203.xhp bm_id3150040 help.text

English cGxUc

Sinhala

Needs editing

Insufficient privileges for saving translations.

Skip

Context	English	Sinhala
01170202.xhp par_id3147396 help.text	<ahelp hid=".">The<emph> Fill parameters </emph>event occurs when the form to be loaded has parameters that must be filled out.</ahelp> For example, the data source of the form can be the following SQL command:
01170202.xhp par_id3148773 help.text	<literal>SELECT * FROM address WHERE name=:name</literal>
01170202.xhp par_id3149581 help.text	Here :name is a parameter that must be filled out when loading. The parameter is automatically filled out from the parent form if possible. If the parameter cannot be filled out, this event is called and a linked macro can fill out the parameter. Return <literal>True</literal> when the execution of the parametrized statement should continue, <literal>False</literal> otherwise.
01170202.xhp bm_id372700961200031 help.text	<bookmark_value>API;XSQLErrorListener</bookmark_value>
01170202.xhp hd_id3146926 help.text	Error occurred
01170202.xhp par_id3149485 help.text	<ahelp hid=".">The<emph> Error occurred </emph>event is activated if an error occurs when accessing the data source.</ahelp> This applies to forms, list boxes and combo boxes.
01170202.xhp hd_id351601902633144 help.text	Vetoable events
01170202.xhp par_id311600962806301 help.text	Macros can interrupt event execution when they return a boolean value: <literal>True</literal> allows the execution of the event to continue and <literal>False</literal> stops the event execution.
01170202.xhp par_id881601902428903 help.text	The following events are interruptable by returning <literal>False</literal>:
01170202.xhp par_id441601902102235 help.text	Before record action
01170202.xhp par_id51601902106123 help.text	Before record change
01170202.xhp par_id451601902107636 help.text	Before submitting
01170202.xhp par_id821601902108413 help.text	Before update
01170202.xhp par_id81601902108958 help.text	Fill parameters
01170203.xhp tit help.text	Data	දත්ත
01170203.xhp bm_id3150040 help.text	<bookmark_value>forms; data</bookmark_value><bookmark_value>data; forms and subforms</bookmark_value><bookmark_value>forms; subforms</bookmark_value><bookmark_value>subforms; description</bookmark_value>	<බූක්මර්ක්_වලුඑ>පෝරම;දත්ත </බූක්මර්ක්_වලුඑ><බූක්මර්ක්_වලුඑ>දත්ත; පෝරම සහා අනුපෝරම</බූක්මර්ක්_වලුඑ><බූක්මර්ක්_වලුඑ>පෝරම; අනුපෝරම</බූක්මර්ක්_වලුඑ><බූක්මර්ක්_වලුඑ>අනුපපෝරම;විස්තරය</බූක්මර්ක්_වලුඑ>
01170203.xhp hd_id3150040 help.text	<link href="text/shared/02/01170203.xhp">Data</link>	<link href="text/shared/02/09050000.xhp">සොයන්න</link>
01170203.xhp par_id3147242 help.text	The<emph> Data </emph>tab page defines the form properties that refer to the database that is linked to the form.	<emph> දත්ත</emph>tab පිටුව අර්ට්දක්වන්නේ දත්ත සමුදායට සම්බන්ධ් පෝරම වල පෝරම ගුණාංගයි.
01170203.xhp par_id3149398 help.text	Defines the data source on which the form is based, or specifies whether the data can be edited by the user. Apart from the sort and filter functions, you will also find all the necessary properties to create a <link href="text/shared/02/01170203.xhp">subform</link>.
01170203.xhp hd_id3154810 help.text	Data source	දත්ත මුලාශ්‍රය
01170203.xhp par_id3152349 help.text	<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"><emph>Open</emph></link> dialog, where you can choose a data source.
01170203.xhp hd_id3146948 help.text	Content	අන්තර්ගතය
01170203.xhp par_id3155922 help.text	<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>
01170203.xhp par_id3149657 help.text	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.
01170203.xhp hd_id3148755 help.text	Content type	අන්තර්ගත වර්ගය
01170203.xhp par_id3150541 help.text	<ahelp hid="HID_PROP_CURSORSOURCETYPE">Defines whether the data source is to be an existing database table or query, or if the form is to be generated based on an SQL statement.</ahelp>
01170203.xhp par_id3153192 help.text	If you choose "Table" or "Query", the form will refer to the table or query that you specify under <emph>Content</emph>. If you want to create a new query or a <link href="text/shared/02/01170203.xhp">subform</link>, then you have to choose the "SQL" option. You can then enter the statement for the SQL query or the subform directly in the <emph>List content</emph> box on the Control properties Data tab page.
01170203.xhp hd_id3158409 help.text	Analyze SQL command	SQL විධාන විශ්ලේශණය කිරිම
01170203.xhp par_id3145171 help.text	<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.
01170203.xhp hd_id3154684 help.text	Filter	පෙරිම
01170203.xhp par_id3150449 help.text	<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.

Loading…

No matching activity found.

Browse all string changes

Things to check

XML markup

XML tags in translation do not match source

Reset

Glossary

English	Sinhala
No related strings found in the glossary.

String information

Context

01170203.xhp
bm_id3150040
help.text

Source string description

cGxUc

Source string location

01170203.xhp

String age

4 years ago

Last updated

8 months ago

Source string age

4 years ago

Translation file

si/helpcontent2/source/text/shared/02.po, string 942