OpenOffice.org 2.x Betriebsanweisung Seite 424
- Seite / 508
- Inhaltsverzeichnis
- LESEZEICHEN
Bewertet. / 5. Basierend auf Kundenbewertungen
Chapter 7: Databases and Data Sources
Commands
OpenOffice.org
command
SQL
command
Meaning Condition is satisfied if...
IS EMPTY IS NULL is null ... The field is empty. For Yes/No
fields with three states, this command
automatically queries the
undetermined state (neither Yes nor
No).
IS NOT EMPTY IS NOT NULL is not empty ... the field is not empty.
LIKE (placeholder *
for any number of
characters
placeholder ? for
exactly one character)
LIKE (%
placeholder for
any number of
characters
Placeholder _ for
exactly one
character)
is an element of ... the data field contains the indicated
expression. The (*) placeholder
indicates whether the expression x
occurs at the beginning of (x*), at the
end of (*x) or inside the field content
(*x*).Either the SQL % character or
the familiar (*) file system
placeholder can be entered as a
placeholder in SQL queries in the
$[officename] interface. The * or %
placeholder stands for any number of
characters. The question mark (?) in
the $[officename] interface or the
underscore (_) in SQL queries is used
to represent exactly one character.
NOT LIKE NOT LIKE Is not an element
of
... the field does not contain the
specified expression.
BETWEEN x AND y BETWEEN x
AND y
falls within the
interval [x,y]
... the field contains a value that lies
between the two values x and y.
NOT BETWEEN x
AND y
NOT BETWEEN
x AND y
Does not fall
within the
interval [x,y]
... the field contains a value that does
not lie between the two values x and y.
IN (a; b; c...) Note that
the semicolons are used
as separators in all
value lists!
IN (a, b, c...) contains a, b, c... ... the field contains one of the
specified expressions a, b, c,... Any
number of expressions can be
specified, and the result of the query is
determined by an Or link. The
expressions a, b, c... can be either
numbers or characters
NOT IN (a; b; c...) NOT IN (a, b, c...) does not contain
a, b, c...
... the field does not contain one of the
specified expressions a, b, c,...
= TRUE = TRUE has the value
True
... the field has the value True.
= FALSE = FALSE has the value
false
... the field has the value false.
Examples of Usage
OpenOffice.org User Guide for 2.x 390
- OpenOffice.org User Guide 1
- Feedback 3
- Acknowledgements 3
- Modifications and updates 5
- Contents 7
- Important Features with 2.x 37
- Multiple Language Support 41
- New Charting Module 41
- Help Agent 44
- The Title Bar 48
- The Menu Bar 49
- The Toolbars 49
- Examples of Floating Toolbars 50
- Using Floating Toolbars 51
- The document window 51
- Docking toolbars 51
- Docking windows 52
- Opening and Saving Documents 53
- Saving Documents 56
- Backup a File Automatically 57
- OpenOffice.org File Formats 58
- Sending Documents as E-Mail 61
- Printing Documents 62
- Spellcheck 66
- 5. Click Next 71
- Using Automatic Functions 74
- Undo URL recognition 76
- Turn off URL recognition 76
- Shift+Ctr+N 78
- Find & Replace 79
- Match Case 80
- Searching Backward 81
- Current Selection Only 81
- Searching for Styles 81
- Searching for Text Attributes 81
- Similarity Search 82
- Character Result/Use 83
- Permissions available 87
- Name Type Default 89
- Entering and Formatting Text 94
- Using the keyboard: 95
- Using the mouse: 95
- Deleting characters 96
- Deleting text 96
- Status bar uses 97
- Non-breaking spaces 99
- Non-breaking hyphen 99
- Hyphen, em-dash and en-dash 99
- Creating a link 106
- Delete (Del) 107
- Backspace 107
- Create Page Styles 118
- Editing Page Styles 122
- Page Styles Summary 125
- Defining default Templates 126
- Templates and Styles 127
- Automatic Spellcheck 130
- Using AutoText 131
- AutoText With AutoComplete 134
- Text Frames 135
- Editing Text Frames 136
- Linking Text Frames 136
- Using Text Animation 138
- Character 140
- Drawing Lines in Text 141
- Editing Text With FontWork 142
- Aligning Text With Lines 144
- The Navigator 145
- Other Navigator Features 147
- • Select Update Index/Table 150
- Preparation 153
- Entering Data 153
- Example file 154
- Headings and Numbering 159
- before 170
- Numbering Lines 172
- Tables in Text 173
- Table AutoFormat 175
- Table properties in general 175
- Calculating in Text Documents 177
- Statistical Functions 178
- Trigonometric Functions 178
- More Defined Values 179
- (Ctrl+a) 185
- Defining Captions 191
- Editing or deleting captions 191
- Charts with Linked Data 195
- Automatic hyphenation 206
- Manual Hyphenation 206
- Fixed and Variable Fields 209
- Printing Address Labels 213
- Newsletters 216
- Creating Page Styles 217
- Editing Headers 217
- Editing Columns 217
- Editing Paragraph Styles 218
- Working with Frames 219
- Formatting a Frame 219
- Anchoring Frames 219
- Defining a Frame Wrap 219
- Style for this purpose 221
- Using Automatic Hyphenation 224
- Letters With Envelopes 225
- Get a POSTNET font 229
- Importing into Calc 237
- Exporting from Calc 238
- The Calc Window 239
- Inserting Sheets 241
- Renaming Sheets 241
- =CONVERT( 245
- Calculating With formulae 251
- Handling Multiple Sheets 254
- Formatting a Spreadsheet 257
- Layout of Spreadsheets 259
- Addressing Cells 261
- (') 264
- Using References in formulae 266
- ='file:///C:/ 267
- Using Charts 269
- Database Functions in Calc 274
- Evaluating Data With Calc 283
- Consolidating Data 287
- Applying Goal Seek 289
- Examples 290
- Profit=Quantity * (Selling 291
- Using Scenarios 293
- Validity of Cell Contents 295
- Sample macro: 297
- Page 1 Page 3 299
- Page 2 Page 4 299
- AutoFill 304
- Linking Sheet Information 310
- 7. Click Next 316
- Outline view 320
- In-Slide Effects 321
- Editing Presentations 322
- Using Outline View 324
- NIX-based systems, use 328
- <instdir> 330
- Creating a Business Report 331
- Overview 332
- Introduction 332
- Creating a Slide Show 334
- Working with Connectors 336
- Editing Glue Points 338
- OpenOffice.org Draw Functions 343
- Drawing Curves 353
- Working With Objects 360
- Grouping Objects 362
- Entering Groups 362
- Exiting Groups 362
- Shapes - Merge 365
- Shapes - Subtract 365
- Applying Text to Bitmaps 366
- Working With colours 369
- 3D Globe 377
- 3D Effects: Favourites 379
- 3D Effects: Geometry 380
- 3D Effects: Shading 380
- 3D Effects: Illumination 381
- First Step: 382
- Second Step: 383
- Third Step: 384
- Fourth Step: 386
- Fifth Step: 387
- Using a Grid 389
- Add some more details 392
- Complete the drawing 394
- Using Snap Lines 395
- Creating a database file 398
- Creating a table 399
- Creating a related table 400
- Creating a data entry form 401
- Making data entry easier 402
- Viewing Data 406
- Creating a report 409
- Open the Data Sources window 410
- Refreshing the form 411
- Registering a Data Source 412
- Address Books 413
- Form Design 416
- Available controls 417
- Customizing controls 418
- Associating data with a field 420
- How to use the form 421
- Standard toolbar 422
- Operators 423
- Commands 424
- Further Information 432
- Inserting an object as a copy 433
- Inserting an object as a link 434
- Revision Marking Function 441
- Version Management 444
- Turning on protection 445
- Turning off protection 445
- How to get a Certificate? 448
- Self-signed certificates 449
- Moving Tabs on the Ruler 451
- Deleting Tabs 451
- Changing the Defaults 451
- Changing the colour of Text 452
- More on Templates 453
- Accessing the Sample Macros 455
- The Sample Macros 457
- Formula Entry 458
- Special Formating 461
- − 1 23 4 462
- −1 23 4 462
- Special Characters 463
- Special Operators 464
- Vectors and Matrices 465
- Formatting 466
- 5^(1+3+3^2) 467
- Step-by-Step Procedure 469
- Control 472
- 6. Adf fix 473
- Chapter 13: Xml Enhancements 480
- Creating a new Docbook Filter 485
- Common.xcu 487
- C:\<some 487
- <release>\user\basic 489
- Time for the second test 494
- Time for the third test 495
- They are a guide only 498
Verwandte Produkte und Handbücher für Software-Handbücher OpenOffice.org 2.x
(548 Seiten)© 2020, manymanuals.de. Alle Rechte vorbehalten. | 0.039 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Kommentare zu diesen Handbüchern