PowerBuilder11.0

DOCUMENT ID: DC37783-01-1100-02

LAST REVISED: October 2008

Copyright 1991-2008 by Sybase, Inc. All rights reserved. Sybase Sybase,Inc.

Sybase, Inc.

Sybase Sybase http://www.sybase.com/detail?id=1011207 Sybase Sybase, Inc

Java Java Sun Microsystems, Inc.

Unicode Unicode Unicode, Inc.

Sybase,Inc.

.............................................................................................................................. xxiii

1 ................................................................................. 1 ....................................................... 1 ................................. 4

.................................. 4 .................................. 5 .................................. 9 ................................ 10

................................... 11 ................................... 11Describe .............................. 12 .................... 13

2 ......................................................................................... 15 ................................................. 15.................................................................................. 17

1 : null ............................................... 17 2 : ....................................................... 19 3 : ................................................... 22 4 : null

.............................................. 23 ................. 25

Abs .......................................................................................... 26ACos........................................................................................ 26Asc .......................................................................................... 27AscA ........................................................................................ 28ASin......................................................................................... 28ATan........................................................................................ 29Avg .......................................................................................... 30Bitmap ..................................................................................... 32Case ........................................................................................ 33Ceiling ..................................................................................... 34

iii

Char......................................................................................... 35CharA ...................................................................................... 36Cos .......................................................................................... 36Count....................................................................................... 37CrosstabAvg............................................................................ 39CrosstabAvgDec ..................................................................... 42CrosstabCount ........................................................................ 43CrosstabMax ........................................................................... 45CrosstabMaxDec..................................................................... 47CrosstabMin ............................................................................ 48CrosstabMinDec...................................................................... 49CrosstabSum........................................................................... 50CrosstabSumDec .................................................................... 52CumulativePercent .................................................................. 53CumulativeSum....................................................................... 55CurrentRow ............................................................................. 56Date......................................................................................... 57DateTime................................................................................. 59Day .......................................................................................... 60DayName ................................................................................ 60DayNumber ............................................................................. 61DaysAfter................................................................................. 62Dec .......................................................................................... 62Describe .................................................................................. 63Exp .......................................................................................... 64Fact ......................................................................................... 65Fill ............................................................................................ 65FillA ......................................................................................... 66First ......................................................................................... 66GetRow ................................................................................... 68GetText.................................................................................... 69Hour......................................................................................... 70If .............................................................................................. 71Int ............................................................................................ 72Integer ..................................................................................... 72IsDate ...................................................................................... 73IsExpanded ............................................................................. 74IsNull ....................................................................................... 74IsNumber................................................................................. 75IsRowModified......................................................................... 76IsRowNew ............................................................................... 76IsSelected................................................................................ 77IsTime...................................................................................... 78Large ....................................................................................... 78

iv PowerBuilder

Last.......................................................................................... 80LastPos ................................................................................... 82Left .......................................................................................... 83LeftA ........................................................................................ 84LeftTrim ................................................................................... 85Len .......................................................................................... 85LenA ........................................................................................ 86Log .......................................................................................... 86LogTen .................................................................................... 87Long ........................................................................................ 88LookUpDisplay ........................................................................ 88Lower....................................................................................... 89Match....................................................................................... 89Max.......................................................................................... 92Median..................................................................................... 94Mid........................................................................................... 96MidA ........................................................................................ 97Min........................................................................................... 98Minute...................................................................................... 99Mod ....................................................................................... 100Mode ..................................................................................... 101Month .................................................................................... 103Now ....................................................................................... 104Number.................................................................................. 104Page ...................................................................................... 105PageAbs................................................................................ 106PageAcross ........................................................................... 106PageCount ............................................................................ 107PageCountAcross ................................................................. 108Percent .................................................................................. 108Pi ........................................................................................... 111Pos ........................................................................................ 112PosA...................................................................................... 113ProfileInt ................................................................................ 113ProfileString........................................................................... 115Rand...................................................................................... 117Real ....................................................................................... 117RelativeDate.......................................................................... 118RelativeTime ......................................................................... 118Replace ................................................................................. 119ReplaceA............................................................................... 120RGB....................................................................................... 120Right ...................................................................................... 122RightA.................................................................................... 122

v

RightTrim............................................................................... 123Round.................................................................................... 124RowCount.............................................................................. 124RowHeight............................................................................. 125Second .................................................................................. 126SecondsAfter......................................................................... 126Sign ....................................................................................... 127Sin ......................................................................................... 127Small ..................................................................................... 128Space .................................................................................... 130Sqrt........................................................................................ 131StDev..................................................................................... 131StDevP .................................................................................. 134String ..................................................................................... 136Sum....................................................................................... 138Tan ........................................................................................ 140Time ...................................................................................... 141Today .................................................................................... 142Trim ....................................................................................... 142Truncate ................................................................................ 143Upper..................................................................................... 143Var......................................................................................... 144VarP ...................................................................................... 147WordCap ............................................................................... 149Year....................................................................................... 150

3 ......................................... 153 ................. 153 .................. 155

..................... 156

................................. 160

................................. 161

.................. 163

................................. 164

............... 166Group ............................................ 167

.................. 167

vi PowerBuilder

..................................... 168

OLE .............. 169

................... 170

............................. 171

............................. 172

Style .............................................. 173

TableBlob ........................... 173

............................. 174Title ..................................................................... 175

................................................ 176

Accelerator ............................................................................ 177AccessibleDescription ........................................................... 177AccessibleName.................................................................... 178AccessibleRole...................................................................... 179Action .................................................................................... 180Activation............................................................................... 182Alignment .............................................................................. 183Arguments ............................................................................. 184Attributes ............................................................................... 185Axis........................................................................................ 186Axis.property ......................................................................... 186BackColor.............................................................................. 191Background.property ............................................................. 191BackImage ............................................................................ 193Band ...................................................................................... 194Bandname.property............................................................... 195Bandname.Text ..................................................................... 197Bands .................................................................................... 198BinaryIndex ........................................................................... 199BitmapName.......................................................................... 199Border.................................................................................... 199Brush.property....................................................................... 201Category................................................................................ 202CheckBox.property................................................................ 202ClientName............................................................................ 204Color...................................................................................... 205

vii

ColType ................................................................................. 207Column.Count ....................................................................... 208ContentsAllowed ................................................................... 208Criteria................................................................................... 209Criteria.property..................................................................... 210Crosstab.property.................................................................. 211CSSGen.property .................................................................. 213Data....................................................................................... 215Data.HTML............................................................................ 215Data.HTMLTable ................................................................... 216Data.XHTML.......................................................................... 218Data.XML .............................................................................. 219Data.XMLDTD....................................................................... 220Data.XMLSchema ................................................................. 220Data.XMLWeb ....................................................................... 221Data.XSLFO.......................................................................... 223DataObject ............................................................................ 223dbAlias................................................................................... 224dbName................................................................................. 225dddw.property........................................................................ 226ddlb.property ......................................................................... 230DefaultPicture........................................................................ 233Depth..................................................................................... 234Detail_Bottom_Margin........................................................... 235Detail_Top_Margin ................................................................ 235Detail.property ....................................................................... 236DispAttr.fontproperty ............................................................. 236DisplayType........................................................................... 239Edit.property .......................................................................... 240EditMask.property ................................................................. 245Elevation................................................................................ 249EllipseHeight ......................................................................... 250EllipseWidth........................................................................... 250Enabled ................................................................................. 251Export.PDF.Distill.CustomPostScript .................................... 252Export.PDF.Method............................................................... 253Export.PDF.XSLFOP.Print .................................................... 255Export.XHTML.TemplateCount ............................................. 256Export.XHTML.Template[ ].Name ......................................... 257Export.XHTML.UseTemplate ................................................ 258Export.XML.HeadGroups ...................................................... 259Export.XML.IncludeWhitespace ............................................ 260Export.XML.MetaDataType ................................................... 261Export.XML.SaveMetaData................................................... 262

viii PowerBuilder

Export.XML.TemplateCount .................................................. 264Export.XML.Template[ ].Name .............................................. 265Export.XML.UseTemplate ..................................................... 265Expression............................................................................. 266Filename................................................................................ 267FirstRowOnPage ................................................................... 268Font.Bias ............................................................................... 269Font.property ......................................................................... 269Footer.property...................................................................... 272Format ................................................................................... 272GraphType ............................................................................ 273Grid.ColumnMove ................................................................. 274Grid.Lines .............................................................................. 274GroupBy ................................................................................ 275Header_Bottom_Margin ........................................................ 276Header_Top_Margin ............................................................. 277Header.property .................................................................... 277Header.#.property ................................................................. 277Height .................................................................................... 277Height.AutoSize..................................................................... 278Help.property......................................................................... 279HideGrayLine ........................................................................ 281HideSnaked........................................................................... 282Horizontal_Spread................................................................. 282HorizontalScrollMaximum...................................................... 283HorizontalScrollMaximum2.................................................... 283HorizontalScrollPosition ........................................................ 284HorizontalScrollPosition2 ...................................................... 285HorizontalScrollSplit .............................................................. 286HTextAlign............................................................................. 286HTML.property ...................................................................... 287HTMLDW............................................................................... 289HTMLGen.property................................................................ 291HTMLTable.property ............................................................. 300ID........................................................................................... 301Identity................................................................................... 302Import.XML.Trace.................................................................. 302Import.XML.TraceFile............................................................ 303Import.XML.UseTemplate ..................................................... 304Initial ...................................................................................... 305Ink.property ........................................................................... 306InkEdit.property ..................................................................... 308InkPic.property ...................................................................... 311Invert ..................................................................................... 314

ix

JSGen.property ..................................................................... 314Key ........................................................................................ 315KeyClause ............................................................................. 316Label.property ....................................................................... 317LabelDispAttr.fontproperty..................................................... 319LastRowOnPage ................................................................... 319Left_Margin ........................................................................... 319Legend .................................................................................. 319Legend.DispAttr.fontproperty ................................................ 320Level...................................................................................... 320LineRemove .......................................................................... 321LinkUpdateOptions................................................................ 322Message.Title ........................................................................ 322Moveable............................................................................... 323Multiline ................................................................................. 324Name..................................................................................... 325Nest_Arguments.................................................................... 326Nested ................................................................................... 327NewPage Group ............................................ 327NewPage .................................... 328NoUserPrompt....................................................................... 328Objects .................................................................................. 329OLE.Client.property............................................................... 329OLEClass .............................................................................. 330OverlapPercent ..................................................................... 331Pen.property.......................................................................... 332Perspective............................................................................ 333Pie.DispAttr.fontproperty ....................................................... 333PlotNullData .......................................................................... 334Pointer ................................................................................... 334Print.Preview.property ........................................................... 335Print.property......................................................................... 337Printer.................................................................................... 344Processing............................................................................. 345Protect ................................................................................... 346QueryClear ............................................................................ 347QueryMode............................................................................ 347QuerySort .............................................................................. 348RadioButtons.property........................................................... 349Range.................................................................................... 351ReadOnly .............................................................................. 352ReplaceTabWithSpace.......................................................... 352Report.................................................................................... 353ResetPageCount ................................................................... 354

x PowerBuilder

Resizeable............................................................................. 354Retrieve ................................................................................. 355Retrieve.AsNeeded ............................................................... 355RichText.property .................................................................. 356Rotation ................................................................................. 360Row.Resize ........................................................................... 361Rows_Per_Detail................................................................... 361Selected ................................................................................ 362Selected.Data........................................................................ 363Selected.Mouse..................................................................... 363Series .................................................................................... 364ShadeColor ........................................................................... 364ShowBackColorOnXP ........................................................... 365ShowDefinition ...................................................................... 366SizeToDisplay ....................................................................... 366SlideLeft ................................................................................ 367SlideUp.................................................................................. 368Sort........................................................................................ 369Spacing ................................................................................. 370Sparse ................................................................................... 370Storage.................................................................................. 371StoragePageSize .................................................................. 371Summary.property................................................................. 372SuppressEventProcessing .................................................... 372Syntax ................................................................................... 373Syntax.Data........................................................................... 373Syntax.Modified..................................................................... 374Table Create .................................................. 375Table TableBlob ............... 375Table.property ....................................................................... 376Table.sqlaction.property ........................................................ 380TabSequence ........................................................................ 383Tag ........................................................................................ 383Target .................................................................................... 384Template ............................................................................... 385Text ....................................................................................... 386Timer_Interval ....................................................................... 386Title........................................................................................ 387Title.DispAttr.fontproperty...................................................... 388Trail_Footer ........................................................................... 388Trailer.#.property ................................................................... 389Tree.property......................................................................... 389Tree.Leaf.TreeNodeIconName.............................................. 392Tree.Level.#.property ............................................................ 393

xi

Type ...................................................................................... 394Units ...................................................................................... 396Update................................................................................... 396Validation............................................................................... 397ValidationMsg........................................................................ 398Values ........................................................ 399Values ........................................................ 400Vertical_Size ......................................................................... 400Vertical_Spread..................................................................... 400VerticalScrollMaximum.......................................................... 401VerticalScrollPosition............................................................. 401Visible.................................................................................... 402VTextAlign ............................................................................. 403Width ..................................................................................... 404Width.Autosize ...................................................................... 405X ............................................................................................ 406X1 X2 .................................................................................. 406XHTMLGen.Browser ............................................................. 407XMLGen.property .................................................................. 408XSLTGen.property ................................................................ 410Y ............................................................................................ 411Y1 Y2 .................................................................................. 412Zoom ..................................................................................... 413

4 ......................................................... 415

.......................... 415.............................................................. 416

.................................... 417 .............................................. 425

.............................................................. 426

.... 428 .... 430 432............ 433............ 435 .......................... 437

5 ..................................................... 439

....................................................... 439

xii PowerBuilder

.. 440 ........... 442

......................................... 443............ 444

..................................... 447PowerBuilder: Modify

Describe ......................................................... 451PowerBuilder Modify

Describe .................................... 451PowerBuilder Modify

Describe .......................... 452PowerBuilder: .......................... 453

PowerBuilder ................................................ 454

PowerBuilder ......................................................................... 455

PowerBuilder DWObject ......................... 455PowerBuilder

.................................................... 459PowerBuilder

.... 460PowerBuilder ...... 462

JavaScript: Modify Describe 470JavaScript Modify

Describe .................................... 470JavaScript Modify

Describe .......................... 472

6 ........................................................................................... 473 ................................................... 473 ................. 474

AccessibleRole...................................................................... 475Alignment .............................................................................. 477Band ...................................................................................... 477Border.................................................................................... 478BorderStyle............................................................................ 479CharSet ................................................................................. 479DWBuffer............................................................................... 480DWConflictResolution ........................................................... 481DWItemStatus ....................................................................... 481FillPattern .............................................................................. 482grColorType........................................................................... 483

xiii

grDataType............................................................................ 484grObjectType......................................................................... 484grSymbolType ....................................................................... 485LineStyle................................................................................ 486MetaDataType....................................................................... 486RowFocusInd ........................................................................ 487SaveAsType .......................................................................... 487SaveMetaData....................................................................... 489SQLPreviewFunction............................................................. 490SQLPreviewType .................................................................. 490WebPagingMethod................................................................ 490

7 ..................................................... 493PowerBuilder ......................... 493

............................. 493 ..................... 494

Web .... 497Web ActiveX .................................... 500

8 ................................................................................ 503 ............................ 503 ....................................... 504 .................... 506 ........ 508BackTabOut ................................................................................. 508ButtonClicked ............................................................................... 508ButtonClicking .............................................................................. 510Clicked ......................................................................................... 512Collapsed ..................................................................................... 515Collapsing .................................................................................... 516Constructor................................................................................... 517DBError ........................................................................................ 517Destructor..................................................................................... 520DoubleClicked .............................................................................. 521DragDrop...................................................................................... 523DragEnter..................................................................................... 525DragLeave.................................................................................... 525DragWithin ................................................................................... 526DropDown .................................................................................... 527EditChanged ................................................................................ 527Error ............................................................................................. 528Expanded ..................................................................................... 531

xiv PowerBuilder

Expanding .................................................................................... 532GetFocus...................................................................................... 533GraphCreate ................................................................................ 533HTMLContextApplied ................................................................... 534ItemChanged................................................................................ 536ItemError ...................................................................................... 537ItemFocusChanged...................................................................... 540KeyDown...................................................................................... 541LoseFocus.................................................................................... 542MessageText................................................................................ 543MouseMove.................................................................................. 544MouseUp...................................................................................... 546OnSubmit ..................................................................................... 547Printend........................................................................................ 548PrintMarginChange ...................................................................... 549PrintPage ..................................................................................... 550PrintStart ...................................................................................... 551ProcessEnter................................................................................ 552RButtonDown ............................................................................... 552Resize .......................................................................................... 554RetrieveEnd ................................................................................. 555RetrieveRow................................................................................. 556RetrieveStart ................................................................................ 557RowFocusChanged...................................................................... 558RowFocusChanging..................................................................... 560ScrollHorizontal ............................................................................ 563ScrollVertical ................................................................................ 564SQLPreview ................................................................................. 565TabDownOut ................................................................................ 567TabOut ......................................................................................... 568TabUpOut..................................................................................... 568TreeNodeSelected ....................................................................... 569TreeNodeSelecting ...................................................................... 569UpdateEnd ................................................................................... 570UpdateStart .................................................................................. 571WSError ....................................................................................... 571

9 ............................................. 573AboutBox...................................................................................... 574AcceptText ................................................................................... 574CanUndo ...................................................................................... 577ClassName................................................................................... 578Clear............................................................................................. 579ClearValues.................................................................................. 580

xv

Collapse ....................................................................................... 582CollapseAll ................................................................................... 583CollapseAllChildren...................................................................... 584CollapseLevel............................................................................... 585Copy............................................................................................. 586CopyRTF...................................................................................... 587Create .......................................................................................... 589CreateError .................................................................................. 592CreateFrom .................................................................................. 593CrosstabDialog............................................................................. 595Cut................................................................................................ 596DBCancel ..................................................................................... 597DBErrorCode................................................................................ 600DBErrorMessage.......................................................................... 602DeletedCount ............................................................................... 603DeleteRow.................................................................................... 605Describe ....................................................................................... 607Drag ............................................................................................. 613Expand ......................................................................................... 614ExpandAll ..................................................................................... 615ExpandAllChildren........................................................................ 616ExpandLevel ................................................................................ 617Filter ............................................................................................. 618FilteredCount................................................................................ 620Find .............................................................................................. 622FindGroupChange........................................................................ 626FindNext....................................................................................... 628FindRequired................................................................................ 629FindRequiredColumn ................................................................... 633FindRequiredColumnName.......................................................... 634FindRequiredRow ........................................................................ 634Generate ...................................................................................... 636GenerateHTMLForm .................................................................... 638GenerateResultSet....................................................................... 639GenerateXHTML .......................................................................... 646GenerateXMLWeb ....................................................................... 647GetBandAtPointer ........................................................................ 649GetBorderStyle............................................................................. 651GetChanges ................................................................................. 652GetChangesBlob.......................................................................... 655GetChild ....................................................................................... 656GetChildObject............................................................................. 659GetClickedColumn ....................................................................... 660GetClickedRow ............................................................................ 661

xvi PowerBuilder

GetColumn ................................................................................... 662GetColumnName ......................................................................... 664GetContextService ....................................................................... 665GetFormat .................................................................................... 666GetFullContext ............................................................................. 667GetFullState ................................................................................. 668GetFullStateBlob .......................................................................... 670GetItem ........................................................................................ 671GetItemDate................................................................................. 672GetItemDateTime......................................................................... 676GetItemDecimal ........................................................................... 679GetItemFormattedString............................................................... 682GetItemNumber............................................................................ 684GetItemStatus .............................................................................. 687GetItemString ............................................................................... 689GetItemTime ................................................................................ 693GetItemUnformattedString ........................................................... 696GetLastError................................................................................. 698GetLastErrorString ....................................................................... 699GetMessageText.......................................................................... 700GetNextModified .......................................................................... 701GetObjectAtPointer ...................................................................... 703GetParent..................................................................................... 704GetRow ........................................................................................ 705GetRowFromRowId...................................................................... 706GetRowIdFromRow...................................................................... 708GetSelectedRow .......................................................................... 709GetSQLPreview ........................................................................... 710GetSQLSelect .............................................................................. 711GetStateStatus............................................................................. 712GetText ........................................................................................ 715GetTrans ...................................................................................... 716GetUpdateStatus.......................................................................... 718GetValidate .................................................................................. 720GetValue ...................................................................................... 721GroupCalc .................................................................................... 723Hide.............................................................................................. 725ImportClipboard............................................................................ 726ImportFile ..................................................................................... 729ImportString.................................................................................. 734InsertDocument............................................................................ 739InsertRow ..................................................................................... 741IsExpanded .................................................................................. 743IsRowSelected ............................................................................. 744

xvii

IsSelected .................................................................................... 745LineCount..................................................................................... 746ModifiedCount .............................................................................. 748Modify........................................................................................... 749Move ............................................................................................ 765OLEActivate ................................................................................. 765OneTrip ........................................................................................ 767Paste ............................................................................................ 771PasteRTF ..................................................................................... 773PointerX ....................................................................................... 774PointerY ....................................................................................... 774Position ........................................................................................ 775PostEvent..................................................................................... 780Print.............................................................................................. 782PrintCancel................................................................................... 786ReplaceText ................................................................................. 790ReselectRow ................................................................................ 791Reset............................................................................................ 793ResetInk ....................................................................................... 794ResetTransObject ........................................................................ 795ResetUpdate ................................................................................ 796Resize .......................................................................................... 798Retrieve........................................................................................ 800RowCount .................................................................................... 806RowsCopy.................................................................................... 807RowsDiscard ................................................................................ 810RowsMove ................................................................................... 812SaveAs......................................................................................... 815SaveAsAscii ................................................................................. 818SaveAsFormattedText ................................................................. 820SaveInk ........................................................................................ 822SaveInkPic ................................................................................... 824Scroll ............................................................................................ 826ScrollFirstPage............................................................................. 827ScrollLastPage ............................................................................. 828ScrollNextPage ............................................................................ 829ScrollNextRow.............................................................................. 832ScrollPriorPage ............................................................................ 835ScrollPriorRow ............................................................................. 839ScrollToRow................................................................................. 842SelectedLength ............................................................................ 843SelectedLine ................................................................................ 844SelectedStart................................................................................ 846SelectedText ................................................................................ 847

xviii PowerBuilder

SelectRow .................................................................................... 848SelectText .................................................................................... 849SelectTextAll ................................................................................ 853SelectTextLine ............................................................................. 854SelectTextWord............................................................................ 855SelectTreeNode ........................................................................... 856SetAction...................................................................................... 857SetActionCode ............................................................................. 859SetBorderStyle ............................................................................. 861SetBrowser................................................................................... 862SetChanges ................................................................................. 864SetColumn ................................................................................... 866SetColumnLink............................................................................. 868SetDetailHeight ............................................................................ 870SetDWObject ............................................................................... 871SetFilter........................................................................................ 873SetFormat .................................................................................... 876SetFullState.................................................................................. 878SetHTMLAction ............................................................................ 881SetHTMLObjectName .................................................................. 882SetItem......................................................................................... 883SetItemDate ................................................................................. 887SetItemDateTime ......................................................................... 888SetItemNumber ............................................................................ 889SetItemStatus............................................................................... 890SetItemString ............................................................................... 896SetItemTime................................................................................. 897SetPageSize ................................................................................ 898SetPosition ................................................................................... 899SetRedraw ................................................................................... 901SetRow......................................................................................... 901SetRowFocusIndicator ................................................................. 903SetSelfLink ................................................................................... 905SetServerServiceClasses ............................................................ 908SetServerSideState...................................................................... 910SetSort ......................................................................................... 912SetSQLPreview............................................................................ 915SetSQLSelect............................................................................... 916SetTabOrder ................................................................................ 919SetText......................................................................................... 920SetTrans....................................................................................... 922SetTransObject ............................................................................ 927SetValidate................................................................................... 931SetValue....................................................................................... 933

xix

SetWeight..................................................................................... 935SetWSObject................................................................................ 939ShareData .................................................................................... 941ShareDataOff ............................................................................... 945Show ............................................................................................ 946ShowHeadFoot ............................................................................ 947Sort............................................................................................... 948TextLine ....................................................................................... 951TriggerEvent................................................................................. 952TypeOf ......................................................................................... 953Undo............................................................................................. 953Update.......................................................................................... 954

10 ........... 961CategoryCount ............................................................................. 961CategoryName ............................................................................. 962Clipboard...................................................................................... 963DataCount .................................................................................... 964FindCategory................................................................................ 964FindSeries .................................................................................... 966GetData........................................................................................ 966GetDataDateVariable ................................................................... 968GetDataNumberVariable.............................................................. 969GetDataPieExplode...................................................................... 970GetDataPieExplodePercentage ................................................... 971GetDataStringVariable ................................................................. 972GetDataStyle................................................................................ 972GetDataStyleColorValue .............................................................. 979GetDataStyleFillPattern................................................................ 979GetDataStyleLineStyle ................................................................. 980GetDataStyleLineWidth................................................................ 981GetDataStyleSymbolValue........................................................... 981GetDataValue............................................................................... 982GetSeriesStyle ............................................................................. 984GetSeriesStyleColorValue ........................................................... 992GetSeriesStyleFillPattern ............................................................. 992GetSeriesStyleLineStyle .............................................................. 993GetSeriesStyleLineWidth ............................................................. 994GetSeriesStyleOverlayValue........................................................ 994GetSeriesStyleSymbolValue ........................................................ 995ObjectAtPointer ............................................................................ 996ObjectAtPointerDataPoint ............................................................ 997ObjectAtPointerSeries.................................................................. 998Reset............................................................................................ 998

xx PowerBuilder

ResetDataColors .......................................................................... 999SaveAs ....................................................................................... 1000SeriesCount................................................................................ 1002SeriesName................................................................................ 1003SetDataPieExplode .................................................................... 1004SetDataStyle............................................................................... 1005SetSeriesStyle ............................................................................ 1011

11 Web ActiveX 1021Web ActiveX ............ 1021 .... 1022 ........ 1023AboutBox .................................................................................... 1023Commit ....................................................................................... 1024Connect ...................................................................................... 1024Disconnect.................................................................................. 1025GetDBCode ................................................................................ 1025GetSQLCode .............................................................................. 1026GetSQLErrText........................................................................... 1027GetSQLNRows........................................................................... 1027GetSQLReturnData .................................................................... 1028Rollback...................................................................................... 1028

............................................................................................................................................ 1029

xxi

xxii PowerBuilder

DataWindow

PowerBuilder

PowerScript PowerScript

PowerBuilder PowerBuilder

2 Volume 1 : 1 8 Volume 2 : 9 11

PowerBuilder DVD Web Sybase Web

PowerBuilder DVD PDF PDF Adobe Acrobat Reader Adobe Acrobat Reader Adobe Web

Web Web Web PDF HTML

xxiii

PowerBuilder http://www.ashisuto.co.jp/prod/powerbuilder/

Sybase Web Web Sybase EBF/

Sybase Web Product Manuals http://www.sybase.com/support/manuals/

Retrieve Update

true false

variable file nam

myCounter

pblname.pbd

dw_1.Update()

xxiv PowerBuilder

1

15

1 4 11 11Describe 12 13

1

1-1:

Quick Select SQL Select SQL Select SQL DBMS

4 5

1-2:

Today ( ) Today Salary / 12 Sum (Salary for group 1) Sum

Price*Quantity

2 PowerBuilder

1

true false

1-3:

false

GetText GetText Interger Real

@placeholder @placeholder

@placeholder GetText

Academics = "*****" AND Cost = "$$$"

$$$

Emp_sal < 500000 50

Salary > 500000 AND Dept_idBETWEEN 400 AND 700

400 500 600 700 50

Month(Bdate) = 9 OR Month(Bdate) = 2

9 2

Match ( Lname, "[ ^ABC ]" ) ABC

3

1-4:

4

4

5

9

10

@column >= 100000 Integer(GetText())>= 100000

10

@column IN (100, 200, 300)

Integer(GetText()) IN (100, 200, 300)

100 200 300 ID

@salary > 0 Long(GetText()) > 0

Match(@disc_price, "^[0-9]+$") and @disc_price < Full_Price

Match(GetText( ), "^[0-9]+$") and Real(GetText()) < Full_Price

Full_Price

4 PowerBuilder

1

1-5:

16 18

1-6:

null null null null null 5 null null IsNull

null null false

true false

true false null false null column > 5 false NOT column > 5 true

LIKE IN BETWEEN

+ SubTotal + Tax- Price - Discount* Quantity * Price/ Discount / Price^ Rating ^ 2.5

20.0/3 6.6666666666666673*(20.0/3) 20Truncate(20.0/3,4) 6.6666

5

1-7:

1-8:

LIKE NOT LIKE

LIKE NOT LIKE LIKE NOT LIKE % _

Salary Background.Color

If(emp_lname LIKE' %',RGB(255,0,0),RGB(255,255,255))

= Price = 100> Price > 100< Price < 100 Price 100>= Price >= 100

1

escape % _ escape _

comment LIKE ~'%o_a15progress%~'

escape * _ _

comment like ~'%o*_a15progress%~' escape ~'*~'

BETWEEN NOT BETWEEN

BETWEEN NOTBETWEEN

Salary Background.Color 50 100

If(salary BETWEEN 500000 AND 1000000, RGB(255,0,0), RGB(255,255,255))

BETWEEN NOT BETWEEN Finance Sales

If(dept_name BETWEEN 'Finance' AND 'Sales',1,0)

BETWEEN NOT BETWEEN % _ 1

If(dept_name BETWEEN 'F%' AND 'S%',1,0)

BETWEEN NOT BETWEEN

GetRow( ) BETWEEN 5 AND 8

IN NOT IN

IN NOT IN

7

Salary Background.Color 300 400 50 100

If(dept_id IN (300,400) and salary BETWEEN 500000 AND 1000000, RGB(255,0,0), RGB(255,255,255))

City1 Tokyo City2 TOKYO

City1=City2

false

Upper Lower

Upper(City1)=Upper(City2)

true

15

City1 Tokyo City2 TOKYO

City1=City2

false PowerBuilder

Trim LeftTrim trim

:Trim(City1)=Trim(City2)

true

8 PowerBuilder

1

City1 + ">" = City2 + ">"

15

true false

1-9:

2 true false true false true false

true false OR true AND false

1-10:

NOT A true NOT A false A false NOT A true

NOT Price = 100

AND A AND B A B true true A AND B false false

Tax > 3 AND Ship < 5

OR A OR B true true A OR B false false

Tax > 3 OR Ship < 5

TRUE AND TRUE TRUETRUE AND FALSE FALSEFALSE AND TRUE FALSEFALSE AND FALSE FALSE

9

null null false null NOT true NOT gf_boolean () gf_boolean null true

2 Blob

+

1-11:

' " + ' ' + ' '

TRUE OR TRUE TRUETRUE OR FALSE TRUEFALSE OR TRUE TRUEFALSE OR FALSE FALSENOT TRUE AND TRUE FALSENOT TRUE AND FALSE FALSENOT FALSE AND TRUE TRUENOT FALSE AND FALSE FALSENOT TRUE OR TRUE TRUENOT TRUE OR FALSE FALSENOT FALSE OR TRUE TRUENOT FALSE OR FALSE TRUE

" " + " " Lname + ', ' + Fname Lname Fname

,

10 PowerBuilder

1

1-12:

x+y*a+b y a x b +

x+(y*(a+b)) a+b a+b y x

Describe

GetRow

( ) ^ * / + - IN LIKE BETWEEN SQL SELECT = >

Describe

ll_rownum = dw1.GetRow()

ls_first = dw1.Object.DataWindow.FirstRowOnPagels_last = dw1.Object.DataWindow.LastRowOnPagedw_1.Title = "Rows " + ls_first + " to " + ls_last

15

Describe Describe Evaluate Describe

Evaluate dwcontrol .Describe ("Evaluate ( 'expression' , rownumber ) " )

Expression rownumber

string ls_modstring, ls_rownumls_rownum = String(dw1.GetRow())

ls_modstring = "Evaluate('Page()'," + ls_rownum +")"

// 99 // Evaluate('Page()', 99)

Parent.Title = &"Current page: "+ dw1.Describe(ls_modstring)

12 PowerBuilder

1

5 dept_id dw1.Describe("Evaluate('LookUpDisplay(dept_id)', 5)")

rownumber 0 !

dw1.Describe("Evaluate('Sum(Salary)', 0)")

Evaluate

dw1.Describe("Evaluate('" + sle_expr.Text + "', 0)")

Emp_Id Protect 1 Emp_Id 1

1

ID ID Protect

If(IsRowNew(), 0, 1)

Protect Protect

"0 If(IsRowNew(), 0, 1)"

13

Protect Evaluate Describe

emp_id Protect Protect Evaluate Describe

string ls_protect, ls_evallong ll_row

ll_row = dw1.GetRow()ls_protect = dw1.Object.id.Protect

IF NOT IsNumber(ls_protect) THEN

// ~t ls_protect = Right(ls_protect, &

Len(ls_protect) - Pos(ls_protect, "~t"))

// Describe //

ls_eval = "Evaluate(~"" + ls_protect + ", " & + String(ll_row) + ")"

ls_protect = dw1.Describe(ls_eval)

END IF

// st_result.Text = ls_protect

14 PowerBuilder

2

1

DoubleDecimalStringDateTimeTime

BooleanDate Integer

AvgMax StDev Sum

15 17 25

15

PowerBuilder

Double Decimal String Boolean DateDateTime Time Boolean 15

Today PowerScript Today Today

1000 , .

1000

136 String 60 DayName

16 PowerBuilder

2

1 : null null null 1 null null

Enterprise Application Fin_code Fin_code 3

2-1: Fin_code

code description description null

description null

Count(description for all)

null description Sum(If(IsNull(description), 1, 0))

description null 1 description null 0

Count(id for all)

null code type code description code

17

id Sum(If(IsNull(description), 1, 1))

description null null Count(id for all)

IsNull(description)

description null IsNull true false

8 description 3 null5 null description Id=8 null

18 PowerBuilder

2

2 : 1 Sum Count Sum Count 2

CrosstabAvg CrosstabAvgDec CrosstabCount CrosstabMaxCrosstabMaxDec CrosstabMin CrosstabMinDec CrosstabSum CrosstabSumDec

Sum

EAS Demo DB employee Emp_id Sex

Sum If 2

Sum(If(sex = "M", 1, 0))

Sum(If(sex = "F", 1, 0))

Avg Large Mode Sum

Count Last Percent Var

CumulativePercent Max Small VarP

CumulativeSum Median StDev

First Min StDevP

19

1

2 Select Department emp_id sex Employee

20 PowerBuilder

2

3 department_dept_name

4

5 2 Sum(If(sex = "M", 1, 0) for group 1)

Sum(If(sex = "F", 1, 0) for group 1)

21

3 : Bitmap Case CurrentRow GetRow RGB

Enterprise Application Employee emp_id emp_fname emp_lname salary

CurrentRow( )

If(CurrentRow()= GetRow(), 1, 0)

If CurrentRow GetRow

If(CurrentRow() = GetRow(),"Current","Not current")

Current Not current

Bitmap CurrentRow GetRow 1

Bitmap(If(CurrentRow()= GetRow(), "c:\sampl\ex\code\indicatr.bmp", " "))

salary Background.Color Case(salary WHEN IS >600000 THEN RGB(192,192,192)WHEN IS >400000 THEN RGB(0,255,0) ELSERGB(255,255,255))

40 60

22 PowerBuilder

2

2

2 1 3 Not current 2

1 40 2 60 3

4 : null null null null null

idcorporationaddress1 address2 4 corporation address1 address2 null 4 address1 address2

23

address1 address2

address1 + ", " + address2

address1 address2 null null address2 null address1 address2

If IsNull

If(IsNull(address1 + address2), address1, address1+ ", " + address2)

null address2 null address1 null

24 PowerBuilder

2

ABC Corporation XYZ Corporation null 2 null

25

Abs

Abs

Abs ( n )

n n

Count(product_number for All DISTINCT Abs (product_number))

5 Abs(value_set) > 5

CountPowerScript Abs

ACos

ACos ( n )

Double n

0 ACos(1)

3.141593 6 ACos(-1)

1.000000 6 ACos(.540302)

n

n : 2 -1 1

26 PowerBuilder

2

CosASinATanPowerScript ACos

Asc Unicode Unicode

Unicode

Asc ( string )

Integer string

Asc

code_id A (65) code_id

If (Asc(code_id) = 65, code_id, "Not a valid code")

lname

IF (Asc(lname) > 64 AND Asc(lname) < 91, lname, WordCap(lname))

CharWordCapPowerScript Asc

string

27

AscA

AscA ASCII

AscA ( string )

Integer string ASCII

AscA

ASCII

code_id ASCII A (65) code_id

If (AscA(code_id) = 65, code_id, "Not a valid code")

lname

IF (AscA(lname) > 64 AND AscA(lname) < 91, lname, WordCap(lname))

CharAWordCapPowerScript AscA

ASin

ASin ( n )

Double n

0.999998 6 ASin(.84147)

string ASCII

n : 2 -1 1

28 PowerBuilder

2

0.520311 6 ASin(LogTen (Pi (1)))

0 ASin(0)

SinACosATanPi PowerScript ASin

ATan

ATan ( n )

Double n

0 ATan(0)

1.000 3 ATan(1.55741)

1.267267 6 ATan(Pi(1))

TanASinACosPowerScript ATan

n : 2

29

Avg

Avg

Avg ( column { FOR range { DISTINCT { expres1 {, expres2 {, ... } } } } } )

range

range Avg range column DISTINCT Avg column expresn expresn column

column column # column column

FOR range

range

ALL column GROUP n column GROUP 1

GROUP

PAGE column range CROSSTAB CROSSTAB column

OLE

GRAPH column

OBJECT OLE column

DISTINCT

column column

expresn

1 expresn

30 PowerBuilder

2

OLE Range

OLE

OLE

null

salary Avg(salary)

salary group 1

Avg(salary for group 1)

5 Avg(#5 for page)

Above Average

If(Avg(salary for page) > Avg(salary), "Above Average", " ")

sale_price

Avg(sale_price)

31

Bitmap

sale_price

Avg(sale_price for graph)

Avg(order_amt for all DISTINCT order_nbr)

MedianMode

Bitmap

Bitmap

Bitmap ( string )

Bitmap string

employees

Bitmap(employees)

string BMPGIF JPEG RLE WMF

32 PowerBuilder

2

employees 3

Bitmap(#3)

tools.bmp Bitmap("TOOLS.BMP")

password

Bitmap(If(password = "y", "yes.bmp", "no.bmp"))

22 3 :

Case

Case ( column WHEN value1 THEN result1 { WHEN value2 THEN result2 { ... } } { ELSE resultelse } )

column column # column column valuen

WHEN

1 WHEN

valuen column 1

:2, 4, 6, 8 TO : 1 TO 20 IS

: IS>5 OR : 1,3,5,7,9,27 TO

33, IS>42THEN column valuen

33

Ceiling

resultn resultn

WHEN column Case

salary 700 500

Case(salary WHEN IS >7000000 THEN RGB(255,0,0) WHEN IS>5000000 THEN RGB(0,255,0) ELSE RGB(0,0,255))

employee id id 101 id 102 id

Case(emp_id WHEN 101 THEN 255 WHEN 102 THENRGB(100,100,100) ELSE 0)

marital_status marital_status Single Married Unknown

Case(marital_status WHEN 'S'THEN 'Single' WHEN 'M' THEN'Married' ELSE 'Unknown')

22 3 : If

Ceiling

Ceiling ( n )

resultn valuen Case resultn

ELSE

valuen column Case resultelse

resultelse column WHEN valuen Case

n

34 PowerBuilder

2

n n

-4 Ceiling(-4.2)

Ceiling(-4.8)

discount_factor price discount_amt ERROR discount_amt

If(discount_amt

CharA

CharA ASCII

CharA ( n )

String ASCII n

CharA(27)

AscA PowerScript CharA

Cos

Cos ( n )

Double n

1 Cos(0)

.540302 Cos(1)

- 1 Cos(Pi(1))

PiSinTanPowerScript Cos

n

n :

36 PowerBuilder

2

Count

Count ( column { FOR range { DISTINCT { expres1 {, expres2 {, ... } } } } } )

range range column DISTINCT column expresn expresn column

OLE Range

column column # column

FOR range

range

ALL column GROUP n column GROUP 1

GROUP

PAGE column range CROSSTAB CROSSTAB column

OLE

GRAPH column

OBJECT OLE column

DISTINCT

Count column column

expresn

1 expresn

37

Count

OLE

OLE

null Count

emp_id null Count(emp_id)

group 1 emp_id null

Count(emp_id for group 1)

dept_id Count(dept_id for all DISTINCT)

Count(region_id for all DISTINCT Lower(product_id))

3 null Count(#3 for page)

17 1 : null

38 PowerBuilder

2

CrosstabAvg

CrosstabAvg

CrosstabAvg ( n {, column, groupvalue } )

Double n Decimal CrosstabAvgDec

null

Crosstab 2 year quarter1 code Avg(amount for crosstab)

n

column

groupvalue

groupvalue @ "

39

CrosstabAvg

avg_amount

CrosstabAvg(1, 2, "@year")

2 grand_avg_amount

CrosstabAvg(1)

Avg amount

40 PowerBuilder

2

Crosstab Crosstab year quarter

CrosstabAvg(1, 2, "@year")

2 quarter 2 "@year" year Crosstab

year department quarter employee 2

Avg Sum Max

41

CrosstabAvgDec

Count(emp_id for crosstab),Sum(salary for crosstab)

1

CrosstabAvg(1)

2

CrosstabAvg(2)

2 region city Avg(sales for crosstab) region city

CrosstabAvg(1, 2, "@region")

city

CrosstabAvg(1)

CrosstabAvgDecCrosstabCountCrosstabMaxCrosstabMinCrosstabSum

CrosstabAvgDec

Decimal CrosstabAvgDec

42 PowerBuilder

2

CrosstabAvgDec ( n {, column, groupvalue } )

Decimal n

Double Decimal CrosstabAvg CrosstabAvg

CrosstabMaxDecCrosstabMinDecCrosstabSumDec

CrosstabCount

CrosstabCount ( n {, column, groupvalue } )

n

column

groupvalue

groupvalue @ "

43

CrosstabCount

Long n

null

CrosstabAvg

Count(emp_id for crosstab),Sum(salary for crosstab)

1

CrosstabCount(1)

2

CrosstabCount(2)

2 2 year quarter1 product Avg(sales for crosstab)

n

column

groupvalue

groupvalue @ "

44 PowerBuilder

2

CrosstabCount(1, 2, "@year")

CrosstabCount(1)

Crosstab CrosstabAvg

CrosstabAvgCrosstabMaxCrosstabMinCrosstabSum

CrosstabMax

CrosstabMax

CrosstabMax ( n {, column, groupvalue } )

n

column

groupvalue

groupvalue @ "

45

CrosstabMax

Double n Decimal CrosstabMaxDec

null

CrosstabAvg

Count(emp_id for crosstab),Sum(salary for crosstab)

1

CrosstabMax(1)

2

CrosstabMax(2)

2 2 year quarter1 product Avg(sales for crosstab)

CrosstabMax(1, 2, "@year")

CrosstabMax(1)

Crosstab CrosstabAvg

46 PowerBuilder

2

CrosstabAvgCrosstabCountCrosstabMaxDecCrosstabMinCrosstabSum

CrosstabMaxDec Decimal

CrosstabMaxDec

CrosstabMaxDec ( n {, column, groupvalue } )

Decimal n

Double Decimal CrosstabMax CrosstabMax

CrosstabAvgDecCrosstabMinDecCrosstabSumDec

n

column

groupvalue

groupvalue @ "

47

CrosstabMin

CrosstabMin

CrosstabMin

CrosstabMin ( n {, column, groupvalue } )

Double n Decimal CrosstabMinDec

null

CrosstabAvg

n

column

groupvalue

groupvalue @ "

48 PowerBuilder

2

Count(emp_id for crosstab),Sum(salary for crosstab)

1

CrosstabMin(1)

2

CrosstabMin(2)

2 2 year quarter1 product Avg (sales for crosstab)

CrosstabMin(1, 2, "@year")

CrosstabMin(1)

Crosstab CrosstabAvg

CrosstabAvgCrosstabCountCrosstabMaxCrosstabMinDecCrosstabSum

CrosstabMinDec

Decimal CrosstabMinDec

49

CrosstabSum

CrosstabMinDec ( n {, column, groupvalue } )

Decimal n

Double Decimal CrosstabMin CrosstabMin

CrosstabAvgDecCrosstabMaxDecCrosstabSumDec

CrosstabSum

CrosstabSum

CrosstabSum ( n {, column, groupvalue } )

n

column

groupvalue

groupvalue @ "

n

50 PowerBuilder

2

Double n DecimalCrosstabSumDec

null

CrosstabAvg

Count(emp_id for crosstab),Sum(salary for crosstab)

1

CrosstabSum(1)

2

CrosstabSum(2)

2 2 year quarter1 product Avg(sales for crosstab)

column

groupvalue

groupvalue @ "

51

CrosstabSumDec

CrosstabSum(1, 2, "@year")

CrosstabSum(1)

Crosstab CrosstabAvg

CrosstabAvgCrosstabCountCrosstabMaxCrosstabMinCrosstabSumDec

CrosstabSumDec Decimal

CrosstabSumDec

CrosstabSumDec ( n {, column, groupvalue } )

n

column

groupvalue

groupvalue @ "

52 PowerBuilder

2

Decimal n

Double Decimal CrosstabSum CrosstabSum

CrosstabAvgDecCrosstabMaxDecC