Translation

02010100.xhp par_id3147481 help.text
English FnXiE
Context English Dzongkha Actions
02010100.xhp
hd_id3153674
help.text
Querying text fields
02010100.xhp
par_id3149134
help.text
To query the content of a text field, you must put the expression between single quotes. The distinction between uppercase and lowercase letters depends on the database in use. LIKE, by definition, is case-sensitive (though some databases don't interpret this strictly).
02010100.xhp
hd_id3149302
help.text
Querying date fields
02010100.xhp
par_id3157998
help.text
<emph>Date fields</emph> are represented as #Date# to clearly identify them as dates. Date, time and date/time constants (literals) used in conditions can be of either the SQL Escape Syntax type, or default SQL2 syntax.
02010100.xhp
par_id31537341
help.text
Date Type Element
02010100.xhp
par_id31537342
help.text
SQL Escape syntax #1 - may be obsolete
02010100.xhp
par_id31537343
help.text
SQL Escape syntax #2
02010100.xhp
par_id31537344
help.text
SQL2 syntax
02010100.xhp
par_id315913111
help.text
Date
02010100.xhp
par_id31559471
help.text
Time
02010100.xhp
par_id31509641
help.text
DateTime
02010100.xhp
par_id3150510
help.text
All date expressions (date literals) must be enclosed with single quotation marks. (Consult the reference for the particular database and connector you are using for more details.)
02010100.xhp
hd_id3150427
help.text
Querying Yes/No fields
02010100.xhp
par_id3149523
help.text
To query Yes/No fields, use the following syntax for dBASE tables:
02010100.xhp
par_id3153180
help.text
Status
02010100.xhp
par_id3147481
help.text
Query criterion
02010100.xhp
par_id3155187
help.text
Example
02010100.xhp
par_id3156092
help.text
Yes
02010100.xhp
par_id3152414
help.text
for dBASE tables: not equal to any given value
02010100.xhp
par_id3151265
help.text
=1 returns all records where the Yes/No field has the status "Yes" or "On" (selected in black),
02010100.xhp
par_id3152450
help.text
No
02010100.xhp
par_id3150997
help.text
.
02010100.xhp
par_id3155331
help.text
=0 returns all records for which the Yes/No field has the status "No" or "Off" (no selection).
02010100.xhp
par_id3154179
help.text
Null
02010100.xhp
par_id3147035
help.text
IS NULL
02010100.xhp
par_id3159385
help.text
IS NULL returns all records for which the Yes/No field has neither of the states Yes or No (selected in gray).
02010100.xhp
par_id3157888
help.text
The syntax depends on the database system used. You should also note that Yes/No fields can be defined differently (only 2 states instead of 3).
02010100.xhp
hd_id3145772
help.text
Parameter queries
02010100.xhp
par_id191120151905346795
help.text
Parameter queries allow the user to input values at run-time. These values are used within the criteria for selecting the records to be displayed. Each such value has a parameter name associated with it, which is used to prompt the user when the query is run.
02010100.xhp
par_id191120151905439551
help.text
Parameter names are preceded by a colon in both the Design and SQL views of a query. This can be used wherever a value can appear. If the same value is to appear more than once in the query, the same parameter name is used.
02010100.xhp
par_id191120151905518123
help.text
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>

Loading…

No matching activity found.
Browse all component changes

Glossary

English Dzongkha
No related strings found in the glossary.

String information

Context
02010100.xhp
par_id3147481
help.text
Source string description
FnXiE
Source string location
02010100.xhp
String age
2 years ago
Source string age
2 years ago
Translation file
dz/helpcontent2/source/text/sdatabase.po, string 255