Sybase InfoMaker 11.5, CD, Win, ENG Specifiche Pagina 641
- Pagina / 828
- Indice
- SEGNALIBRI
Valutato. / 5. Basato su recensioni clienti
CHAPTER 23 Operators and Expressions
Users Guide 619
Arithmetic operators in InfoMaker expressions
When you write an expression, you can use the following arithmetic operators:
Table 23-5: Using expressions with arithmetic operators
Multiplication and
division
Multiplication and division are carried out to full precision (16–18 digits).
Values are rounded:
Table 23-6: Value rounding in InfoMaker expressions
Calculations with null
When you form an arithmetic expression that contains a null value, the
expression becomes
null. Thinking of null as undefined makes this easier to
understand. For example, when a
null column is multiplied by 5, the entire
expression also evaluates to
null. Use the IsNull function to explicitly check for
the null value.
Boolean expressions that contain a null value evaluate to
false rather than to
null. For more information, see “Relational operators in InfoMaker
expressions” next.
Relational operators in InfoMaker expressions
You use relational operators to compare a value with other values. The result is
a boolean expression whose value is always
true or false.
Since the result of a boolean expression is always
true or false, a relational
operator that compares a value to
null evaluates to false. For example, the
expression “column > 5” evaluates to
false (and “NOT column > 5” evaluates
to
true) when the column value is null.
Operator Meaning Example
+ Addition SubTotal + Tax
- Subtraction Price - Discount
* Multiplication Quantity * Price
/ Division Discount / Price
^ Exponentiation Rating ^ 2.5
Expression Value
20.0/3 6.666666666666667
3*(20.0/3) 20
Truncate(20.0/3,4) 6.6666
- InfoMaker 1
- DC37789-01-1150-01 2
- September 2008 2
- PART 2 WORKING WITH DATABASES 5
- PART 3 REPORTS 6
- Contents 10
- Users Guide xiii 13
- PART 5 APPLICATIONS 15
- PART 7 APPENDIXES 19
- About This Book 21
- Other sources of 22
- If you need help 22
- The InfoMaker 23
- Environment 23
- Working with InfoMaker 25
- About InfoMaker 26
- 6 InfoMaker 28
- Users Guide 7 29
- Group report 29
- TreeView report 30
- Users Guide 9 31
- Freeform form 31
- Freeform Grid 31
- Data pipelines 32
- Applications 33
- Database management 33
- The InfoMaker environment 34
- About the PowerBar 35
- Working with libraries 36
- Users Guide 15 37
- ❖ To set the current library: 37
- About creating a new library 37
- Working with objects 38
- Opening existing objects 39
- Working in painters 40
- Opening painters 41
- Painter summary 41
- Using views in painters 41
- Users Guide 21 43
- ❖ To move a pane: 43
- Floating and docking views 44
- Adding and removing views 45
- Saving a layout 46
- Using pop-up menus 46
- Defining colors 47
- Working with tools 48
- Using property pages 49
- Using toolbars 51
- Customizing toolbars 53
- Report /o ReportName /ro 57
- Creating new toolbars 58
- Using report wizards 59
- Using the To-Do List 60
- Using online Help 61
- Windows Help files on Vista 63
- Users Guide 43 65
- Using the file editor 66
- Editing activities 67
- Changing fonts 68
- Users Guide 47 69
- Using the Query Governor 70
- Accessing the Query Governor 71
- About the registry 73
- About the initialization file 73
- Working with Libraries 77
- Creating new libraries 79
- About the Library painter 80
- Using the pop-up menu 82
- Selecting objects 82
- Changing the current library 84
- Users Guide 63 85
- ❖ To open an object: 85
- Setting the root 86
- Modifying comments 87
- Deleting libraries 88
- Optimizing libraries 89
- Regenerating library entries 89
- Rebuilding libraries 90
- Migrating libraries 91
- 70 InfoMaker 92
- Working with Databases 93
- Managing the Database 95
- Users Guide 75 97
- Database views 97
- Extended attributes 98
- Additional database 98
- Managing databases 99
- Using the Database painter 100
- 80 InfoMaker 102
- Logging your work 104
- Users Guide 83 105
- Working with tables 106
- Users Guide 85 107
- About saving the table 107
- Specifying column definitions 108
- Specifying table properties 109
- Dept_name is Dept Name. To 111
- Altering a table 112
- Users Guide 91 113
- ❖ To alter a table: 113
- Closing a table 114
- Dropping a table 115
- Viewing pending SQL changes 115
- Printing the table definition 116
- Exporting table syntax 117
- About system tables 117
- Working with keys 119
- Users Guide 99 121
- Defining primary keys 121
- ❖ To create a primary key: 121
- Naming a primary key 121
- Working with indexes 123
- Working with database views 125
- Users Guide 105 127
- Users Guide 107 129
- ❖ To join tables: 129
- About the Query Governor 129
- Manipulating data 130
- Retrieving data 131
- Modifying data 131
- Sorting rows 132
- Users Guide 111 133
- Precedence of sorting 133
- If you change your mind 133
- Filtering rows 134
- Viewing row information 135
- Importing data 135
- Printing data 136
- Saving data 136
- Creating stored procedures 137
- Controlling comments 138
- Entering SQL 138
- Users Guide 117 139
- Typing SQL 139
- EnableSet=1 139
- Explaining SQL 140
- Executing SQL 140
- Customizing the editor 141
- 120 InfoMaker 142
- Working with Data Pipelines 143
- Defining a data pipeline 144
- Piping extended attributes 145
- Creating a data pipeline 146
- SQL SELECT statement 147
- Users Guide 127 149
- 128 InfoMaker 150
- NULL is allowed for 151
- Choosing a pipeline operation 152
- Users Guide 131 153
- For Oracle databases 153
- When using Refresh 153
- When execution stops 154
- No limit or a number 155
- Piping blob data 156
- SELECT statement. After the 157
- InfoMaker 158
- Correcting pipeline errors 159
- Saving a pipeline 160
- Using an existing pipeline 161
- Pipeline examples 161
- PART 3 Reports 163
- Defining Reports 165
- Using the Tabular style 167
- Using the Freeform style 168
- Using the Grid style 168
- Using the Label style 169
- Using the N-Up style 170
- CHAPTER 5 Defining Reports 171
- Using the Group style 172
- Using the Composite style 172
- Using the OLE 2.0 style 174
- Using the RichText style 174
- Building a report 175
- Selecting a data source 176
- Using Quick Select 178
- Selecting a table 179
- Selecting columns 180
- Specifying sorting criteria 181
- Specifying selection criteria 181
- SQL expression examples 184
- Using SQL Select 187
- Selecting tables and views 188
- Joining tables 192
- Using ANSI outer joins 193
- Using retrieval arguments 195
- Using Query 202
- Using External 202
- Using Stored Procedure 204
- Choosing report-wide options 206
- Saving the report 209
- Modifying an existing report 209
- Defining queries 210
- Saving the query 211
- What's next 212
- Enhancing Reports 213
- The header band 216
- The detail band 217
- The summary and footer bands 218
- Users Guide 197 219
- Lasso selection 219
- Importing data into a report 225
- Using print preview 226
- Working in a grid report 229
- Saving the data as PDF 231
- In the Report painter 232
- System requirements 232
- Saving as PDF using XSL-FO 233
- Saving as XSL-FO 234
- Apache Web site at 235
- Working with PSR files 236
- Changing the report style 238
- Setting colors in a report 239
- Users Guide 219 241
- Users Guide 221 243
- 222 InfoMaker 244
- Modifying text in a report 247
- Naming controls in a report 248
- Using borders in a report 248
- Users Guide 227 249
- RowHeight, you must 250
- SELECT statement 250
- Modifying the result set 252
- What happens at runtime 253
- Retrieving rows as needed 255
- Adding controls to a report 257
- Adding text to a report 258
- Users Guide 237 259
- Adding pictures to a report 260
- Users Guide 239 261
- Tips for using pictures 261
- Adding buttons to a report 265
- Adding graphs to a report 267
- Adding reports to a report 268
- Deleting controls in a report 269
- Moving controls in a report 270
- Copying controls in a report 270
- Resizing controls in a report 271
- Aligning controls in a report 271
- Rotating controls in a report 275
- Users Guide 255 277
- 256 InfoMaker 278
- Presenting the data 280
- About display formats 281
- Working with display formats 282
- Users Guide 261 283
- Edit style takes precedence 283
- Defining display formats 285
- Number display formats 287
- String display formats 289
- Date display formats 289
- Time display formats 291
- About edit styles 292
- Working with edit styles 294
- Users Guide 273 295
- ❖ To create a new edit style: 295
- Defining edit styles 296
- Users Guide 275 297
- ❖ To use the Edit edit style: 297
- The CheckBox edit style 298
- The RadioButtons edit style 299
- The EditMask edit style 300
- NULL value for 301
- Users Guide 281 303
- The RichText edit style 305
- The InkEdit edit style 305
- Defining a code table 306
- How code tables are processed 308
- Validating user input 308
- About validation rules 309
- Working with validation rules 310
- Defining validation rules 311
- Defining the expression 312
- Customizing the error message 313
- Specifying initial values 314
- Specifying the expression 315
- Examples 315
- Full_Price column 316
- Commission column is: 316
- Users Guide 295 317
- 296 InfoMaker 318
- Suppressing repeating values 323
- Grouping rows 324
- Users Guide 303 325
- How to do it 325
- Users Guide 305 327
- What InfoMaker does 327
- Users Guide 307 329
- What you can do 329
- Creating subgroups 329
- Sorting the rows 330
- Rearranging the report 331
- Adding summary statistics 332
- Sorting the groups 334
- Users Guide 313 335
- Highlighting Information in 337
- Reports and Forms 337
- Highlighting information 338
- Users Guide 317 339
- Defining an 339
- Users Guide 319 341
- Example 2: rotating controls 343
- Users Guide 323 345
- Supplying property values 347
- 326 InfoMaker 348
- Background.Color 349
- Brush.Color 351
- Brush.Hatch 351
- Users Guide 331 353
- Description 353
- In the painter 353
- Font.Height 354
- Font.Italic 355
- Font.Strikethrough 356
- Font.Underline 357
- Font.Weight 357
- Pen.Color 359
- Pen.Style 359
- Pen.Width 361
- Timer_Interval 362
- Specifying colors 365
- Using Nested Reports 367
- About nested reports 368
- Users Guide 351 373
- Users Guide 353 375
- Working with nested reports 376
- Users Guide 355 377
- ❖ To adjust report width: 377
- WHERE clause of 379
- SELECT statement: 379
- 362 InfoMaker 384
- Exporting and Importing XML 385
- About XML 386
- XML syntax 387
- XML parsing 388
- Users Guide 367 389
- Xerces parser 389
- Export templates 389
- Import templates 389
- Creating templates 392
- Saving templates 393
- Header and Detail sections 393
- The Detail Start 394
- Moving the separator 394
- Header section 395
- Detail section 395
- Editing XML templates 396
- XML declaration 397
- Document type declaration 398
- Root element 399
- Controls 399
- InfoMaker expressions 400
- Attributes 400
- Composite and nested reports 401
- CDATA sections 403
- Comments 403
- Exporting to XML 404
- The Use Template property 405
- Generating group headers 406
- Formatting the exported XML 409
- Exporting metadata 409
- Importing XML 413
- Default data import 417
- Example with empty elements 420
- Tracing import 421
- Working with Graphs 423
- Parts of a graph 424
- Organization of a graph 425
- Types of graphs 426
- Pie graphs 427
- Scatter graphs 427
- Three-dimensional graphs 428
- Using graphs in reports 430
- Placing a graph in a report 431
- Associating data with a graph 434
- Specifying the categories 435
- Specifying the values 435
- Specifying the series 436
- Users Guide 417 439
- Graphing unit sales of 439
- Graphing unit sales by 439
- Users Guide 419 441
- Graphing actual and 441
- Users Guide 423 445
- Specifying axis properties 449
- Specifying a pointer 451
- 430 InfoMaker 452
- Working with Crosstabs 453
- 432 InfoMaker 454
- Two types of crosstabs 455
- Creating crosstabs 456
- Users Guide 435 457
- Specifying the information 458
- Viewing the crosstab 461
- Users Guide 441 463
- Previewing crosstabs 464
- Enhancing crosstabs 464
- Specifying basic properties 465
- Defining summary statistics 467
- Using crosstab functions 469
- Int function to 471
- Creating static crosstabs 473
- Users Guide 453 475
- 454 InfoMaker 476
- Working with TreeViews 477
- Similarities to the 478
- Group presentation 478
- TreeView creation process 479
- Creating a TreeView report 479
- Users Guide 459 481
- Using an expression 482
- Users Guide 461 483
- Users Guide 463 485
- Other actions you can 485
- TreeView report Design view 486
- Users Guide 465 487
- Specifying images for 487
- Users Guide 469 491
- Property Description 491
- 470 InfoMaker 492
- Working with Rich Text 493
- RichText 493
- Creating the report 495
- Users Guide 475 497
- Editing text 497
- Preview mode and editing text 497
- Inserting a file 497
- ❖ To insert a file: 497
- Headers and footers 498
- The whole RichText report 499
- Selected text and paragraphs 499
- Input fields 500
- Users Guide 479 501
- Computed fields 501
- ❖ To define a computed field: 501
- Predefined computed fields 501
- Pictures 502
- Previewing and printing 503
- Formatting keys and toolbars 504
- 484 InfoMaker 506
- Using OLE in a Report 507
- About using OLE in reports 508
- In this section 510
- Adding an ActiveX control 510
- Users Guide 489 511
- Defining the OLE object 512
- Specifying properties 514
- What the data is for 514
- Specifying a value for 516
- Previewing the report 518
- Creating an OLE column 520
- Users Guide 499 521
- Setting properties for 521
- WHERE id = :id 522
- 502 InfoMaker 524
- Access to the Form painter 525
- Defining Forms 527
- About forms 528
- Creating new forms 529
- Freeform forms 531
- Grid forms 532
- Working in a grid form 533
- CHAPTER 18 Defining Forms 535
- Creating and saving forms 536
- Creating a master/detail form 538
- Generating and saving forms 543
- Saving the form 544
- Working with forms 545
- Limiting the retrieved data 546
- Importing data into a form 547
- Printing forms 549
- Actions in forms 549
- 528 InfoMaker 550
- Accessing and deleting forms 552
- Controlling Updates in Forms 553
- Users Guide 533 555
- Using the primary key 555
- Specifying an identity column 556
- Specifying updatable columns 556
- Employee table, whose key is 558
- WHERE clause columns: 558
- How to choose a 560
- Enhancing Forms 561
- About the PainterBars 563
- About the StyleBar 563
- CHAPTER 20 Enhancing Forms 565
- Printing the form definition 568
- Cutting controls 570
- Sliding controls in a form 573
- Specifying a title for a form 575
- Setting colors for a form 575
- Defining your own colors 576
- Modifying text in a form 577
- ❖ To modify text in a form: 578
- Using borders in a form 579
- What happens 580
- SELECT statement, InfoMaker 582
- Adding controls to the form 583
- Defining a computed field 585
- Adding pictures to a form 587
- Adding reports to a form 590
- 572 InfoMaker 594
- Working with Applications 597
- Creating an application 598
- Users Guide 577 599
- ❖ To create an application: 599
- Users Guide 579 601
- Users Guide 581 603
- Reusing an application 604
- Running an application 605
- Identifying your application 607
- Managing the toolbar 609
- Executing pipelines 610
- ❖ To modify the Commit value: 614
- Users Guide 593 615
- Deploying Your Application 617
- About deploying applications 618
- DayName function returns a 620
- String function to format a 620
- Users Guide 599 621
- Configuring an ODBC driver 622
- Deploying SQL Anywhere files 624
- OLE DB database providers 626
- JDBC database interface 626
- Java support 627
- Saving as PDF and XSL-FO 629
- Using the Apache FO processor 631
- Deploying ActiveX controls 632
- Users Guide 611 633
- 612 InfoMaker 634
- Reference 635
- Operators and Expressions 637
- Where you use expressions 638
- GetText 639
- 'C%' OR 642
- 'G%' 642
- 'C%' 642
- Matching text patterns 648
- 628 InfoMaker 650
- DataWindow Expression and 651
- InfoMaker Functions 651
- Four examples 652
- Users Guide 635 657
- Users Guide 637 659
- RGB(255,255,255)) 659
- What you get 659
- Other examples 661
- InfoMaker functions 662
- CrosstabAvg 675
- Users Guide 655 677
- CrosstabAvg(1) 677
- CrosstabAvgDec 679
- CrosstabCount 680
- CrosstabMax 682
- CrosstabMaxDec 683
- CrosstabMin 684
- CrosstabMinDec 685
- CrosstabSum 687
- CrosstabSumDec 689
- CumulativePercent 690
- CumulativeSum 692
- CurrentRow 693
- Date returns null 694
- DateTime 695
- DayNumber 697
- DaysAfter 698
- 2.0d and 699
- Describe 700
- GetRow determines what 705
- IsExpanded 710
- IsNumber 711
- IsRowModified 711
- IsRowNew 712
- IsSelected 712
- 692 InfoMaker 714
- Max; it is faster 715
- LastPos returns 0. If any 718
- LastPos returns null 718
- Left returns the entire 718
- LeftA returns the entire 719
- LeftTrim 720
- LookUpDisplay 723
- Mid function 731
- MidA returns the 732
- PageAcross 741
- PageCount 741
- PageCountAcross 742
- Percent 744
- Pos returns 0 746
- ProfileInt 747
- ProfileString 749
- Rand function is a 750
- Real returns 0 750
- RelativeDate 751
- RelativeTime 751
- Replace 752
- ReplaceA 753
- Right returns the entire 755
- RightA returns the entire 755
- RightTrim 756
- RowCount 757
- RowHeight 757
- SecondsAfter 759
- Min; it is faster 762
- StDev returns an estimate of 764
- StDev assumes that 765
- StripRTF 770
- Time returns 00:00:00 774
- Truncate 775
- WordCap 782
- 762 InfoMaker 784
- Appendixes 785
- Identifiers 787
- Reserved words 788
- The Extended Attribute 789
- System Tables 789
- 80=Decorative 791
- 770 InfoMaker 792
- CheckBox edit style (code 85) 793
- 772 InfoMaker 794
- 774 InfoMaker 796
- Edit edit style (code 89) 797
- 776 InfoMaker 798
- PBCatEdt only 799
- 778 InfoMaker 800
- Numerics 801
© 2020, manymanuals.it. Tutti i diritti riservati | 0.046 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Commenti su questo manuale