Sybase InfoMaker 11.5, CD, Win, ENG Specification

Users Guide

InfoMaker

®

11.5

DOCUMENT ID: DC37789-01-1150-01

LAST REVISED: September 2008

This publication pertains to Sybase software and to any subsequent release until otherwise indicated in new editions or technical notes.

Information in this document is subject to change without notice. The software described herein is furnished under a license agreement,

and it may be used or copied only in accordance with the terms of that agreement.

To order additional documents, U.S. and Canadian customers should call Customer Fulfillment at (800) 685-8225, fax (617) 229-9845.

Customers in other countries with a U.S. license agreement may contact Customer Fulfillment via the above fax number. All other

international customers should contact their Sybase subsidiary or local distributor. Upgrades are provided only at regularly scheduled

software release dates. No part of this publication may be reproduced, transmitted, or translated in any form or by any means, electronic,

mechanical, manual, optical, or otherwise, without the prior written permission of Sybase, Inc.

Sybase trademarks can be viewed at

the Sybase trademarks page at http://www.sybase.com/detail?id=1011207. Sybase and the marks listed

are trademarks of Sybase, Inc. ® indicates registration in the United States of America.

Java and all Java-based marks are trademarks or registered trademarks of Sun Microsystems, Inc. in the U.S. and other countries.

Unicode and the Unicode Logo are registered trademarks of Unicode, Inc.

All other company and product names mentioned may be trademarks of the respective companies with which they are associated.

Use, duplication, or disclosure by the government is subject to the restrictions set forth in subparagraph (c)(1)(ii) of DFARS 52.227-7013

for the DOD and as set forth in FAR 52.227-19(a)-(d) for civilian agencies.

Sybase, Inc., One Sybase Drive, Dublin, CA 94568.

Contents

Users Guide iii

About This Book......................................................................................................................... xxi

PART 1 THE INFOMAKER ENVIRONMENT

CHAPTER 1 Working with InfoMaker.................................................................. 3

About InfoMaker............................................................................... 4

What you can do using InfoMaker.................................................... 5

Reports...................................................................................... 5

Queries...................................................................................... 8

Forms ........................................................................................ 9

Data pipelines.......................................................................... 10

Applications............................................................................. 11

Database management........................................................... 11

The InfoMaker environment ........................................................... 12

About the PowerBar ................................................................ 13

About wizards.......................................................................... 14

Working with libraries..................................................................... 14

Setting the current library ........................................................ 14

Working with objects ...................................................................... 16

Creating new objects............................................................... 16

Opening existing objects ......................................................... 17

Running or previewing objects ................................................ 18

Working in painters ........................................................................ 18

Opening painters..................................................................... 19

Painter summary ..................................................................... 19

Using views in painters............................................................ 19

Displaying the view’s title bar.................................................. 20

Moving and resizing panes and views..................................... 21

Floating and docking views ..................................................... 22

Adding and removing views .................................................... 23

Saving a layout........................................................................ 24

Using pop-up menus ............................................................... 24

Defining colors......................................................................... 25

Contents

iv

InfoMaker

Working with tools.......................................................................... 26

Using property pages..................................................................... 27

Using toolbars ................................................................................ 29

Toolbar basics......................................................................... 29

Drop-down toolbars................................................................. 29

Controlling the display of toolbars........................................... 30

Moving toolbars using the mouse............................................ 31

Customizing toolbars............................................................... 31

Creating new toolbars ............................................................. 36

Using report wizards ...................................................................... 37

Using the To-Do List ...................................................................... 38

Using online Help........................................................................... 39

About links from Help to book content..................................... 40

About the Sybooks CD and Web site...................................... 40

Windows Help files on Vista.................................................... 41

Customizing keyboard shortcuts.................................................... 42

Using the file editor ........................................................................ 44

Setting file editing properties................................................... 44

Editing activities....................................................................... 45

Changing fonts............................................................................... 46

Accessing shared queries stored on a network ............................. 46

Defining libraries for user-defined form styles................................ 47

Using the Query Governor ............................................................. 48

Accessing the Query Governor............................................... 49

Using the Query Governor ...................................................... 50

How your InfoMaker environment is managed............................... 51

About the registry.................................................................... 51

About the initialization file........................................................ 51

Starting InfoMaker from the command line.................................... 53

CHAPTER 2 Working with Libraries.................................................................. 55

About libraries................................................................................ 55

About InfoMaker libraries and special files..................................... 56

Creating new libraries .................................................................... 57

About the Library painter................................................................ 58

Working with libraries..................................................................... 59

Displaying libraries and objects............................................... 59

Using the pop-up menu........................................................... 60

Controlling columns that display in the List view..................... 60

Selecting objects..................................................................... 60

Filtering the display of objects................................................. 61

Filtering the display of libraries and folders............................. 62

Working in the current library .................................................. 62

Changing the current library.................................................... 62

Contents

Users Guide v

Opening and previewing objects............................................. 63

Copying, moving, and deleting objects.................................... 63

Setting the root........................................................................ 64

Moving back, forward, and up one level.................................. 65

Modifying comments ............................................................... 65

Deleting libraries...................................................................... 66

Optimizing libraries......................................................................... 67

Regenerating library entries........................................................... 67

Rebuilding libraries.................................................................. 68

Migrating libraries.................................................................... 69

Creating a library directory report................................................... 69

PART 2 WORKING WITH DATABASES

CHAPTER 3 Managing the Database................................................................ 73

Working with database components.............................................. 73

Managing databases...................................................................... 77

Using the Database painter............................................................ 78

Modifying database preferences............................................. 81

Logging your work................................................................... 82

Creating and deleting a SQL Anywhere database......................... 83

Working with tables........................................................................ 84

Creating a new table from scratch........................................... 84

Creating a new table from an existing table............................ 86

Specifying column definitions.................................................. 86

Specifying table and column properties .................................. 87

Altering a table ........................................................................ 90

Cutting, copying, and pasting columns.................................... 92

Closing a table......................................................................... 92

Dropping a table...................................................................... 93

Viewing pending SQL changes............................................... 93

Printing the table definition...................................................... 94

Exporting table syntax............................................................. 95

About system tables................................................................ 95

Creating and editing temporary tables .................................... 96

Working with keys.......................................................................... 97

Working with indexes................................................................... 101

Working with database views....................................................... 103

Manipulating data......................................................................... 108

Retrieving data...................................................................... 109

Modifying data....................................................................... 109

Sorting rows .......................................................................... 110

Filtering rows......................................................................... 112

Contents

vi

InfoMaker

Viewing row information........................................................ 113

Importing data ....................................................................... 113

Printing data.......................................................................... 114

Saving data ........................................................................... 114

Creating and executing SQL statements ..................................... 115

Building and executing SQL statements ............................... 115

Customizing the editor........................................................... 119

Controlling access to the current database.................................. 119

CHAPTER 4 Working with Data Pipelines....................................................... 121

About data pipelines..................................................................... 121

Defining a data pipeline......................................................... 122

Piping extended attributes..................................................... 123

Creating a data pipeline............................................................... 124

Modifying the data pipeline definition........................................... 127

Choosing a pipeline operation............................................... 130

Dependency of modifications on pipeline operation.............. 130

When execution stops........................................................... 132

Piping blob data..................................................................... 134

Changing the destination and source databases.................. 136

Correcting pipeline errors............................................................. 137

Saving a pipeline.......................................................................... 138

Using an existing pipeline ............................................................ 139

Pipeline examples........................................................................ 139

PART 3 REPORTS

CHAPTER 5 Defining Reports.......................................................................... 143

About reports................................................................................ 143

Choosing a presentation style...................................................... 144

Using the Tabular style.......................................................... 145

Using the Freeform style....................................................... 146

Using the Grid style............................................................... 146

Using the Label style............................................................. 147

Using the N-Up style ............................................................. 148

Using the Group style............................................................ 150

Using the Composite style..................................................... 150

Using the Graph and Crosstab styles.................................... 151

Using the OLE 2.0 style......................................................... 152

Using the RichText style........................................................ 152

Using the TreeView style....................................................... 153

Building a report........................................................................... 153

Contents

Users Guide vii

Selecting a data source................................................................ 154

Using Quick Select....................................................................... 156

Selecting a table.................................................................... 157

Selecting columns................................................................. 158

Specifying sorting criteria...................................................... 159

Specifying selection criteria................................................... 159

Using SQL Select......................................................................... 165

Selecting tables and views.................................................... 166

Selecting columns................................................................. 168

Displaying the underlying SQL statement............................. 169

Joining tables ........................................................................ 170

Using retrieval arguments ..................................................... 173

Referencing retrieval arguments........................................... 174

Specifying selection, sorting, and grouping criteria............... 175

Using Query ................................................................................. 180

Using External.............................................................................. 180

Using Stored Procedure............................................................... 182

Choosing report-wide options ...................................................... 184

Generating and saving a report.................................................... 185

About the extended attribute system tables and reports....... 185

Saving the report................................................................... 187

Modifying an existing report .................................................. 187

Defining queries........................................................................... 188

Previewing the query............................................................. 188

Saving the query ................................................................... 189

Modifying a query.................................................................. 190

What's next................................................................................... 190

CHAPTER 6 Enhancing Reports..................................................................... 191

Working in the Report painter ...................................................... 192

Understanding the Report painter Design view..................... 194

Using the Report painter toolbars.......................................... 196

Using the Properties view in the Report painter.................... 197

Selecting controls in the Report painter ................................ 197

Resizing bands in the Report painter Design view................ 199

Using zoom in the Report painter.......................................... 199

Undoing changes in the Report painter................................. 199

Using the Preview view of a report............................................... 200

Retrieving data...................................................................... 200

Modifying data....................................................................... 202

Importing data into a report................................................... 203

Using print preview................................................................ 204

Printing data.......................................................................... 206

Working in a grid report......................................................... 207

Contents

viii

InfoMaker

Saving data in an external file...................................................... 208

Saving the data as PDF ........................................................ 209

Saving the data in HTML Table format.................................. 213

Working with PSR files.......................................................... 214

Modifying general report properties ............................................. 216

Changing the report style...................................................... 216

Setting colors in a report ....................................................... 217

Setting gradients and background pictures in a report.......... 218

Setting transparency properties for a report.......................... 219

Specifying properties of a grid report .................................... 219

Specifying pointers for a report ............................................. 220

Defining print specifications for a report................................ 221

Modifying text in a report....................................................... 225

Naming controls in a report................................................... 226

Using borders in a report....................................................... 226

Specifying variable-height bands in a report......................... 227

Modifying the data source of a report.................................... 228

Storing data in a report using the Data view................................ 230

What happens at runtime...................................................... 231

Retrieving data............................................................................. 232

Prompting for retrieval criteria in a report.............................. 232

Retrieving rows as needed.................................................... 233

Saving retrieved rows to disk ................................................ 234

CHAPTER 7 Working with Controls in Reports.............................................. 235

Adding controls to a report........................................................... 235

Adding columns to a report ................................................... 235

Adding text to a report........................................................... 236

Adding drawing controls to a report....................................... 237

Adding a group box to a report.............................................. 238

Adding pictures to a report.................................................... 238

Adding computed fields to a report........................................ 239

Adding buttons to a report..................................................... 243

Adding graphs to a report...................................................... 245

Adding InkPicture controls to a report................................... 245

Adding OLE controls to a report............................................ 245

Adding reports to a report...................................................... 246

Adding tooltips to a DataWindow control............................... 246

Reorganizing controls in a report ................................................. 246

Displaying boundaries for controls in a report....................... 246

Using the grid and the ruler in a report.................................. 247

Deleting controls in a report .................................................. 247

Moving controls in a report.................................................... 248

Copying controls in a report .................................................. 248

Contents

Users Guide ix

Resizing controls in a report.................................................. 249

Aligning controls in a report................................................... 249

Equalizing the space between controls in a report................ 250

Equalizing the size of controls in a report.............................. 250

Sliding controls to remove blank space in a report................ 251

Positioning controls in a report..................................................... 252

Rotating controls in a report......................................................... 253

CHAPTER 8 Displaying and Validating Data ................................................. 257

About displaying and validating data............................................ 257

Presenting the data............................................................... 258

Validating data....................................................................... 259

About display formats................................................................... 259

Working with display formats ....................................................... 260

Working with display formats in the Database painter .......... 261

Working with display formats in the Report painter and

Form painter................................................................... 262

Defining display formats............................................................... 263

Number display formats ........................................................ 265

String display formats............................................................ 267

Date display formats.............................................................. 267

Time display formats ............................................................. 269

About edit styles........................................................................... 270

Working with edit styles................................................................ 272

Working with edit styles in the Database painter................... 272

Working with edit styles in the Form or Report painter.......... 274

Defining edit styles....................................................................... 274

The Edit edit style.................................................................. 274

The DropDownListBox edit style........................................... 275

The CheckBox edit style........................................................ 276

The RadioButtons edit style .................................................. 277

The EditMask edit style......................................................... 278

The DropDownDataWindow edit style................................... 281

The RichText edit style.......................................................... 283

The InkEdit edit style............................................................. 283

Defining a code table ................................................................... 284

How code tables are implemented........................................ 284

How code tables are processed............................................ 286

Validating user input.............................................................. 286

About validation rules................................................................... 287

Understanding validation rules.............................................. 288

Working with validation rules........................................................ 288

Defining validation rules............................................................... 289

Defining a validation rule in the Database painter................. 289

Contents

x

InfoMaker

Defining a validation rule in the Form painter........................ 292

How to maintain extended attributes............................................ 294

CHAPTER 9 Filtering, Sorting, and Grouping Rows...................................... 297

Filtering rows................................................................................ 297

Sorting rows ................................................................................. 299

Suppressing repeating values............................................... 301

Grouping rows.............................................................................. 302

Using the Group presentation style....................................... 304

Defining groups in an existing report..................................... 307

CHAPTER 10 Highlighting Information in Reports and Forms....................... 315

Highlighting information................................................................ 315

Modifying properties when designing.................................... 315

Modifying properties at runtime............................................. 316

Modifying properties conditionally at runtime............................... 319

Example 1: creating a gray bar effect.................................... 320

Example 2: rotating controls.................................................. 321

Example 3: highlighting rows of data..................................... 322

Example 4: changing the size and location of controls ......... 324

Supplying property values............................................................ 325

Background.Color.................................................................. 327

Border.................................................................................... 327

Brush.Color ........................................................................... 329

Brush.Hatch........................................................................... 329

Color...................................................................................... 330

Font.Escapement (for rotating controls)................................ 331

Font.Height............................................................................ 332

Font.Italic............................................................................... 333

Font.Strikethrough................................................................. 334

Font.Underline....................................................................... 335

Font.Weight........................................................................... 335

Format................................................................................... 336

Height.................................................................................... 336

Pen.Color .............................................................................. 337

Pen.Style............................................................................... 337

Pen.Width.............................................................................. 339

Pointer................................................................................... 339

Protect................................................................................... 340

Timer_Interval ....................................................................... 340

Visible.................................................................................... 340

Width..................................................................................... 341

X............................................................................................ 341

Contents

Users Guide xi

X1, X2.................................................................................... 342

Y............................................................................................ 342

Y1, Y2.................................................................................... 343

Specifying colors.......................................................................... 343

CHAPTER 11 Using Nested Reports ................................................................ 345

About nested reports.................................................................... 345

Creating a report using the Composite presentation style........... 349

Placing a nested report in another report..................................... 351

Placing a related nested report in another report.................. 351

Placing an unrelated nested report in another report............ 354

Working with nested reports......................................................... 354

Adjusting nested report width and height.............................. 355

Changing a nested report from one report to another........... 356

Modifying the definition of a nested report ............................ 356

Adding another nested report to a composite report............. 357

Supplying retrieval arguments to relate a nested report to

its base report................................................................. 357

Specifying criteria to relate a nested report to its base

report.............................................................................. 359

Using options for nested reports ........................................... 360

CHAPTER 12 Exporting and Importing XML Data........................................... 363

About XML ................................................................................... 363

Valid and well-formed XML documents................................. 364

XML syntax............................................................................ 365

XML parsing.......................................................................... 366

XML support in the Report painter............................................... 367

The Export/Import Template view for XML................................... 368

Creating templates................................................................ 370

Saving templates................................................................... 371

Header and Detail sections................................................... 371

Editing XML templates................................................................. 374

XML declaration .................................................................... 375

Document type declaration.................................................... 376

Root element......................................................................... 377

Controls................................................................................. 377

InfoMaker expressions .......................................................... 378

Attributes............................................................................... 378

Composite and nested reports.............................................. 379

CDATA sections.................................................................... 381

Comments............................................................................. 381

Processing instructions ......................................................... 382

Contents

xii

InfoMaker

Exporting to XML.......................................................................... 382

Setting data export properties............................................... 383

Importing XML.............................................................................. 391

Importing with a template...................................................... 391

Default data import................................................................ 395

Tracing import ....................................................................... 399

CHAPTER 13 Working with Graphs................................................................... 401

About graphs................................................................................ 401

Parts of a graph..................................................................... 402

Types of graphs..................................................................... 404

Using graphs in reports................................................................ 408

Placing a graph in a report.................................................... 409

Using the graph's Properties view......................................... 410

Changing a graph's position and size.................................... 410

Associating data with a graph ............................................... 412

Using the Graph presentation style.............................................. 420

Defining a graph's properties ....................................................... 421

Using the General page in the graph's Properties view ........ 421

Sorting data for series and categories................................... 423

Specifying text properties for titles, labels, axes, and

legends........................................................................... 423

Specifying overlap and spacing............................................. 426

Specifying axis properties ..................................................... 427

Specifying a pointer............................................................... 429

CHAPTER 14 Working with Crosstabs.............................................................. 431

About crosstabs ........................................................................... 431

Two types of crosstabs.......................................................... 433

Creating crosstabs....................................................................... 434

Associating data with a crosstab.................................................. 436

Specifying the information..................................................... 436

Viewing the crosstab............................................................. 439

Specifying more than one row or column.............................. 441

Previewing crosstabs ................................................................... 442

Enhancing crosstabs.................................................................... 442

Specifying basic properties ................................................... 443

Modifying the data associated with the crosstab................... 444

Changing the names used for the columns and rows........... 444

Defining summary statistics................................................... 445

Cross-tabulating ranges of values......................................... 448

Creating static crosstabs....................................................... 451

Using property conditional expressions................................. 452

Contents

Users Guide xiii

CHAPTER 15 Working with TreeViews............................................................. 455

TreeView presentation style......................................................... 455

Creating a new TreeView report .................................................. 456

TreeView creation process.................................................... 457

Creating a TreeView report ................................................... 457

Adding and deleting TreeView levels........................................... 461

Selecting a tree node and navigating the tree.............................. 462

Sorting rows in a TreeView report................................................ 463

TreeView report Design view ....................................................... 464

Setting properties for the TreeView report................................... 465

Setting general TreeView properties..................................... 466

Setting TreeView level properties.......................................... 467

Setting detail band properties................................................ 469

CHAPTER 16 Working with Rich Text .............................................................. 471

About rich text.............................................................................. 471

Using the RichText presentation style.......................................... 472

Creating the report ................................................................ 473

Formatting for RichText objects within the report.................. 476

Previewing and printing......................................................... 481

Formatting keys and toolbars....................................................... 482

CHAPTER 17 Using OLE in a Report................................................................ 485

About using OLE in reports.......................................................... 485

OLE objects and the OLE presentation style............................... 487

Adding an OLE object to a report.......................................... 488

Using the OLE presentation style.......................................... 489

Defining the OLE object ........................................................ 490

Specifying data for the OLE object........................................ 492

Previewing the report ............................................................ 496

Activating and editing the OLE object ................................... 496

Changing the object in the control......................................... 497

Using OLE columns in a report .................................................... 498

Creating an OLE column....................................................... 498

PART 4 FORMS

CHAPTER 18 Defining Forms............................................................................ 505

About forms.................................................................................. 505

Creating new forms ............................................................... 507

Freeform forms...................................................................... 509

Grid forms.............................................................................. 510

Contents

xiv

InfoMaker

Master/Detail One-To-Many forms........................................ 511

Master/Detail Many-To-One forms........................................ 513

Creating and saving forms ........................................................... 514

Creating basic forms ............................................................. 514

Creating a master/detail form................................................ 516

Defining data so that a form can update a database............. 520

Generating and saving forms................................................ 521

Working with forms....................................................................... 523

Running forms....................................................................... 523

Limiting the retrieved data..................................................... 524

Importing data into a form ..................................................... 525

Saving data in an external file............................................... 526

Printing forms........................................................................ 527

Actions in forms..................................................................... 527

Accessing and deleting forms ............................................... 530

CHAPTER 19 Controlling Updates in Forms .................................................... 531

About controlling updates............................................................. 531

What you can do ................................................................... 532

Specifying the table to update...................................................... 533

Specifying the unique key columns.............................................. 533

Specifying an identity column....................................................... 534

Specifying updatable columns ..................................................... 534

Specifying the WHERE clause for update/delete......................... 535

Specifying update when key is modified...................................... 537

CHAPTER 20 Enhancing Forms ........................................................................ 539

About enhancing forms................................................................ 539

Working in the Form painter Layout view..................................... 540

Using the Form painter toolbars............................................ 540

Using the pop-up menus in the Form painter........................ 542

Using the Properties view in the Form painter ...................... 542

Selecting controls in the Form painter................................... 543

Defining default colors and borders in the Form painter ....... 544

Printing the form definition..................................................... 546

Reorganizing controls in the form ................................................ 546

Using the grid in the Form painter......................................... 546

Deleting controls in the Form painter .................................... 547

Moving controls in the Form painter...................................... 547

Copying and pasting controls in the Form painter................. 548

Resizing controls in the Form painter.................................... 549

Aligning controls in the Form painter..................................... 549

Equalizing the space between controls in the Form painter.. 550

Contents

Users Guide xv

Equalizing the size of controls in the Form painter................ 551

Undoing changes in the Form painter................................... 551

Sliding controls in a form....................................................... 551

Modifying general form properties................................................ 553

Specifying a title for a form.................................................... 553

Setting colors for a form ........................................................ 553

Specifying the display of scrollbars for a form....................... 555

Specifying pointers for a form................................................ 555

Modifying text in a form......................................................... 555

Defining the tab order in a form............................................. 556

Using borders in a form......................................................... 557

Prompting for retrieval criteria in a form ................................ 558

Modifying the data source of a form...................................... 560

Adding controls to the form.......................................................... 561

Adding columns to a form...................................................... 561

Adding text to a form............................................................. 561

Adding computed fields to a form.......................................... 562

Adding pictures to a form ...................................................... 565

Adding command buttons to a form ...................................... 566

Adding picture buttons to a form ........................................... 568

Adding reports to a form........................................................ 568

Adding drawing controls to a form......................................... 569

Highlighting information in a form................................................. 570

Displaying and validating data in a form ...................................... 571

PART 5 APPLICATIONS

CHAPTER 21 Working with Applications......................................................... 575

About applications........................................................................ 575

Creating an application ................................................................ 576

Reusing an application................................................................. 582

Running an application................................................................. 583

Identifying your application.................................................... 585

Running a report, form, or pipeline........................................ 586

Managing the toolbar............................................................. 587

Managing the open reports, forms, and pipelines................. 587

Using the query governor in an application........................... 587

Using a pipeline in an application................................................. 587

Executing pipelines ............................................................... 588

Modifying the pipeline object’s definition............................... 590

Starting an application from the command line............................ 593

Contents

xvi

InfoMaker

CHAPTER 22 Deploying Your Application........................................................ 595

About deploying applications ....................................................... 595

Installing InfoMaker runtime files.................................................. 597

Making the data source available................................................. 599

Installing native database interfaces..................................... 599

Installing ODBC and system files.......................................... 600

Configuring an ODBC driver.................................................. 600

Deploying SQL Anywhere files.............................................. 602

OLE DB database providers.................................................. 604

JDBC database interface ...................................................... 604

Saving as PDF and XSL-FO........................................................ 607

Using the Ghostscript distiller................................................ 607

Using the Apache FO processor........................................... 609

Installing the executable application and supporting files............ 610

Modifying the application’s initialization file........................... 610

Deploying ActiveX controls.................................................... 610

Starting the deployed application................................................. 611

PART 6 REFERENCE

CHAPTER 23 Operators and Expressions........................................................ 615

Where you use expressions......................................................... 615

Operators used in InfoMaker expressions ................................... 618

Arithmetic operators in InfoMaker expressions..................... 619

Relational operators in InfoMaker expressions..................... 619

Logical operators in InfoMaker expressions.......................... 623

Concatenation operator in InfoMaker expressions................ 624

Operator precedence in InfoMaker expressions.......................... 625

Matching text patterns.................................................................. 626

CHAPTER 24 DataWindow Expression and InfoMaker Functions ................. 629

Using DataWindow expression and InfoMaker functions............. 629

Four examples ............................................................................. 630

Example 1: counting null values in a column ........................ 630

Example 2: counting male and female employees................ 632

Example 3: creating a row indicator...................................... 636

Example 4: displaying all data when a column allows nulls.. 638

Other examples..................................................................... 639

Alphabetical list of DataWindow expression and InfoMaker

functions......................................................................... 640

Abs........................................................................................ 641

ACos...................................................................................... 641

Contents

Users Guide xvii

Asc ........................................................................................ 642

AscA...................................................................................... 642

ASin....................................................................................... 643

ATan...................................................................................... 644

Avg........................................................................................ 644

Bitmap................................................................................... 647

Case...................................................................................... 648

Ceiling ................................................................................... 649

Char....................................................................................... 650

CharA.................................................................................... 650

Cos........................................................................................ 651

Count..................................................................................... 651

CrosstabAvg.......................................................................... 653

CrosstabAvgDec ................................................................... 657

CrosstabCount ...................................................................... 658

CrosstabMax......................................................................... 660

CrosstabMaxDec................................................................... 661

CrosstabMin.......................................................................... 662

CrosstabMinDec.................................................................... 664

CrosstabSum......................................................................... 665

CrosstabSumDec.................................................................. 667

CumulativePercent................................................................ 668

CumulativeSum..................................................................... 670

CurrentRow ........................................................................... 671

Date....................................................................................... 672

DateTime............................................................................... 673

Day........................................................................................ 674

DayName .............................................................................. 674

DayNumber........................................................................... 675

DaysAfter............................................................................... 676

Dec........................................................................................ 677

Describe................................................................................ 678

Exp........................................................................................ 678

Fact ....................................................................................... 679

Fill.......................................................................................... 679

FillA ....................................................................................... 680

First ....................................................................................... 681

GetRow ................................................................................. 683

GetText.................................................................................. 684

Hour....................................................................................... 684

If ............................................................................................ 685

Int .......................................................................................... 686

Integer................................................................................... 686

IsDate.................................................................................... 687

Contents

xviii

InfoMaker

IsExpanded ........................................................................... 688

IsNull ..................................................................................... 688

IsNumber............................................................................... 689

IsRowModified....................................................................... 689

IsRowNew............................................................................. 690

IsSelected.............................................................................. 690

IsTime.................................................................................... 691

Large..................................................................................... 692

Last........................................................................................ 694

LastPos ................................................................................. 695

Left ........................................................................................ 696

LeftA...................................................................................... 697

LeftTrim................................................................................. 698

Len ........................................................................................ 698

LenA...................................................................................... 699

Log ........................................................................................ 699

LogTen.................................................................................. 700

Long ...................................................................................... 700

LookUpDisplay...................................................................... 701

Lower..................................................................................... 702

Match..................................................................................... 702

Max........................................................................................ 704

Median................................................................................... 706

Mid......................................................................................... 709

MidA...................................................................................... 710

Min......................................................................................... 710

Minute.................................................................................... 713

Mod ....................................................................................... 713

Mode ..................................................................................... 714

Month .................................................................................... 716

Now....................................................................................... 716

Number.................................................................................. 717

Page...................................................................................... 718

PageAbs................................................................................ 718

PageAcross........................................................................... 719

PageCount ............................................................................ 719

PageCountAcross ................................................................. 720

Percent.................................................................................. 721

Pi........................................................................................... 723

Pos........................................................................................ 724

PosA...................................................................................... 725

ProfileInt................................................................................ 725

ProfileString........................................................................... 727

Rand...................................................................................... 728

Contents

Users Guide xix

Real....................................................................................... 728

RelativeDate.......................................................................... 729

RelativeTime ......................................................................... 729

Replace................................................................................. 730

ReplaceA............................................................................... 731

RGB....................................................................................... 731

Right...................................................................................... 733

RightA.................................................................................... 733

RightTrim............................................................................... 734

Round.................................................................................... 734

RowCount.............................................................................. 735

RowHeight............................................................................. 735

Second.................................................................................. 736

SecondsAfter......................................................................... 737

Sign....................................................................................... 737

Sin......................................................................................... 738

Small ..................................................................................... 738

Space.................................................................................... 740

Sqrt........................................................................................ 741

StDev..................................................................................... 742

StDevP.................................................................................. 744

String..................................................................................... 746

StripRTF................................................................................ 748

Sum....................................................................................... 749

Tan........................................................................................ 751

Time ...................................................................................... 752

Today .................................................................................... 753

Trim....................................................................................... 753

Truncate................................................................................ 753

Upper..................................................................................... 755

Var......................................................................................... 755

VarP ...................................................................................... 758

WordCap............................................................................... 760

Year....................................................................................... 761

PART 7 APPENDIXES

APPENDIX A Identifiers..................................................................................... 765

Rules............................................................................................ 765

Reserved words ........................................................................... 766

Contents

xx

InfoMaker

APPENDIX B The Extended Attribute System Tables..................................... 767

About the extended attribute system tables................................. 767

The extended attribute system tables.......................................... 768

Edit style types for the PBCatEdt table........................................ 771

CheckBox edit style (code 85)............................................... 771

RadioButton edit style (code 86)........................................... 772

DropDownListBox edit style (code 87).................................. 773

DropDownDataWindow edit style (code 88).......................... 774

Edit edit style (code 89)......................................................... 775

Edit Mask edit style (code 90)............................................... 777

Index ........................................................................................................................................... 779

Page is loading ...

Sybase InfoMaker 11.5, CD, Win, ENG Specification

Related papers

Other documents