Sybase InfoMaker 11.5, CD, Win, ENG manuali

Manuali dei proprietari e guide per l'utente per Software di database Sybase InfoMaker 11.5, CD, Win, ENG.
We fornisce 1 manuali pdf Sybase InfoMaker 11.5, CD, Win, ENG per scaricare gratuitamente in base al tipo di documento: Specifiche

Sybase InfoMaker 11.5, CD, Win, ENG Specifiche (828 pagine)

Marchio: Sybase | Categoria: Software di database | Dimensione: 10.72 MB |

Inglese

Indice

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

Sybase dispositivi