User avatar None

New strings to translate

LibreOffice Help - master / text/sdatabase — Sinhala

13 new strings to translate appeared to the translation. 2 months ago
User avatar None

Resource update

LibreOffice Help - master / text/sdatabase — Sinhala

The "si/helpcontent2/source/text/sdatabase.po" file was changed. 2 months ago
User avatar None

String updated in the repository

LibreOffice Help - master / text/sdatabase — Sinhala

Displays the results of the SQL command that you ran.
 
2 months ago
User avatar None

String updated in the repository

LibreOffice Help - master / text/sdatabase — Sinhala

Output
 
2 months ago
User avatar None

String updated in the repository

LibreOffice Help - master / text/sdatabase — Sinhala

<ahelp hid="dbaccess/ui/directsqldialog/status">Displays the status, including errors, of the SQL command that you ran.</ahelp>
 
2 months ago
User avatar None

String updated in the repository

LibreOffice Help - master / text/sdatabase — Sinhala

<ahelp hid="dbaccess/ui/directsqldialog/sqlhistory">Lists the previously executed SQL commands. To run a command again, click the command, and then click <emph>Execute</emph>.</ahelp>
 
2 months ago
User avatar None

String updated in the repository

LibreOffice Help - master / text/sdatabase — Sinhala

<ahelp hid="dbaccess/ui/directsqldialog/execute">Runs the command that you entered in the <emph>Command to execute</emph> box.</ahelp>
 
2 months ago
User avatar None

String updated in the repository

LibreOffice Help - master / text/sdatabase — Sinhala

Execute
 
2 months ago
User avatar None

String updated in the repository

LibreOffice Help - master / text/sdatabase — Sinhala

Show the result of the SQL SELECT command in the Output box.
 
2 months ago
User avatar None

String updated in the repository

LibreOffice Help - master / text/sdatabase — Sinhala

Show output of "select" statements
 
2 months ago
User avatar None

String updated in the repository

LibreOffice Help - master / text/sdatabase — Sinhala

A useful construction for selecting records based on parts of a text field's content is to add a hidden column with <item type="input">"LIKE '%' || :Part_of_field || '%'"</item> as the criterion. This will select records with an exact match. If a case-insensitive test is wanted, one solution is to use <item type="input">LOWER (Field_Name)</item> as the field and <item type="input">LIKE LOWER ( '%' || :Part_of_field || '%' )</item> as the criterion. Note that the spaces in the criterion are important; if they are left out the SQL parser interprets the entire criterion as a string to be matched. In <link href="text/sdatabase/02010100.xhp#sqlmode">SQL mode</link> this should be typed as <item type="input">LOWER ( "Field_Name" ) LIKE LOWER ( '%' || :Part_of_field || '%' )</item>.
 
2 months ago
User avatar None

String updated in the repository

LibreOffice Help - master / text/sdatabase — Sinhala

In the simplest case, where the user enters a value which is matched for equality, the parameter name with its preceding colon is simply entered in the Criterion row. In <link href="text/sdatabase/02010100.xhp#sqlmode">SQL mode</link> this should be typed as <item type="input">WHERE "Field" = :Parameter_name</item>
 
2 months ago
User avatar None

String updated in the repository

LibreOffice Help - master / text/sdatabase — Sinhala

<ahelp hid="HID_QRYDGN_ROW_CRIT">Specifies a first criteria by which the content of the data field is to be filtered.</ahelp>
 
2 months ago
User avatar None

String updated in the repository

LibreOffice Help - master / text/sdatabase — Sinhala

The lower pane of the Design View is where you define the query. To define a query, specify the database field names to include and the criteria for displaying the fields. To rearrange the columns in the lower pane of the Design View, drag a column header to a new location, or select the column and press <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+arrow key.
 
2 months ago
User avatar None

String updated in the repository

LibreOffice Help - master / text/sdatabase — Sinhala

<link href="text/sdatabase/02010100.xhp" name="Query Design">Query Design</link>
 
2 months ago
User avatar None

New string to translate

LibreOffice Help - master / text/sdatabase — Sinhala

1 new string to translate appeared in the translation. 5 months ago
User avatar None

Resource update

LibreOffice Help - master / text/sdatabase — Sinhala

The "si/helpcontent2/source/text/sdatabase.po" file was changed. 5 months ago
User avatar None

New strings to translate

LibreOffice Help - master / text/sdatabase — Sinhala

2 new strings to translate appeared to the translation. 6 months ago
User avatar None

Resource update

LibreOffice Help - master / text/sdatabase — Sinhala

The "si/helpcontent2/source/text/sdatabase.po" file was changed. 6 months ago
User avatar None

New strings to translate

LibreOffice Help - master / text/sdatabase — Sinhala

8 new strings to translate appeared to the translation. 6 months ago

Search