untitled

1

OZ Application Designer User's Guide 2

3

OZ Application Designer User's Guide 4

5

OZ Application Designer User's Guide Application 'OZ Application Designer', 'OZ Application Designer' 'OZ Application Designer', OZC, OZS, OZF.. OZ Application Designer OZ Application Designer. OZ Application Designer,,, OZ Application Designer. OZ Application Designer Document, Board OZ Application Designer. 6

OZ Application Designer,, OZC, EventHook.,,,. OZ Application Designer. OZ Function Editor OZF, OZ Function Editor, OZF. OZ Style Editor OZS, OZ Style Editor, OZS. OZ Application Designer. 7

OZ Application Designer User's Guide OZ Application Designer. Manual OZ Application Getting Started OZ Application Designer User's Guide Description OZ Application OZ Application Designer. 'OZ Application Designer' 'OZ Application Designer', OZC, OZS, OZF. OZ Application Viewer User's Guide OZ Query Designer User's Guide OZ Enterprise Server Administrator's Guide (). OZ Query Designer. OZ Enterprise Server OZ Enterprise Server,,, OZ Enterprise Server. 8

9

OZ Application Designer User's Guide OZ Application Designer. OS Windows NT 4.0, Windows XP, Windows 2000, Windows 2003 JRE 1.3 Windows 95/98/ME Unicode. CPU Pentium 500MHz Main Memory 256MB (512MB ) HDD 100MB XGA (1024 x 768 ) 10

OZ Application Designer. Folder File Name Description %OZA_HOME% Console.txt OZ Application Designer OZApplicationDesigner.exe OZ Application Designer OZApplicationFunctionEditor.exe Function Edtior OZApplicationStyleEditor.ex e Style Editor OZAViewer.exe OZ Application Viewer OZAViewerDll.dll OZ Application Viewer OZAViewerOCX.ocx OZ Application Viewer ActiveX United Control ozatransparent.dll Board %OZA_HOME% ozimgdecoder.dll bin ozexcel.dll Excel Export OZLabelPtnWiz_vc71.dll OZOptWiz_vc71.dll OZ Report Viewer OZRepositoryManager.ini OZUSLClientDes128.dll OZUSLClientSession.dll USL ScriptDebugger.dll unicows.dll Microsoft Layer of Unicode user.cif %OZA_HOME% OZ Application Designer ad.dll bin/res ) ad_ko_kr.dll OZ Application Designer ad_error_msg.xml ) ad_error_msg_ko_kr.xml af.dll Function Editor ) af_ko_kr.dll Function Editor af_error_msg.xml ) af_error_msg_ko_kr.xml 11

OZ Application Designer User's Guide %OZA_HOME% config %OZA_HOME% doc %OZA_HOME% images %OZA_HOME% lib %OZA_HOME% license as.dll Style Editor ) as_ko_kr.dll Style Editor as_error_msg.xml ) as_error_msg_ko_kr.xml OZ Application Viewer av_error_msg.xml ) av_error_msg_ko_kr.xml chartres.xml label_pattern.xml Label ) label_pattern_ko_kr.xml MultiLanguageList.xml rm.dll ) rm_ko_kr.dll rm_error_msg.xml ) rm_error_msg_ko_kr.xml sd.dll ex)sd_ko_kr.dll server_error_msg.xml ) server_error_msg_ko_kr.xml viewer_parameter.xml OZ Report Viewer ) viewer_parameter_ko_kr.xml launch.cfg OZ Application Designer CFFunc_3.5.xml codehelp_3.5.xml OZAPPAPI.chm OZ Application Designer API OZ Application Designer crimson.jar XML dtdparser120.jar DTD jcert.jar jnet.jar jsee.jar J2EE (HTTPS/SSL ) JRE 1.3.X log4j.jar Log ozsfw35.jar parser.jar xerces.jar XML ozlicense.xml 12

%OZA_HOME% UniversalDriver classes12.jar classes12.zip db2java.jar db2java.zip db2jcc.jar db2jcc_license_cisuz.jar db2jcc_license_cu.jar ifxjdbc.jar ijava.jar jconn2.jar jkjdbc.jar jt400.jar msbase.jar mssqlserver.jar msutil.jar mysql.jar sapjco.jar sapjcorfc.dll unisqljdbc10.jar unsqljdbc205.zip Oracle 8i, 9i JDBC Driver IBM DB2 JDBC IBM DB2 JDBC Type 8 (DB2 8 ) Infomix JDBC Oracle 7i JDBC Sybase ASE JDBC MSSQL 97 JDBC IBM JT400 JDBC MSSQL 2000 JDBC Mysql JDBC SAP UniSQL JDBC : 'UniversalDriver' JDBC, RDB JDBC. RDB JDBC. 13

OZ Application Designer User's Guide OZ Application Designer. [] -> [OZ XStudio] -> [OZ Application Designer 3.5] 'OZ Application Designer 3.5'. OZ Application Designer. 14

15

OZ Application Designer User's Guide,,, OZ Application Designer. OZ Application Designer,. / Board 16

Window / Board Description OZ Application Designer (pull down),,,,,,,. OZ Application Designer,,,,., ' ',,, ' ', Button, Label, Table ' ', ' ',, ' '. OZ Application Designer, ODI, OZF, OZS. Document, Board, Board,, - ' ', ODI,,, ' ', Invisibles, OZF, OZS, EventHook 'Invisibles ', ''.. '', ''. Board. Board Board,. Document, Board,.. 17

OZ Application Designer User's Guide OZ Application Designer (pull down),,,,,,,. (File) [File]. Create New Project (Ctrl+N). Board. Open Project (Ctrl+O). Close Project. Save Project (Ctrl+S). OZ Application Designer 18

oza. Save Project As. Add New Board Board. Remove Board Board. Board Board. Insert New ODI ODI. ODI. Insert New Style OZ Style (OZS). OZS Invisibles. Insert New Function OZ Function (OZF). OZF Invisibles. Preview (Ctrl+P).. : SDM "SDM " SDM. - <Shift> <Ctrl + Shift> [Preview] "SDM ". 19

OZ Application Designer User's Guide - <Shift> ODI SDM. SDM ODI SDM. - <Ctrl + Shift> ODI SDM. : SDM - "SDM " ODI. - SDM SDM. - SDM ODI FetchUnit DM_PER_DATAMODULE. - SDM SDM SDM ODI. "A.odi B.odi C.odi", SDM "C.sdm B.sdm A.sdm". Start Debug (Ctrl+F5). [Start Debug], ". OZ Application Designer ". Recent Project (OZA). OZA 4. Exit OZ Application Designer. 20

(Edit) [Edit]. Undo (Ctrl+Z). Board [Undo] Board, [Undo]. 256. Redo (Ctrl+Y),. Cut (Ctrl+X) Board. Board Board Board, ' '. Copy (Ctrl+C). Board 21

OZ Application Designer User's Guide Board Board. Paste (Ctrl+V). Delete (Delete). [Undo]. Copy Property. Paste Property.,. Select All (Ctrl+A) Board Board,. Find (Ctrl+F). Board, ODI, OZS, ODI, OZS ' ', ' '. - 22

'Find What', 'Find Form'. [Find Next]... 'Find From',. (,)., "Type" "Name" "Text" 'Button' [Find Next]. 23

OZ Application Designer User's Guide. Option Find From Script Match Case Match Whole Word Search Up Show All Include All Groups Description. /...., ODI, OZS.. Set Search Group Control Invisibles Controls, Container Controls, Complex Controls, Drawings Invisibles DataAccesses ODI Styles OZS - [Find Next].. Option Match Whole World Only Match Case Description.. 24

Direction,. Relpace (Ctrl+H). Board, ODI, OZS ' ', ' '. - 'Find What' 'Replace To', 'Find Form'. [Find Next], [Replace] [Replace All]. - [Find Next], [Replace] [Replace All]. Go To (Ctrl+G). 25

OZ Application Designer User's Guide. [Ok]. Export Script. Import Script. Preview Script. [Preview Script] ' ', ' ',,. ' ' [File] [Edit]. - File 26

Menu Save Script Export Script Import Script Exit Description.... - Edit Menu Undo (Ctrl+Z) Redo (Ctrl+Y) Cut (Ctrl+X) Copy (Ctrl+C) Paste (Ctrl+V) Delete (Del) Select All (Ctrl+A) Description...... 27

OZ Application Designer User's Guide Find (Ctrl+F) Replace (Ctrl+H) Go to.. [Go to Line] [Go to Event]. [Go to] [Go to Line].. [Ok]. [Go to] [Go to Event] ' '. 'Board1' [Go to Event]. 28

' '., 'Board1' Board, Board 'Button1', 'Button2' Button 'TextBox1', 'TextBox2' TextBox [Go to Event] ' '. 'Button1' 'OnClick', 'Button1' ' '. 29

OZ Application Designer User's Guide 'OnClick' ( ),. 'OnClick' [OK] 'Button1' 'OnClick'. (Insert) [Insert]. Controls Controls Button 25. 30

Controls. Component Button CheckBox RadioButton ReportButton ComboBox ListBox CheckListBox TreeView ListView TextBox NumericUpDown MaskTextBox RichTextBox Label PictureBox ProgressBar HTML View ActiveX Control Custom Control Description,,, OZ Report Designer Export, [ ] DropDown TextBox Up/Down, Up/Down Bar ActiveX Custom 31

OZ Application Designer User's Guide Report Control DateTimePicker MonthCalendar Splitter Horizontal Navigator Vertical Navigator OZ Report Designer Table Table Row, /// Button TextBox Table Table Row, /// Button / VScrollBar Invisibles Invisibles Timer 5. Invisibles. Component Timer Context Menu Main Menu Tooltip Image List Description Context Menu, MainMenu, TreeView 32

Container Controls Container Controls Panel 3. Container Controls. Panel GroupBox TabControl BoardView Description, TabPanel, Board Complex Controls Complex Controls Table 4. Complex Controls. Table Description 33

OZ Application Designer User's Guide Grid CrossTab Chart 2 3 Drawings Drawings Line 4. Drawings. Line ArrowLine Ellipse Rectangle Description,, (View) [View],,,. 34

Component Explorer Board, Controls, Container Controls, Complex Controls, Drawings,, - OZ Application Designer. Invisible Explorer Invisibles OZFunction, OZStyle, EventHook Invisibles OZ Application Designer. DataInfo Explorer ODI,,, OZ Application Designer. Repository Explorer OZ Application Designer. Property Grid OZ Application Designer. Event Grid OZ Application Designer. 35

OZ Application Designer User's Guide Script Editor OZ Application Designer. (Layout) [Layout]. Style [Style] 4. [Style]. Menu Bold Italic Underline StrikeOut Description.... Align [Align] 4 36

, 2. [Align]. Menu Lefts Rights Tops Bottoms Description.... Make Size Equal [Make Size Equal] 2, 2. [Make Size Equal]. Menu Width Description. 37

OZ Application Designer User's Guide Height. [Distribute Spacing Evenly] [Distribute Spacing Evenly] 2, 3. [Distribute Spacing Evenly]. Menu Horizontal Vertical Description.. Order [Order] 4. [Order]. Menu Bring to Front Description,. 38

Send to Back Bring Up Send Down,., '1'., '1'. (Tools) [Tools]. Default Value Editor ' '. Board [Default Value Editor]. 39

OZ Application Designer User's Guide ' '., Board, Button, Table, TextBox [Default Value Editor] ' '. 40

[Ok].. [Ok], [Apply to create new file]. OZ Application Designer [Restore] [Ok] [Apply to create new file]. Options,,,, OZ Application Designer,. 41

OZ Application Designer User's Guide [Ok] OZ Application Designer [Restore]. - Option General,,. Show Tooltip(Component) OZ Application Designer Board. Apply style in design time OZ Style OZS 42

. Docking Help OZ Application Designer. When select the component, the ScriptEditor synchronize,. Layout OZ Application Designer. Save layout when exit OZ Application Designer,,,,,, OZ Application Designer. OZ Application Designer [Reset window layout] [Save current layout]. International Setting. 43

OZ Application Designer User's Guide Save. Encrypt the file while saving. Verify form when saving.. Document ODI ODIKey, DataSet, Field, ValueField ODI Document Style OZS 44

Document ContextMenu, MainMenu, ToolTip, ImageList ContextMenu, MainMenu, ToolTip, ImageList Document Navigator LinkComponentName Document - Editor Environment : Script Editor / Preview Script / Calculated Field Editor,,,,. : OZ Application Designer... : [Edit] [Preview Script],. [Edit]. : [Insert New CalculatedField]... 45

OZ Application Designer User's Guide Font and Color : Script Editor / Preview Script / Calculated Field Editor,,,,,. External Tools [External Tools] 2. [External Tools]. Menu Style Editor Description OZS OZ Style Editor. OZS OZ Style Editor.. Function Editor OZF OZ Function Editor. OZF OZ Function Editor.. 46

(Help) [Help]. Help OZ Application Designer,, General Script,.. Drag & Drop. - (Script Help ) Drag & Drop. 47

OZ Application Designer User's Guide -.. 48

[Index].. [Search]. [List Topics] [Enter]. [Display]. 49

OZ Application Designer User's Guide About OZ Application OZ Application Designer. 50

OZ Application Designer,,,,,. (Standard),. Icon Description,,,,,, OZ Application Designer (Format),,,,. Icon Description 51

OZ Application Designer User's Guide,,,,,,,,, (Component) Controls, Invisibles, Container Controls, Complex Controls, Drawings. Icon Description Button, CheckBox, RadioButton, ReportButton ComboBox, ListBox, CheckListBox TreeView, ListView TextBox, NumericUpDown, MaskTextBox, RichText Box Label, Picture, ProgressBar HTMLView, ActiveXControl, CustomControl, Report Control DateTimePicker, MonthCalendar Splitter, HorizontalNavigator, VerticalNavigator Timer, ContextMenu, MainMenu, Tooltip, ImageList Panel, GroupBox, TabControl, BoardView Table, Grid, CrossTab, Chart 52

Line, ArrowLine, Ellipse, Rectangle (Layout),,,. Icon Description,,,,,,,, (View),. Icon Description Invisibles 53

OZ Application Designer User's Guide, ODI, Invisibles,,,, Invisibles,.,, -.. Board, Board Button, CheckBox, RadioButton, TextBox, Label, ComboBox. Button1, CheckBox1, RadioButton1, TextBox1, Label1, ComboBox1, Button1 TextBox1. 54

ODI,,,. ODI Sample.odi. ODI "Sample", "Customer", "customer_id", "lname",..., "birthdate", "MemberCard", "Gender". ODI.. Delete ODI Edit ODI Save As SDM ODI. ODI. [Edit ODI] ODI. ODI SDM. 55

OZ Application Designer User's Guide Show Property Refresh Explorer ODI., ODI. Invisibles Invisibles OZF, OZS, EventHook. Invisibles ContextMenu1, MainMenu1, ToolTip1, ImageList1, Timer1, OZ Style Sample.ozs, OZ Function Main.ozf. EventHook Document,. EventHook.. 56

,., Invisibles. ( ). 57

OZ Application Designer User's Guide, Invisibles OnClick. ( ). 58

,, OZ Application Designer. Board Drag & Drop. ( ) [Tools] -> [Options] [Reset Window Layout]. 59

OZ Application Designer User's Guide Board Board Board, Board,. Document, Board,... 60

61

OZ Application Designer User's Guide Document, Board OZ Application Designer. Document Document, ODI, OZF, OZS OZ Application Designer, Document. OZ Application Designer Timer, Context Menu, Main Menu, Tooptip, Image List Invisibles Board Document. Board Board User Interface, Button, TextBox, Table OZ Application Designer OZC OZC Document. OZ Application Designer Controls, Container Controls, Complex Controls, Drawings Board. 62

ODI, OZC, OZF, OZS. ODI, OZC, OZF, OZS.. OZ Application Designer OZ Application Designer Repository. Repository OZ Application Designer., OZ Application Designer, C:\Program Files\FORCS\OZ Product\ApplicationDesigner. C:\Program Files\FORCS\OZ Product\Repository. 'C:\Repository'.. 63

OZ Application Designer User's Guide [Set Working Folder]. 64

Board Board, Board. Board Board Board [Set As Startup Board] Board Board. Document Board Document StartupBoard Board Board. 65

OZ Application Designer User's Guide Document Board. Document Board Invisibles Document. Board [File] [Add New Board] Document Board. Board Board. 66

Invisibles [Insert] [Invisibles] Document Invisibles. 'Invisibles ' 'Invisibles' Invisibles. 67

OZ Application Designer User's Guide Board Controls, Container Controls, Complex Controls, Drawings Board. [Insert] Board Drag & Drop. TextBox. TextBox TextBox Board OZ Application Designer Board [Insert] -> [Controls] -> [TextBox] TextBox ( ) TextBox. Board Drag & Drop. 68

' ' 'Board1' 'TextBox1'. 69

OZ Application Designer User's Guide,.. 'OZ Application Designer',,.. 'FrameLineSize'. OZURL HTTP. : OZURL OZURL, OZ Application. 70

ozp:/// ozp:/// ex) ozp:///main.jpg ex) ozp://images/main.jpg file:/// ex) file://c:/title.gif. 'BackgroundImageAlign'. ( ). Alignment, 'TextAlign', 'CheckAlign'. 71

OZ Application Designer User's Guide,. - Label TextAlign 'MiddleLeft' () TextAlign = TopLeft () TextAlign = MiddleLeft Anchor,,,, 'Anchor'. Top, Bottom, Left, Right 4,. 'Anchor' Anchor. - Panel Button Anchor 'Top, Left' (Panel ) (Panel ) 72

- Panel Button Anchor 'Bottom, Right' (Panel ) (Panel ) Color,,, 'TextColor', 'BackColor', 'LineColor'. [Define Custom Colors]. [Add to Custom Colors]. Date MonthCalendar, DateTimePicker 'TodayDate', 'MinDate', 'MaxDate'. 73

OZ Application Designer User's Guide. Dock Docking, 'Dock'. Docking [NONE], Docking,,,,. File 'BackgroundImage', 'ImageListUrl'. [OK]. Font,,.,, [OK]. 74

Pattern, 'Pattern'. 'Category' [OK] 'Pattern'. Shortcut, 'Shortcut'. - ' '. 'Ctrl + C' [Ctrl]. 'None' 'Ctrl + ', [C] 'Ctrl + C'. 75

OZ Application Designer User's Guide [OK] 'Ctrl + C'. - ' ' [Delete]. Text. 'Multiline' 'True'. TextDirection, 'TextDirection'. (LeftToRight, RightToLeft) 76

(TopToBottom, BottomToTop). 'LeftToRight, TopToBottom', [OK]. 'RightToLeft, BottomToTop'. TextStretch, 'TextStretch'.. No Option Description Horizontal CountClockWise Vertical Vertical2 1Byte ClockWise Horizontal2 2Byte 77

OZ Application Designer User's Guide,,,,,. Board. Board, - Board Board 'Ctrl' 'Shift'. 78

- 'Ctrl' 'Shift'. Board Board. Drag & Drop. 'SnapToGrid' 'True', 'GridSize'. ( ). 'SnapToGrid' 'True', 'GridSize'. 79

OZ Application Designer User's Guide Drag. 'SnapToGrid' 'True', 'GridSize'. 'Shift'. 'SnapToGrid' 'True', 'GridSize'. Key Description Shift + Shift + Shift + Shift +.... 'Ctrl + C'. 'Ctrl + X'. 'Ctrl + V'. 80

'Delete'. 'Ctrl + Z'. 'Ctrl + Y'. [Layout] [Align],,,. - ( ). 'Button1'. ( ) ( ) - ( ). 'Button1'. 81

OZ Application Designer User's Guide ( ) ( ) - ( ). 'Button1'. ( ) ( ) - ( ). 'Button1'. ( ) ( ) 82

. - ( ). 'Button1'. ( ) ( ) - ( ). 'Button1'. ( ) ( ) [Layout] [Distribute Spacing Evenly],. - ( ).. 83

OZ Application Designer User's Guide ( ) ( ) - ( ). ( ) ( ) 84

.,. 'Board1' 'Button1', 'Button1' 'OnClick'.. - (Button1) 'Board1' 'Button1'. - (OnClick) 'Button1' 'OnClick'. 85

OZ Application Designer User's Guide Invisibles. - (Button1) 'Board1' 'Button1'. - (OnClick) 'Button1' 'OnClick' 86

( ) 'Button1' 'OnClick'.. Button... 87

OZ Application Designer User's Guide - '//', '//'. - '/*' '*/'. 'Ctrl + K + C', 'Ctrl + K + U'. [Ctrl +K + C] [Ctrl +K + U] 88

OZ Application Designer,,,,. 'Ctrl + Space'. OZ Application Designer,,,.,,,, 'Tab'... Icon Description 89

OZ Application Designer User's Guide Document Board, '.',. '.'. 90

.. Menu Undo(Ctrl+Z) Redo(Ctrl+Y) Cut(Ctrl+X) Copy(Ctrl+C) Paste(Ctrl+V) Delete(Delete) Select All(Ctrl+A) Description....... 91

OZ Application Designer User's Guide. OZ Application,,., "OnClick". BreakPoint, OZ Application BreakPoint.,,, OZ Application,. 92

OZ Application Break. OZ Application. OZ Application, Out. 93

OZ Application Designer User's Guide OZA [File] [Start Debug] (. ). Auto Watch Out Icon Menu Description Continue,. 94

Stop Debugging Step Into Step Over Step Out Auto Watch Out.... "Step Over".... :.. Auto. Auto. Watch. Watch. Out. Out Trace. Trace, Out. - Watch 95

OZ Application Designer User's Guide.,., OZ Application Designer. Document._SetGlobal("", ); //Document Document. _SetGlobal("", ); var myvar = _GetGlobal("");,., 'Document' 'GlobalFunction'. 96

function (Argument1, Argument2,... ) { //Script...... // return ; }. // (Argument1, Argument2,... ); // var result = (Argument1, Argument2,... ); Example. 97

OZ Application Designer User's Guide [Change Backcolor] Label. RadioButton. [Change Backcolor].. 98

Step 1, Board Label, RadioButton, Button,. Step 2 Label., RGB. 'Document' 'GlobalFunction'. function changebackcolor(compname) { var Comp = _GetCurrentBoard().GetChild(CompName); Comp.BackColor = _GetGlobal("Color"); } 'RadioButton1', RGB '255, 0, 0'. 'RadioButton1' 'OnClick'. _SetGlobal("Color", "255, 0, 0"); 'RadioButton1' 'RadioButton2', ''RadioButton3', 'RadioButton4' 'OnClick',, RGB. 99

OZ Application Designer User's Guide RadioButton2 OnClick _SetGlobal("Color", "0, 255, 0"); RadioButton3 OnClick _SetGlobal("Color", "0, 0, 255"); RadioButton4 OnClick _SetGlobal("Color", "0, 0, 0"); 'Button1', Label. 'Button1' 'OnClick'. changebackcolor("label1"); Step 3 [File] [Preview] (. ) 100

101

OZ Application Designer User's Guide OZ Application Designer,, OZC, EventHook. Button,. Property Button. Property Text FlatStyle Description Button Button Standard : 3 Flat : Example - 3 [OK]. - Board Button. Property Value Property Value Text OK FlatStyle Standard - 102

Label. Property Label. Property FrameLineSize WordWrap InternalMargin Description,,,,,, Example - Label. - Board Label. Property Value Property Value Text Hello World FrameLineSiz e 0, 0, 0, 0 WordWrap True InternalMargi n 4, 4, 4, 4 103

OZ Application Designer User's Guide - TextBox. Property TextBox. Property BorderStyle ScrollBars Multiline Description Fixed3D : 3 FixedSingle : None : Horizontal :, 'Multiline' 'True' 'WordWrap' 'False'. Vertical : 'Multiline' 'True' 'WordWrap' 'False'. Both :,, 'Multiline' 'True' 'WordWrap' 'False'. None : 104

PasswordChar WordWrap, '*' TextBox 'AAA' '***' Example -, TextBox. - Board TextBox. Property Value Property Value ScrollBars Both Multiline True WordWrap False - - - CheckBox. Property CheckBox. 105

OZ Application Designer User's Guide Property Checked CheckState Appearance ThreeState Description True :, CheckState 'Checked' False :, CheckState 'Unchecked' CheckBox Checked : Appearance 'Normal', 'Button', Checked 'True' Unchecked : Appearance 'Normal', 'Button', Checked 'False' Indeterminate : Appearance 'Normal', 'Button' CheckBox Normal : Button : CheckState Check, Uncheck, Indeterminate Example - CheckBox Checked, Check, Uncheck CheckBox CheckBox Indeterminate, Check, Uncheck, Indeterminate CheckBox. - Board CheckBox. Property Value Property Value Checked True CheckState Checked ThreeState False - - 106

Board CheckBox. Property Value Property Value Checked True CheckState Indeterminate ThreeState True - - - RadioButton. Property RadioButton. Property Description Checked Example - Board RadioButton 2 RadioButton. - Board RadioButton. 107

OZ Application Designer User's Guide - ComboBox,. ComboBox, ComboBoxItem,. Property ComboBox. Property DropDownStyle AutoSelect SelectedIndex SelectedText Description DropDown DropDown : TextBox DropDownList : ComboBox. DropDownStyle 'DropDown'. 0. DropDownStyle DropDownList Method ComboBox. 108

- AddItem ComboBox,. Format object AddItem(string ItemText); ItemText : Example var objitem = ComboBox1.AddItem("a new item label"); - InsertItem ComboBox,. Format object InsertItem(integer ItemIndex, string ItemText); ItemIndex : ItemText : Example var objitem = ComboBox1.InsertItem(5, "a new item label"); - RemoveItem. Format void RemoveItem(integer ItemIndex); ItemIndex : Example ComboBox1.RemoveItem(5); - GetItemObject ComboBox. Format object GetItemObject(integer ItemIndex); ItemIndex : 109

OZ Application Designer User's Guide Example var objitem = ComboBox1.GetItemObject(5); objitem.itemvalue = "CODE0123"; Example - ComboBox. - Board ComboBox. Property Value Property Value DropDownSty le DropDown AutoSelect True ComboBox(Name=ComboBox1) 'OnInitialize'. var objitem; objitem = ComboBox1.AddItem("Golden"); objitem.itemvalue = 1; objitem = ComboBox1.AddItem("Silver"); objitem.itemvalue = 2; objitem = ComboBox1.AddItem("Bronze"); objitem.itemvalue = 3; ComboBox1.SelectedIndex = 0; Button 'Text' 'Get ComboBoxItem' Button 'OnClick'. var objitem = ComboBox1.GetItemObject(ComboBox1.SelectedIndex); _MessageBox(objItem.Text + " " + objitem.itemvalue); - ComboBox [Get ComboBoxItem] (Text) (ItemValue). 110

ListBox. ListBox, ListBoxItem,. Property ListBox. Property ItemSelectionMode FocusedIndex FocusedText Description One : MultiSimple : MultiExtended : Shift, Ctrl None: Method ListBox. - AddItem ListBox,. 111

OZ Application Designer User's Guide Format object AddItem(string ItemText); ItemText : Example var objitem = ListBox1.AddItem("a new item label"); - InsertItem ListBox,. Format object InsertItem(integer ItemIndex, string ItemText); ItemIndex : ItemText : Example var objitem = ListBox1.InsertItem(5, "a new item label"); - RemoveItem. Format void RemoveItem(integer ItemIndex); ItemIndex : Example ListBox1.RemoveItem(5); - GetItemObject ListBox. Format object GetItemObject(integer ItemIndex); ItemIndex : Example var objitem = ListBox1.GetItemObject(5); objitem.itemvalue = "CODE0123"; 112

- GetSelectedIndexes ListBox. Format void GetSelectedIndexes(Array SelectedIndexArray); SelectedIndexArray : Example var SelectedIndexs = new Array(); ListBox1.GetSelectedIndexes(SelectedIndexs); Example - ListBox. - Board ListBox. Property Value Property Value ItemSelectio nmode MultiExtended - - ListBox(Name=ListBox1) 'OnInitialize'. ListBox1.AddItem("Golden"); ListBox1.AddItem("Silver"); ListBox1.AddItem("Bronze"); ListBox1.AddItem("Normal"); Button 'Text' 'Get SelectedItem' Button 'OnClick'. var SelectedIndexs = new Array(); ListBox1.GetSelectedIndexes(SelectedIndexs); for(i=0;i<selectedindexs.length;i++) { _MessageBox(ListBox1.GetItemObject(SelectedIndexs[i]).Text) ; } 113

OZ Application Designer User's Guide - ListBox Shift, Ctrl [Get SelectedItem] (Text). CheckListBox. CheckListBox, CheckListBoxItem,. Property CheckListBox. Property ItemSelectionMode FocusedIndex FocusedText Description One : MultiSimple : MultiExtended : Shift, Ctrl None: 114

Method CheckListBox. - AddItem CheckListBox,. Format object AddItem(string ItemText); ItemText : Example var objitem = CheckListBox1.AddItem("a new item label"); - InsertItem CheckListBox,. Format object InsertItem(integer ItemIndex, string ItemText); ItemIndex : ItemText : Example var objitem = CheckListBox1.InsertItem(5, "a new item label"); - GetItemObject CheckListBox. Format object GetItemObject(integer ItemIndex); ItemIndex : Example var objitem = CheckListBox1.GetItemObject(5); objitem.itemvalue = "CODE0123"; - AddCheck Checked. 115

OZ Application Designer User's Guide Format void AddCheck(integer ItemIndex); ItemIndex : Example CheckListBox1.AddCheck(5); - RemoveCheck Unchecked. Format void RemoveCheck(integer ItemIndex); ItemIndex : Example CheckListBox1.RemoveCheck(5); - GetCheckedIndexes CheckListBox Checked. Format void GetCheckedIndexes(Array CheckedIndexArray); CheckedIndexArray : Checked Example var CheckedIndexs = new Array(); CheckListBox1.GetCheckedIndexes(CheckedIndexs); Example - CheckListBox. - Board CheckListBox(Name=CheckListBox1), CheckListBox 'OnInitialize'. 116

CheckListBox1.AddItem("Golden"); CheckListBox1.AddItem("Silver"); CheckListBox1.AddItem("Bronze"); CheckListBox1.AddItem("Normal"); Button 'Text' 'Get CheckedItem' Button 'OnClick'. var CheckedIndexs = new Array(); CheckListBox1.GetCheckedIndexes(CheckedIndexs); for(i=0;i<checkedindexs.length;i++) { _MessageBox(CheckListBox1.GetItemObject(CheckedIndexs[i]).T ext); } - CheckListBox [Get CheckedItem] Checked (Text). PictureBox BMP, JPG, GIF. Property PictureBox. 117

OZ Application Designer User's Guide Property Image ImageAlign SizeToImage Description PictureBox None : Fit : PictureBox Tile : TopLeft/TopCenter/TopRight : // MiddleLeft/MiddleCenter/MiddleRight : / / BottomLeft/BottomCenter/BottomRight : // PictureBox Example PictureBox. - PictureBox 'Image1.gif'. - Board PictureBox. Property Value Property Value Image ozp:///image1.gif ImageAlign None - 118

NumericUpDown TextBox Up/Down, TextBox Up/Down. Property NumericUpDown. Property DecimalPlaces Hexadecimal Increment MaxVal MinVal ThousandsSeparator Value Description 16 Up/Down Example NumericUpDown. 119

OZ Application Designer User's Guide -,,, 5. - Board NumericUpDown. Property Value Property Value Increment 1000 MaxVal 10000000 MinVal 10000 ThousandsSe parator True Value 50000 - - - MaskTextBox. Property MaskTextBox. 120

Property CharacterCasing Mask Literal Default PromptChar Description Normal: Upper: Lower: Method MaskTextBox. - SetEditMask MaskTextBox,,. Format void SetEditMask(string Mask, string Literal, string Default); Mask :. Mask Description #, Space, +, - L?, Space A a & H X,,, Space, Space > ( ) < ( ) Literal : PromptChar Default : 121

OZ Application Designer User's Guide Example MaskTextBox1.SetEditMask("####/##/##", " / / ", "2005/01/01"); MaskTextBox1.SetEditMask(">>.##:##", ". : ", "AM.09:00"); MaskTextBox1.SetEditMask("######-#######", " - ", "800101-1234567") MaskTextBox1.SetEditMask("###)####-####", " ) - ", "010)222-3333"); Example MaskTextBox. - '--'. - Board MaskTextBox. Property Value Property Value Mask >>>-####-### Literal - - Default ABC-0504-001 PromptChar _ - 122

RichTextBox. RichTextBox,. Property RichTextBox. Property RichEditText Description,, GetSel() GetSelText(). Method RichTextBox. - GetDefCharFormat RichTextBox. Format object GetDefCharFormat(); - GetSelectCharFormat RichTextBox. Format object GetSelectCharFormat([integer StartIndex, integer EndIndex]); StartIndex : EndIndex : - SetDefCharFormat RichTextBox. Format void SetDefCharFormat(object RichCharFormat); 123

OZ Application Designer User's Guide - SetSelectCharFormat. Format void SetSelectCharFormat(object RichCharFormat, [integer StartIndex, integer EndIndex]); StartIndex : EndIndex : Example RichTextBox1 RichTextBox2. - RichTextBox1 RichTextBox2. RichTextBox1 RichTextBox1 RichTextBox2. - Board RichTextBox. Board Button, Button 'OnClick'. var SelText = RichTextBox1.GetSelText(); if(seltext == "") { RichTextBox2.RichEditText = RichTextBox1.RichEditText; } else { var Pos = RichTextBox1.GetSel(); var objcharformat = RichTextBox1.GetSelectCharFormat(Pos.x, Pos.x + SelText.length); RichTextBox2.SetDefCharFormat(objCharFormat); } 124

- RichTextBox1 "GOOD" [Ok]. TreeView. TreeView, TreeNode,. Property TreeView. Property CheckBoxes ShowPlusMinus ShowRootLines Description TreeNode PlusMinus Method TreeView, TreeNode. - AddRootString (TreeView ) RootNode RootNode. Format object AddRootString(string NodeText, [string NodeID,] [integer ImageIndex,] [integer SelectedImageIndex]); 125

OZ Application Designer User's Guide NodeText : RootNode NodeID : RootNode ID ImageIndex : RootNode TreeView ImageList. SelectedImageIndex : RootNode TreeView ImageList Example var objroot1 = TreeView1.AddRootString("Root1", "Node1", 1, 2); var objroot2 = TreeView1.AddRootString("Root2"); - AddNodeString (TreeNode ) Node Node. Node RootNode RootNode. Format object AddNodeString(string NodeText, [string NodeID,] [integer ImageIndex,] [integer SelectedImageIndex]); NodeText : Node NodeID : Node ID ImageIndex : Node TreeView ImageList. SelectedImageIndex : Node TreeView ImageList Example var objroot = TreeView1.AddRootString("Root", "Node1", 1, 2); var objnode = objroot.addnodestring("node"); - ExpandAll (TreeView, TreeNode ) Node. Format void ExpandAll(bool ExpandFlag); 126

ExpandFlag : Node Example TreeView1.ExpandAll(true); Example - TreeView. - Board TreeView(Name=TreeView1), TreeView 'OnInitialize'. var objroot; var objnode; objroot = TreeView1.AddRootString("A"); objnode = objroot.addnodestring("a01"); objnode.addnodestring("a01-001"); objnode.addnodestring("a01-002"); objnode = objroot.addnodestring("a02"); objnode.addnodestring("a02-001"); objnode.addnodestring("a02-002"); objroot = TreeView1.AddRootString("B"); objroot.addnodestring("b01"); objroot.addnodestring("b02"); TreeView1.ExpandAll(true); - 127

OZ Application Designer User's Guide ListView. ListView (ListViewItem), (ListViewColumnItem), (ListViewSubItem),. Property ListView. Property FullRowSelect AllowColumnReorder HeaderStyle Description Drag & Drop None : Clickable : Method ListView. - AddItem (ListView ). Format object AddItem(string ItemText, [integer ImageListIndex]); ItemText : ImageListIndex : - InsertItem (ListView ). Format object InsertItem(integer ItemIndex, string ItemText, [integer ImageListIndex]); ItemIndex : ItemText : ImageListIndex : 128

- InsertColumn (ListView ). Format object InsertColumn(integer ColumnIndex, [string ColumnText], [string ColumnAlignment], [integer ColumnWidth]); ColumnIndex : ColumnText : ColumnAlignment : ColumnWidth : - AddSubItem (ListViewItem ). Format object AddSubItem(string SubItemText); SubItemText : Example - ListView. - Board ListView(Name=ListView1), ListView 'OnInitialize'. var objcolumn; objcolumn = ListView1.InsertColumn(1, "Column1"); objcolumn = ListView1.InsertColumn(2, "Column2"); objcolumn = ListView1.InsertColumn(3, "Column3"); var objitem; objitem = ListView1.AddItem("Item1"); objitem.addsubitem("subitem1"); objitem.addsubitem("subitem2"); for(i=2;i<11;i++) { ListView1.InsertItem(i, "Item" + i); } 129

OZ Application Designer User's Guide - ProgressBar Bar. Property ProgressBar. Property BarColor Pos Maximum Minimum Step Text Description ProgressBar Bar Bar Bar Bar ProgressBar Method ProgressBar. - IsFullPos Bar Maximum. Format bool IsFullPos(); 130

Example if( ProgressBar1.IsFullPos() ) { return; } - OffsetPos Bar Bar. Format void OffsetPos(OffsetValue); OffsetValue : Example // Bar 50. ProgressBar1.OffsetPos(50); // Bar 20 Bar 70. - StepIt Bar Step. Format void StepIt(); Example // ProgressBar if(!progressbar1.isfullpos() ) { ProgressBar1.StepIt(); } Example ProgressBar Bar. - ProgressBar,, ProgressBar. 131

OZ Application Designer User's Guide - Board ProgressBar Property Value Property Value TextColor 255, 255, 255 Font Arial, 14pt, Bold TextAlign MiddleCenter Pos 0 Maximum 100 Minimum 0 Step 20 - - Board Button 'Text' '>>', Button 'OnClick'. if(!progressbar1.isfullpos() ) { ProgressBar1.StepIt(); } else { ProgressBar1.Pos = ProgressBar1.Minimum; } ProgressBar1.Text = ProgressBar1.Pos; - MonthCalendar. Property MonthCalendar. 132

Property SelectionStart SelectionEnd MaxSelectionCount ShowToday ShowTodayCircle ShowWeekNumbers TodayDate Description (Week) Example MonthCalendar. - MonthCalendar. - Board MonthCalendar Property Value Property Value ShowWeekNu mbers True - - MonthCalendar MonthCalendar 'OnPostInitialize'. var systime = _GetSystemTime(); var date = systime.getdate(); MonthCalendar1.TodayDate = date; MonthCalendar1.SelectionStart = date; MonthCalendar1.SelectionEnd = date; - 133

OZ Application Designer User's Guide DateTimePicker ComboBox MonthCalender,. Property DataTimePicker. Property Format Description Long : Window Long (32Bit Integer) Short : Window Short (16Bit Integer) Time : Window Time Custom : DataTimePicker 'CustomFormat' 'Format' 'Custom' CustomFormat h(12), H(24), m(), s(), t(,), y(), M(), d(), dddd(), 'hh, mm, ss' 0 'h, m, s' 0 134

ValueDate Method DataTimePicker. - GetCurDateTime DateTime. DateTime OZ Application Designer 'General Script' 'DateTime'. Format object GetCurDateTime(); Example var SelectedDateTime = DateTimePicker1.GetCurDateTime(); _MessageBox(SelectedDateTime.GetYear()); // _MessageBox(SelectedDateTime.GetMonth()); // _MessageBox(SelectedDateTime.GetDay()); // _MessageBox(SelectedDateTime.GetHour()); // _MessageBox(SelectedDateTime.GetMinute()); // _MessageBox(SelectedDateTime.GetSecond()); // Example DataTimePicker. - DataTimePicker. - Board DataTimePicker Property Value Property Value Format Custom CustomForma t yyyy'/'mm'/'dd hh':'mm tt dddd - 135

OZ Application Designer User's Guide HTML View. Property HTML View. Property URL URL Description Example HTML View. - HTML View. - Board HTML View Property Value Property Value URL http://www.forcs.com /index.asp - - 136

- Splitter. Example Splitter. - Splitter Docking Panel. - Board Panel Property Value Property Value BackColor 128, 128, 255 Dock Left 137

OZ Application Designer User's Guide Board Splitter Property Value Property Value BackColor 128, 128, 128 Cursor HSplit Dock Left - - Board Panel Property Value Property Value BackColor 128, 255, 128 Dock Fill - Splitter.. Horizontal Navigator Table Table Row, /// Button TextBox. Property 138

Horizontal Navigator. Property LinkComponentName Description Horizontal Navigato Table Example Horizontal Navigator Table. - Horizontal Navigator Table 10 Row. - 'Foodmart.odi' Board Table Table 'ODIKey' ''Foodmart' 'DataSet' 'ProductSales' Table. Board Table(Name=Table1). Property Value Property Value RowAutosize FixCount RowCount 10 Board Horizontal Navigator Property Value Property Value LinkCompone ntname Table1 - - - 139

OZ Application Designer User's Guide Vertical Navigator Table Table Row, /// Button / VScrollBar. Property Vertical Navigator. Property LinkComponentName Description Horizontal Navigato Table Example Vertical Navigator Table. - Vertical Navigator Table 10 Row. 140

- 'Foodmart.odi' Board Table Table 'ODIKey' ''Foodmart' 'DataSet' 'ProductSales' Table. Board Table(Name=Table1). Property Value Property Value RowAutosize FixCount RowCount 10 Board Vertical Navigator Property Value Property Value LinkCompone ntname Table1 - - - 141

OZ Application Designer User's Guide ActiveX Control OZ Application Designer. Board ActiveX, 'ActiveXControl'. Method ActiveX Control. - GetOCX ActiveX Control OCX. Format object GetOCX(); Example var objocx = ActiveXControl1.GetOCX(); Example ActiveX Control ActiveX. - ActiveX Control Microsoft Office Spreedsheet. - Board ActiveX Control ActiveX. 142

License Key : ActiveX, ClassID ActiveX. ActiveX 'Microsoft Office Spreedsheet 10.0', License Key [Ok]. 143

OZ Application Designer User's Guide 'ActiveXControl' 'Microsoft Office Spreedsheet 10.0'. Board Button, Button 'OnClick'. var activex_excel = ActiveXControl1.GetOCX(); activex_excel.cells(1,2).value = "1"; activex_excel.cells(2,2).value = "2"; activex_excel.cells(3,2).value = "3"; activex_excel.cells(4,1).value = "Sum"; activex_excel.cells(4,2).value = "=SUM(B1:B3)"; - 'Microsoft Office Spreedsheet',. 144

Custom Control OZ Application Designer., 'CustomDll' pdf417.dll Drawing Dll. Drawing Drawing Dll Custom Control. Custom Control CustomDll 'ozc_', Custom Control CustomDll 'API Developer's Guide'. Custom Control CustomDll OZ Application Designer. Custom Contro 'CustomControl'. Method Custom Control. - GetCustomProperty CustomDll. Format string GetCustomProperty(string PropertyName); - SetCustomProperty CustomDll. Format void SetCustomProperty(string PropertyName, string PropertyValue); Example Custom Control CustomDll. - TIFF. Custom Control TIFF (.tif ), Custom Control. 'ozc_tiff.dll' CustomDll, 'ozc_tiff.dll'. 145

OZ Application Designer User's Guide - Board Custom Control(Name=CustomControl1) CustomDll. ozc_tiff.dll [Ok], 'CustomControl'. Board Button, Text 'Select File'. Board CheckBox(Name=CheckBox1), 'Text' 'Fit To Size' Custom Control 146

CheckBox 'OnClick'. if(checkbox1.checked == true) { CustomControl1.SetCustomProperty("TIFF_FITTOSIZE", "true"); } else { CustomControl1.SetCustomProperty("TIFF_FITTOSIZE", "false"); } [Select File] TIFF Button 'OnClick'. var SelectedFile = _FileDialog(true, "", "", "","TIF Files (*.tif) *.tif"); if(checkbox1.checked == true) { CustomControl1.SetCustomProperty("TIFF_FITTOSIZE", "true"); } else { CustomControl1.SetCustomProperty("TIFF_FITTOSIZE", "false"); } CustomControl1.Value = SelectedFile; - [Select File] TIFF, 'Fit To Size'. 147

OZ Application Designer User's Guide Report Control Report Control OZ Report Designer (.ozr). 'ReportViewerOption' Report Control 'OnPreApplyReport' 'ApplyReport', 'OZ Report Viewer Guide'. Report Control, 'OZ Report Viewer Guide'. Property Property ReportViewerOption Description, Method Report Control. - AddReportParameter Report Control, Parameter. Format void AddReportParameter(string ParameterName, string ParameterValue); ParameterName : ParameterValue : Example // ReportControl1.AddReportParameter("toolbar.all","false"); // ProgressBar ReportControl1.AddReportParameter("print.mode","showprogress"); - InitUserParameter, AddReportParameter(). 148

Format void InitUserParameter(); Example ReportControl1.InitUserParameter(); - ApplyReport Report Control 'OnPreApplyReport'. Format bool ApplyReport(bool RecreateReportFlag); RecreateReportFlag :, Parameter User Interface RecreateReportFlag true. Example ReportControl1.ApplyReport(); Example Report Control. - Report Control. - Board Report Control 'OnPreApplyReport'. ReportControl1.InitUserParameter(); ReportControl1.AddReportParameter("connection.servlet", "http://211.116.251.49:8087/oz31demo/server"); ReportControl1.AddReportParameter("connection.reportname", "/ozdemo30/kr/a/08note.ozr"); Board Report Control Board 'OnAttached'. ReportControl1.ApplyReport(); 149

OZ Application Designer User's Guide - ReportButton ReportButton OZ Report Designer (.ozr) Export. 'ReportViewerOption' Export ReportButtonl 'OnPreApplyReport' 'ApplyReport', 'OZ Report Viewer Guide'. ReportButton, 'OZ Report Viewer Guide'. Property Property ReportViewerOption Description Export, Export 150

ReportViewerMode (Print) Export Method ReportButton. - AddReportParameter ReportButton, Parameter. 'OZ Report Viewer Guide'. Format void AddReportParameter(string ParameterName, string ParameterValue); ParameterName : ParameterValue : Example // ProgressBar ReportButton1.AddReportParameter("print.mode","showprogress"); - InitUserParameter, AddReportParameter(). Format void InitUserParameter(); Example ReportButton1.InitUserParameter(); - ApplyReport ReportButton 'OnPreApplyReport'. Format bool ApplyReport(); Example ReportButton1.ApplyReport(); 151

OZ Application Designer User's Guide Example ReportButton Export. - ReportButton Export. - Board ReportButton 'Text' 'Export' 'ReportViewerMode' 'Export'. ReportButton 'OnPreApplyReport'. ReportButton1.InitUserParameter(); ReportButton1.AddReportParameter("connection.servlet", "http://211.116.251.49:8087/oz31demo/server"); ReportButton1.AddReportParameter("connection.reportname", "/ozdemo30/kr/a/08note.ozr"); ReportButton 'OnClick'. ReportButton1.ApplyReport(); - Export Export Export. 152

Timer. Timer Timer 'OnTimer'. Property Timer. Property Description Enabled Interval Timer Timer (ms), 3 3000 Method Timer. - Start Timer. Timer 'Enabled' 'True'. Format void Start(); Example Timer1.Start(); - Stop Timer. Timer 'Enabled' 'False'. Format void Stop(); Example Timer1.Stop(); 153

OZ Application Designer User's Guide Example Timer ProgressBar. - Timer 0.5 ProgressBar. - Document Timer 'Interval' '500'. Board Button, 'Text' 'Start' 'OnClick'. var objtimer = _GetInvisible("Timer1"); objtimer.start(); Board Button, 'Text' 'Stop' 'OnClick'. var objtimer = _GetInvisible("Timer1"); objtimer.stop(); Board ProgressBar. Timer 'OnTimer'. var objprogressbar=_getcurrentboard().getchild("progressbar1"); if(!objprogressbar.isfullpos() ) { objprogressbar.stepit(); } else { objprogressbar.pos = objprogressbar.minimum; } - [Start], [Stop] Timer. 154

ContextMenu.,.. ContextMenu, 'ContextMenu' ContextMenu. ContextMenu 'OnCommand'. Example ContextMenu Board. - ContextMenu Board. - Document ContextMenu(Name=ContextMenu1). Board 'ContextMenu' 'ContextMenu1'. - Board. 155

OZ Application Designer User's Guide MainMenu Board.,.. MainMenu Board 'MainMenu' MainMenu. MainMenu 'OnCommand'. Example MainMenu Board. - MainMenu Board. - Document MainMenu(Name=MainMenu1). 156

Board 'MainMenu' 'MainMenu1'. - Tooltip,. 'ToolTip' Tooltip, 'ToolTipText'. 157

OZ Application Designer User's Guide Example Tooltip Button. - Tooltip Button. - Document Tooltip(Name=ToolTip1). Board Button 'ToolTip' 'ToolTip1' 'ToolTipText' '_MessageBox("Hello","Title");'. - ImageList ContextMenu, MainMenu, TreeView, CheckBox. 'ImageSize'. ImageList 'ImageList' ImageList, 'MenuIconImageIndex' 'MenuIconDisableImageIndex'. Property ImageList. 158

Property Description ImageSize ImageListUrl Example ImageList MainMenu. - ImageList MainMenu. - Document ImageList(Name=ImageList1) 'ImageSize' '20, 20', 'ImageListUrl' 'ozp:///complexcontrols.gif'. Document MainMenu(Name=MainMenu2). MainMenu2 'ImageList' 'ImageList1'. Invisibles MainMenu2 Table 'MenuIconImageIndex' '0'. 159

OZ Application Designer User's Guide Grid 'MenuIconImageIndex' '1', CrossTab 'MenuIconImageIndex' '2', Chart 'MenuIconImageIndex' '3'. Board 'MainMenu' 'MainMenu2'. - 160

Panel, GroupBox. Board Panel Panel Panel. GroupBox Panel, Panel. Method Panel. - DeleteAllChild Panel. Format void DeleteAllChild(); Example Panel1.DeleteAllChild(); - GetChild. Format object GetChild(string ComponentName); Example var objlabel = Panel1.GetChild("Label1"); - GetChildAt. Format object GetChildAt(integer ComponentIndex); Example var objcomp = Panel1.GetChildAt(5); 161

OZ Application Designer User's Guide - GetChildCount Panel. Format integer GetChildCount(); Example var ChildCount = Panel1.GetChildCount(); Example - Panel Label, CheckBox, RadioButton, Button Panel (Name) (Text).. - Board Panel, Panel Label, CheckBox, RadioButton. Board Button, 'Text' 'Get ChildComponent' 'OnClick'. var objcomp; var ChildCount = Panel1.GetChildCount(); for(i=0;i<childcount;i++) { objcomp = Panel1.GetChildAt(i); _MessageBox("Name: "+ objcomp.name + " Text: " + objcomp.text); } - 162

TabControl Panel, Panel. Board TabControl TabPanel TabControl TabPanel,. Property TabControl. Property SelectedIndex Description Tab, 0 Example - 4 TabPanel TabControl Tab. - Board TabControl(Name=TabControl1), TabControl TabPanel 4. Board 'OnPostInitialize'. TabControl1.SelectedIndex = 1; - 163

OZ Application Designer User's Guide BoardView Board. BoardView Board, BoardView Board BoardView. Property BoardView. Property Description BoardName Board Example - TextBox Board Button BoardView Board. - Board Board TextBox(Name=TextBox1), Button(Name=Button1), BoardView(Name=BoardView1). Button 'OnClick'. BoardView1.BoardName = TextBox1.Text; - 164

Table. Table.,.. Grid. Grid.. CrossTab. CrossTab.. Chart 2 3. Chart.. 165

OZ Application Designer User's Guide Line,. Property Line. Property LineDash LineGap LineType PenThickness Description 0. Horizontal : Vertical : Slash : BackSlash : Example - Line. - Board Line. Property Value Property Value LineDash 10 LineGap 5 LineType Horizontal PenThickness 2 166

- ArrowLine. Property ArrowLine. Property ArrowShape ArrowSize ArrowType Description Circle : Diamond : OpenTriangle : SemiCircle : SharpTriangle : Triangle : Normal : Reverse : Both : Example - ArrowLine. 167

OZ Application Designer User's Guide - Board ArrowLine. Property Value Property Value ArrowShape Triangle ArrowSize 10 ArrowType Normal - - - Ellipse,. Property Ellipse. Property BrushStyle Description Solid : Hatch : 168

PatternStyle PenThickness, BrushStyle Hatch Horizontal : Vertical : FDiagonal : BDiagonal : Cross : Horizontal Vertical Diacross : FDiagonal BDiagonal Example - Ellipse. - Board Ellipse. Property Value Property Value BrushStyle Hatch PatternStyle Diacross - 169

OZ Application Designer User's Guide Rectangle. Property Rectangle. Property BrushStyle PatternStyle PenThickness Description Solid : Hatch :, BrushStyle Hatch Horizontal : Vertical : FDiagonal : BDiagonal : Cross : Horizontal Vertical Diacross : FDiagonal BDiagonal Example - Rectangle. - Board Rectangle. Property Value Property Value BrushStyle Hatch PatternStyle Horizontal - 170

171

OZ Application Designer User's Guide OZC OZ Application Designer OZ Component. Label, TextBox OZ Application Designer OZC Container Controls Board OZC. OZC [Export Component], [Import Component]. Container Controls Board OZC. Container Controls Container Controls GroupBox GroupBox OZC. OZC 172

Step 1 OZC OZC OZC. Board GroupBox, RadioButton. GroupBox RadioButton 'Name' 'gbcolor', 'rbred', 'rbgreen', 'rbblue', 'rbblack', GroupBox 'Text' 'Select Color', RadioButton 4 'Text' 'Red', 'Green', 'Blue', 'Black'. OZC Board OZC, '' + ''. OZC, 'Name'. RadioButton, RadioButton1, RadioButton2,... rbred, rbgreen,.... GroupBox [Export Component]. 173

OZ Application Designer User's Guide ' ' 'OZC_GroupBox.ozc'. 'C:\Repository'. Step 2 OZC OZC., OZC Board Label, Button. Board [Import Component]. 174

[Import Component],. Menu None Auto Include Manual Include Description OZC. OZC. "SaveType" OZC OZC. 'Auto Include' OZC OZC. 'Auto Include' OZC, 'Manual Include' OZC OZC ImportNewChild() OZC. [Manual Include] OZC. [Import Component] [Manual Include] OZC Board. OZC, 'Manage Type' 175

OZ Application Designer User's Guide. 'Manage Type'. Property Type SaveType Category Item Description OZC. OZC. OZC. OZC. Step 3 'Manual Include' OZC Board Board Label. 'Manual Include' OZC Board. 'Board1' 'OnPostInitialize'. Board1.ImportNewChild("ozp:///OZC_GroupBox.ozc"); Label 176

. 'Document' GlobalFunction'. function changebackcolor(color) { var mylabel = _GetBoard("Board1").GetChild("Label1"); switch(color) { case "Red": mylabel.backcolor = "255, 0, 0"; break; case "Green": mylabel.backcolor = "0, 255, 0"; break; case "Blue": mylabel.backcolor = "0, 0, 255"; break; case "Black": mylabel.backcolor = "0, 0, 0"; break; default: break; } } [Change the Backcolor of the Label] Label. 'Button1' 'OnClick'. if(gbcolor.getcheckedradio()!= null) { var selectedcolor = gbcolor.getcheckedradio().text; changebackcolor(selectedcolor); } else { _MessageBox("Select Color", "Error"); } Step 4 [File] [Preview] (. ) [Change the Backcolor of the Label] Label. 177

OZ Application Designer User's Guide Board Board OZC. OZC 178

Step 1 OZC OZC Board OZC. Board Button, GroupBox, RadioButton. Button, GroupBox RadioButton 'Name', 'Text'. Label. 'btnchangebackcolor' 'OnClick'. if(gbcolor.getcheckedradio()!= null) { var selectedcolor = gbcolor.getcheckedradio().text; changebackcolor(selectedcolor); } else { _MessageBox("Select Color", "Error"); } Board [Export Component]. 179

OZ Application Designer User's Guide ' ' 'OZC_Board.ozc'. 'C:\Repository'. Step 2 Board Board, Board OZC Label., Board. [Show Color Dialog] Board OZC. 'Button1' 'OnClick'. 180

var objboard = _ImportNewBoard("ozp:///OZC_Board.ozc"); Board1.ShowDialog(objBoard.Name, "Change BackColor", true, 300, 0); Label. 'Document' GlobalFunction'. function changebackcolor(color) { var mylabel = _GetBoard("Board1").GetChild("Label1"); switch(color) { case "Red": mylabel.backcolor = "255, 0, 0"; break; case "Green": mylabel.backcolor = "0, 255, 0"; break; case "Blue": mylabel.backcolor = "0, 0, 255"; break; case "Black": mylabel.backcolor = "0, 0, 0"; break; default: break; } } Step 3 [File] [Preview] (. ) [Show Color Dialog] ' ' [Change the Backcolor of the Label] Label. 181

OZ Application Designer User's Guide EventHook Document, PreEventHook PostEventHook. EventHook 'EnableEventHook' 'True',., 'EnableEventHook' 'True' Button1 'OnClick'. PreEventHook 'OnClick' Button1 'OnClick' PostEventHook 'OnClick' EventHook 'EnableEventHook' (:True) 'False'. PreEventHook PostEventHook PreEventHook PostEventHook. PreEventHook 182

(OnClick ) Example EventHook Board Button Label 'EnableEventHook' PreEventHook PostEventHook. PreEventHook PostEventHook 'OnClick'. Board Button, Label 'EnableEventHook', Button Label 'OnClick' 'EnableEventHook' EventHook. - PreEventHook 'OnClick'. _MessageBox("PreEventHook_OnClick"); - PostEventHook OnClick. _MessageBox("PostEventHook_OnClick"); - Board Button(Name=Button1), 'EnableEventHook' 'True' Button 'OnClick'. _MessageBox("Button1_OnClick"); 183

OZ Application Designer User's Guide - Board Button(Name=Button2), 'EnableEventHook' 'False' Button 'OnClick'. _MessageBox("Button2_OnClick"); - Board Label(Name=Label1), 'EnableEventHook' 'True' Label 'OnClick'. _MessageBox("Label1_OnClick"); - Board Label(Name=Label2), 'EnableEventHook' 'False' Label 'OnClick'. _MessageBox("Label2_OnClick"); - [File] [Preview] ( ). - 'EnableEventHook' 'True' [Button1] PreEventHook OnClick -> Button1 OnClick -> PostEventHook OnClick. 184

- 'EnableEventHook' 'False' [Button2] PreEventHook PostEventHook Button2 OnClick. - 'EnableEventHook' 'True' [Label1] [Button1] PreEventHook OnClick -> Label1 OnClick -> PostEventHook OnClick. - 'EnableEventHook' 'False' [Label2] [Button2] PreEventHook PostEventHook Label2 OnClick 185

OZ Application Designer User's Guide. 186

187

OZ Application Designer User's Guide,,,. Controls Controls ODIKey, DataSet, Field DataSource. ODIKey, DataSet, Field. CheckBox RadioButton ComboBox ListBox CheckListBox TextBox NumericUpDown MaskTextBox RichTextBox Label PictureBox ProgressBar HTML View ActiveX Control Custom Control DateTimePicker Description,, DropDown Bar ActiveX Custom 188

MonthCalendar Complex Controls Complex Controls Table, Chart, CrossTab. Table CrossTab Chart Description 2 3 ODIKey, DataSet,. 189

OZ Application Designer User's Guide ODI. ODI OZ Application Designer Database Foodmart.mdb ODBC. OZ Query Designer ODI. OZ Query Designer 'OZ Query Designer User's Guide'. Step 1 ODBC OZ Application Designer Database Foodmart.mdb ODBC. [] [ ] [ (ODBC)] ODBC. [System DSN] [Add] ' ' 'Microsoft Access Driver(*.mdb)' [Finish]. 190

'Foodmart'. [Select] Database 'Foodmart.mdb' [OK], Database. 191

OZ Application Designer User's Guide [OK] ODBC. Step 2 ODI OZ Query Designer ODI. Database ODI. Database 'Foodmart'. OZ Query Designer 'OZ Data Tree' 'DATABASE' [Add Database Info]. Database [OK]. 192

. 'OZ Data Tree' 'Foodmart' [Add Query Dataset]. ' ' 'ProductSales' [OK]. [Query] [Change Design Mode] [Manual Mode],. 193

OZ Application Designer User's Guide 'OZ Data Tree' 'ProductSales'.. select product.brand_name, store.store_name, sales_fact.store_sales, sales_fact.store_cost from sales_fact, product, store where sales_fact.product_id = product.product_id and sales_fact.store_id = store.store_id ( ).. [File] [Save] ( ) 'Foodmart.odi'. 'C:\Repository'. 194

Step 3 ODI ODI. [File] [Insert New ODI] ODI [OK]. ODI. 195

OZ Application Designer User's Guide Table. ComboBox, Table.. - Table. 196

ODI Database ODBC 'Foodmart', 'MemberGrade', 'Customer'. 'Customer' 'Master Dataset' 'MemberGrade' -. 197

OZ Application Designer User's Guide Step 1 ODI ODI. ODI 'ODI, '. OZ Query Designer 'OZ Data Tree' 'DATABASE' [Add Database Info]. Database 'Foodmart'. 'Foodmart' [Add Query Dataset], 'MemberGrade'. ( ). select distinct member_card from customer 'Foodmart' [Add Query Dataset], 'Customer'., ( ). 198

select customer.customer_id, customer.fname, customer.lname, customer.gender, customer.phone1, customer.phone2, customer.birthdate, customer.occupation, customer.city, customer.country from customer where customer.member_card = '#MemberGrade.member_card#' 'Customer' 'Master Dataset' 'MemberGrade' -. ODI ODI, 'Table.odi'. 'C:\Repository'. Step 2 ODI OZ Application Designer ODI. OZ Application Designer [File] [Create New Project] ( ). [File] [Insert New ODI] ODI 'Table.odi'. ODI 199

OZ Application Designer User's Guide. Step 3,, Board Label, ComboBox, Table,. Label, Label. Property Value Property Value BackColor 212, 208, 200 TextColor 0, 0, 160 LineColor 212, 208, 200 Font Arial, 14pt, Bold Text > Customer Grade : Location 16, 18 Size 136, 16 - - ComboBox,, ComboBox, ComboBox. Property Value Property Value Font Arial, 12pt DropDownSty le DropDownList Location 160,16 Size 168, 24 ODIKey Table DataSet MemberGrade Field member_card FireRowCurs orchange True 200

Table,, Table, Table. Property Value Property Value IndicatorStar tindex 1 Location 16, 48 Size 776, 536 ODIKey Table DataSet Customer - - Table [Wizard]. 'SortType' 'Numeric' 'Text' [Ok] Table CellHeader, CellIndicator. Property Value Property Value BackColor 128, 128, 255 TextColor 255, 255, 255 Font Arial, 12pt, Bold TextAlign MiddleRight CellFrameCol or 192, 192, 192 Size 40, 24 201

OZ Application Designer User's Guide Table CellTitle1,..., CellTitle10. Property Value Property Value BackColor 128, 128, 255 TextColor 255, 255, 255 Font Arial, 12pt, Bold TextAlign MiddleCenter CellFrameCol or 192, 192, 192 - - Table CellTitle1,..., CellTitle10 'Text' 'Customer ID, First Name, Last Name, Gender, Phone1, Phone2, Birthdate, Occupation, City, Country'. Table CellLabel1,..., CellLabel10. Property Value Property Value Font Arial, 12pt InternalMargi n 4, 4, 4, 4 Table CellLabel4 'TextAlign' 'MiddleCenter', CellLabel7 'TextAlign' 'MiddleCenter' 'Pattern' 'date_mm-dd-yyyy', CellLabel 'TextAlign' 'MiddleLeft'. Step 4 [File] [Preview] (. ) ComboBox. 202

203

OZ Application Designer User's Guide Grid. ComboBox, Grid. 204

ODI Database ODBC 'Foodmart', 'ProductDepartment', 'Product'. 'ProductDept'. 205

OZ Application Designer User's Guide Step 1 ODI ODI. OZ Query Designer Database 'Foodmart'. [Add Query Dataset]. 'ProductDepartment', ( ). select distinct product_department from product_class. 'OZ Data Window' 'USER PARAMETER' [Add Parameter Field]. ' ' 'ProductDept' 'VARCHAR'. [OK], 'OZ Data Window' 206

. [Add Query Dataset]. 'Product', ( ). select product.product_id, product.brand_name, product.product_name, product.gross_weight, product.net_weight, product.low_fat, product.units_per_case, product.cases_per_pallet from product, product_class where product.product_class_id = product_class.product_class_id and product_class.product_department ='#OZParam.ProductDept#' order by brand_name, product_name, product_id ODI ODI, 'Grid.odi'. 'C:\Repository'. Step 2 ODI OZ Application Designer ODI. 207

OZ Application Designer User's Guide OZ Application Designer [File] [Create New Project] ( ). [File] [Insert New ODI] ODI 'Grid.odi'. ODI. Step 3,, Board Label, ComboBox, Grid,. Label, Label, (Font), (TextColor), (Location), (Size), (Text). ComboBox,, ComboBox, (TextColor), (Location), (Size). Property Value Property Value DropDownSty le DropDownList ODIKey Grid DataSet ProductDepartment Field product_departmen t 208

Grid, Grid, (Location), (Size). Property Value Property Value IndicatorStar tindex 1 FixedColCoun t 3 Grid CellHeader, CellIndicator, CellTitle, (BackColor), (CellFrameColor), (Font), (TextColor), (Size). Grid CellHeader, CellIndicator, (TextAlign = MiddleRight), CellTitle (TextAlign=MiddleCenter). Grid CellLabel, (Font) (InternalMargin = '4,4,4,4'). Step 4 ComboBox Grid. Grid Grid Title, Label. 'Document' 'GlobalFunction'. function displayproduct(productdeptvalue) { //ODI, DataSet var DataManager = _GetDataManager(); var DataModule = DataManager.GetDataModule("Grid"); DataModule.UpdateOZParam("ProductDept", ProductDeptValue); var DataSet = DataModule.GetDataSet("Product", null, true); var DataCount = DataSet.GetRowCount(); var grdproduct = _GetBoard("Board1").GetChild("Grid1"); //Reset Grid if(grdproduct.getrowcount() > 0) { 209

OZ Application Designer User's Guide grdproduct.selectcellrange(-1, -1, -1, -1); grdproduct.deletecellinrange(); } grdproduct.addcolumn(8); grdproduct.addrow(datacount); grdproduct.selectcellrange(0, 5, DataCount, 5); if(datacount < 1) { return; } grdproduct.changecelltypeinrange( CellComponentTypeConst.CheckBox); //Display Data for(i=0; i<datacount; i++) { grdproduct.getcell(i,0).text = DataSet.GetStringData(i, "product_id"); grdproduct.getcell(i,1).text = DataSet.GetStringData(i, "brand_name"); grdproduct.getcell(i,2).text = DataSet.GetStringData(i, "product_name"); grdproduct.getcell(i,3).text = DataSet.GetStringData(i, "gross_weight"); grdproduct.getcell(i,4).text = DataSet.GetStringData(i, "net_weight"); grdproduct.getcell(i,5).checked = DataSet.GetStringData(i, "low_fat"); grdproduct.getcell(i,6).text = DataSet.GetStringData(i, "units_per_case"); grdproduct.getcell(i,7).text = DataSet.GetStringData(i, "cases_per_pallet"); } } function formatgrid(gridrowcount) { var grdproduct = _GetBoard("Board1").GetChild("Grid1"); //Grid Title grdproduct.gettitle(0).text = "Product ID"; grdproduct.gettitle(1).text = "Brand Name"; grdproduct.gettitle(2).text = "Product Name"; grdproduct.gettitle(3).text = "Gross Weight"; grdproduct.gettitle(4).text = "Net Weight"; grdproduct.gettitle(5).text = "Low Fat"; grdproduct.gettitle(6).text = "Units Per Case"; grdproduct.gettitle(7).text = "Cases Per Pallet"; grdproduct.gettitle(0).setsize(80,24); grdproduct.gettitle(1).setsize(80,24); grdproduct.gettitle(2).setsize(160,24); 210

grdproduct.gettitle(3).setsize(80,24); grdproduct.gettitle(4).setsize(80,24); grdproduct.gettitle(5).setsize(60,24); grdproduct.gettitle(6).setsize(100,24); grdproduct.gettitle(7).setsize(100,24); //Grid Label for(i=0; i<gridrowcount; i++) { grdproduct.getcell(i,0).textalign = AlignmentConst.MiddleLeft; grdproduct.getcell(i,1).textalign = AlignmentConst.MiddleLeft; grdproduct.getcell(i,2).textalign = AlignmentConst.MiddleLeft; grdproduct.getcell(i,3).textalign = AlignmentConst.BottomRight; grdproduct.getcell(i,4).textalign = AlignmentConst.BottomRight; grdproduct.getcell(i,5).checkalign = AlignmentConst.BottomCenter; grdproduct.getcell(i,6).textalign = AlignmentConst.BottomRight; grdproduct.getcell(i,7).textalign = AlignmentConst.BottomRight; } //Refresh ScrollBars grdproduct.refreshscrollbars(); } ComboBox Grid Grid. ComboBox 'OnSelectedIndexChanged'. displayproduct(combobox1.value); formatgrid(grid1.getrowcount()); Step 5 [File] [Preview] (. ) ComboBox. 211

OZ Application Designer User's Guide 212

,,. Table.,. [InsertNewRow] Table. [Apply],,. [RefreshDataSet] DataBase Table Refresh. 213

OZ Application Designer User's Guide ODI Database ODBC 'Foodmart', 'Customer2'.,, 'Customer2',,. Step 1 ODI,, ODI.,, 'OZ Query Designer User's Guide'. OZ Query Designer Database 'Foodmart'. [Add Query Dataset]. 214

'Customer2', ( ). select customer_id, fname, lname, member_card, gender, phone1, city, country from customer2,, 'Customer2',,. 'OZ Data Tree' 'Customer2' [Insert Query]. [OK]. INSERT INTO customer2 (#@ARG_SF1#,#@ARG_SF2#,#@ARG_SF3#,#@ARG_SF4#,#@ARG_SF5#,#@ARG_SF6#, #@ARG_SF7#,#@ARG_SF8#) VALUES ('#@ARG_SV1#','#@ARG_SV2#','#@ARG_SV3#','#@ARG_SV4#','#@ARG_SV5#',' #@ARG_SV6#','#@ARG_SV7#','#@ARG_SV8#') 'OZ Data Tree' 'Employee' [Delete Query]. [OK]. DELETE FROM customer2 WHERE #@ARG_DF1# = '#@ARG_DV1#' AND #@ARG_DF2# = '#@ARG_DV2#' AND #@ARG_DF3# = '#@ARG_DV3#' 'OZ Data Tree' 'Employee' [Update Query]. [OK]. UPDATE customer2 SET #@ARG_SF1# = '#@ARG_SV1#', #@ARG_SF2# = '#@ARG_SV2#', #@ARG_SF3# = '#@ARG_SV3#', 215

OZ Application Designer User's Guide #@ARG_SF4# = '#@ARG_SV4#', #@ARG_SF5# = '#@ARG_SV5#', #@ARG_SF6# = '#@ARG_SV6#', #@ARG_SF7# = '#@ARG_SV7#', #@ARG_SF8# = '#@ARG_SV8#' WHERE #@ARG_DF1# = '#@ARG_DV1#' AND #@ARG_DF2# = '#@ARG_DV2#' AND #@ARG_DF3# = '#@ARG_DV3#' ODI ODI, 'DataAction.odi'. 'C:\Repository'. Step 2 ODI OZ Application Designer ODI. OZ Application Designer [File] [Create New Project] ( ). [File] [Insert New ODI] ODI 'DataAction.odi'. ODI. Step 3,, Board Button, Table,. 216

Button, Button 3, (Font), (Location), (Size), (Text). Table,, Table, (Location), (Size) Table. Property Value Property Value IndicatorStar tindex 1 ODIKey DataAction DataSet Customer2 CellSelection Mode Single Table [Wizard]. 'ColumnEditable' 'True' [Ok] Table CellHeader, CellIndicator, CellTitle, CellLabel (BackColor), (CellFrameColor), (Font), (TextColor), (Size), (Text), (TextAlign) 217

OZ Application Designer User's Guide. Step 4,,. [InsertNewRow] 'OnClick' Table. Table1.InsertNewRow(0); [Apply] 'OnClick',,, '' DataAction. //Table Insert, Delete, Update Action var DataActions = new Array(); var InsertCount = Table1.MakeInsertRowAction(DataActions); var DeleteCount= Table1.MakeDeleteRowAction(DataActions); var UpdateCount = Table1.MakeUpdateRowAction(DataActions); // DataAction var CountSum = InsertCount + DeleteCount + UpdateCount; //DataAction Return if(countsum < 1) { return; } //DataAction DataAction var UserCommand = _ChoiceButtonBox("Insert : " + InsertCount + ", " + "Delete : " + DeleteCount + ", " + "Update: " + UpdateCount + "." + "\n" + "?", "Question", MessageBoxOptionsConst.YesNo, MessageBoxOptionsConst.IconQuestion); // Return if(usercommand!= DialogResultConst.Yes) { return; } //Commit Queue Action var DataModule = Table1.GetDataModule(); DataModule.CleanUpQueuedActions(); DataModule.QueueActionObjects(DataActions); var DataActionResult = DataModule.CommitQueuedActions(); if(dataactionresult.length > 0){ _MessageBox(DataActionResult, "Error"); } else { DataModule.RefreshAllDataSet(); _MessageBox("Success"); } 218

[RefreshDataSet] 'OnClick' Table Refresh var DataModule = Table1.GetDataModule(); DataModule.RefreshAllDataSet(); Step 5 [File] [Preview] (. ). 219

OZ Application Designer User's Guide. DataBase. 'OZ Script Guide'. ODI. 'Grid.odi'. -, 'Grid.odi'. - ' ' 'Grid.odi' 'Product' [Insert New CalculatedField]. - [Insert New CalculatedField] ' '. 220

'' '' ''.. 221

OZ Application Designer User's Guide Database,. 'Grid.odi' 'Product' 'ProductDepartment' [Database], 'Product'. 222

[Product] [#Product.product_id#]. Parameter ODI Parameter. 'Grid.odi' Parameter 'ProductDept'. 223

OZ Application Designer User's Guide Functions (Mathematics), (Sting Opr.), (Database I/O), (Date Opr.), (Miscellaneous). 'OZ Script Guide'.,. 'substr'. 224

- [Ok].. -. - [Edit CalculatedField] ' ' [Ok]. 225

OZ Application Designer User's Guide Example. Step 1 'Foodmart.odi'. ' ' 'Foodmart.odi' 'ProductSales' [Insert New CalculatedField]. [Ok]. 'store_cost' '3.0' 'Bad', '3.0' 'Good'. 226

' ' 'Foodmart.odi' 'ProductSales'. Step 2 Table. Board Table 'ODIKey' 'Foodmart' 'DataSet' 'ProductSales' Table [Ok]. CellTitle, CellLabel,. 'Remark' 'store_cost' 'Good' 'Bad'. 227

OZ Application Designer User's Guide 228

229

OZ Application Designer User's Guide OZ Application Designer. Chart Chart. Chart Board Chart, Chart ODI. Chart Chart.. 'Foodmart.odi' Chart, Chart 'ODIKey' 'Foodmart' 'DataSet' 'ProductSales'. Chart [Wizard] Chart. Data Chart X, Y. ' ' Chart DataSet. X, Y, Y, ' ' 230

Drag & Drop. ' ' Drag & Drop [Delete]. Type Chart. OZ Application Designer,,,,,,, 231

OZ Application Designer User's Guide,,,, Chart, Chart Chart. Title Chart. Chart,, X, Y [Format]. [Format] 'Format Dialog'. Chart Title Chart. X-Axis Title X 'End of Axis', X 'Next of Axis'. Y-Axis Title Y 'End of Axis' Y, Y. Y 'Next of Axis' Y, 232

Y. Bottom Title Chart. X Axis X,,,. Show Axis X,. Major Gridlines X, [Style],. [Style] 'Gridline Style Dialog'. Minor Gridlines X, [Style],. [Style] 'Gridline Style Dialog'. 233

OZ Application Designer User's Guide Show Label X, X, [Format]. [Format] 'Format Dialog'. Label Interval X. '1', '2',,,.... Gap Between Bars. - Gap Between Bars In X Axis : X. - Gap Between Collected Bars :. Advanced X.. Option Description. None 234

. Outside. Inside. Cross Y Axis Y, Y,,,,,. Show Axis Y,. 235

OZ Application Designer User's Guide Major Gridlines Y, [Style],. [Style] 'Gridline Style Dialog'. Minor Gridlines Y, [Style],. [Style] 'Gridline Style Dialog'. Show Label(Left) Y, Y, [Format]. [Format] 'Format Dialog'. Show Label(Right) Y, Y, [Format]. [Format] 'Format Dialog'. Label Interval Y. '1', '2',,,.... Advanced Y Y, Y,,,,,,. 236

Option Description Major/Minor Gridlines None Outside Inside Cross... Unit of Ticks # of Ticks Origin Style Y, Y. Y, Y.. X Y. Y (MIN) (MAX). [Style],. [Style] 'Gridline Style Dialog' 237

OZ Application Designer User's Guide Min Round Off Max Round Up Y.... Y.... /, / /. Y 1276 2 1200-1276 2-1300 12.76-2 12.7-12.76-2 -12.8 Y 1216 2 1300-1216 2-1200 12.16-2 12.2-12.16-2 -12.1 Z Axis Z,,,. 238

Show Axis Z,. Major Gridlines Z, [Style],. [Style] 'Gridline Style Dialog'. Minor Gridlines Z, [Style],. [Style] 'Gridline Style Dialog'. Show Label Z, Z, [Format]. [Format] 'Format Dialog'. Label Interval Z. '1', '2',,,.... 239

OZ Application Designer User's Guide Advanced Z. X. Legend Chart,,,,. Show. [By Series], [Format]. [Format] 'Format Dialog'. [By Series]. 240

'Visible' 'Invisible' Drag & Drop. 'Visible',., 10, 'Invisible',,, 'Visible',,. 'Visible'.. 'Visible', 'Invisible'. Chart '', ''. 241

OZ Application Designer User's Guide Chart X 'Month' Y 'Sales' 'Department' 'Origin' 'Origin' [By Series]., Chart. 242

Title,. [Format], [Format] 'Format Dialog'. Frame, [Style]. [Style] 'Rectangle Style Dialog'.. Option Color Fill Thickness Round Description.. 'None'... 243

OZ Application Designer User's Guide Reverse.,. Position Chart (Top), (Bottom), (Left), (Rignt). Display Chart,,. BackGround Chart. - Fill :.. - Margin : Chart Chart,,,. [Margin] 'Margin Dialog'. 244

,,,. Fill Type. - No Fill :.. - Gradient :. 3D Thickness 3D Chart. 3D Rotational Axis Thickness Chart. Data Label. 245

OZ Application Designer User's Guide Data Label,,,. 'Show'. [By Series], 'Position'. [Format], [Format] 'Format Dialog'. [By Series]. 'Visible' 'Invisible' Drag & Drop. 'Visible',., 10, 246

'Invisible',,, 'Visible',,. 'Visible'. Tooltip. 'Show', 'Boundary Radius'.,. Color. 247

OZ Application Designer User's Guide Drag & Drop. [User Defined]. Misc,,,. 248

Pie Type Chart Chart,, 'Vertical Interval' 'Horizontal Interval'. User Defined Chart Option Chart 2, 'Clustered Bar' 2 'Stacked Bar'. Internal Interval Chart,. Spot Size. Line Thickness. Bar Max Thickness. Apply Pattern,,. 'Apply Pattern',, Chart,, 'Mark Pattern', 'Line Pattern', 'Fill Pattern' 3. 249

OZ Application Designer User's Guide - Mark Pattern Chart. Drag & Drop. - Line Pattern. 250

Drag & Drop. [User Defined], [User Defined]. 'Dash Line' 'Gap Size' [OK]. 'Gap Size' '0', 'Gap Size' '0'. - Fill Pattern 251

OZ Application Designer User's Guide Drag & Drop. Smoth Line Chart. Gauge Chart,,,. 252

Start Angle. Length Angle Chart. Axis Thick Y. Bar Thick Chart. Legend Label Pos X. DataLabel Position. Arrange Chart Chart. Axis Label Y. Bar Pos. Reverse Chart. 'Reverse'. 253

OZ Application Designer User's Guide Pie Chart,,,. Start Angle. Length Angle Chart. Axis Thick.. Legend Label. Arrange Chart Chart. Axis Label Z Z. 254

Reverse Chart. 'Reverse'. Format Dialog,,. Format,,,,,. Paragraph,,,. 255

OZ Application Designer User's Guide Font,,,,. Line Color. Gridline Style Dialog. 256

Color. Use Dashes. 'Use Dashes', 'Dash Length', 'Gap Length', 'Dash Length' 'Gap Length'. Thickness. 257

OZ Application Designer User's Guide CheckListBox CheckListBox. CheckListBox Board CheckListBox, CheckListBox [Wizard] CheckListBox. CheckListBox CheckListBox 'Member' ''. Member CheckListBox,. Property, CheckListBoxItem. 258

Property Type Text Selected Checked CheckState ItemValue Enabled Description. CheckListBox CheckListBoxItem. CheckListBoxItem. CheckListBoxItem. 'True' CheckListBoxItem. CheckListBox. CheckListBoxItem. CheckListBoxItem. CheckListBoxItem. CheckListBoxItem. 'False'. 259

OZ Application Designer User's Guide ComboBox ComboBox. ComboBox Board ComboBox, ComboBox [Wizard] ComboBox. ComboBox ComboBox 'Member' ''. Member ComboBox,. Property, ComboBoxItem. 260

Property Type Text ItemValue ImageIndex SelectedImageInd ex ItemIndent Description. ComboBox ComboBoxItem. ComboBoxItem. ComboBoxItem.. ComboBox ImageList.. ComboBox ImageList. ComboBoxItem. 1 10. 261

OZ Application Designer User's Guide ContextMenu MainMenu ContextMenu. ContextMenu ContextMenu. ContextMenu Document ContextMenu, 'Invisibles ' ContextMenu [Wizard] ContextMenu. ContextMenu ContextMenu 'Member' ''. Member ContextMenu,. [Tab]. 262

Property, MenuItem. Property Type Name Text Enabled Visible Checked MenuIconImage MenuIconDisableImage MenuIconImageIndex MenuIconDisableImageIndex Description. ContextMenu MenuItem. MenuItem. MenuItem. MenuItem. 'False'. MenuItem. MenuItem. MenuItem MenuItem. MenuItem MenuItem. MenuItem MenuItem ImageList. ContextMenu ImageList, 'MenuIconImage'. MenuItem MenuItem ImageList. ContextMenu ImageList, 'MenuIconImage'. 263

OZ Application Designer User's Guide IsSeparator Style Shortcut EnableEventHook MenuItem. 'True'. MenuItem OZ Style. MenuItem. EventHook. 264

CrossTab CrossTab. CrossTab Board CrossTab, CrossTab ODI.. 'Foodmart.odi' CrossTab CrossTab 'ODIKey' 'Foodmart' 'DataSet' 'ProductSales'. CrossTab [Wizard] CrossTab. CrossTab CrossTab DataSet ' ', ' ', ' ', ' '.,, Drag & Drop, 265

OZ Application Designer User's Guide Drag & Drop [Delete]. ' ' ' ' CrossTab,, 'Dimension Option'.. Option Expansion Level Fixed Level Drill Show [+/-] Show Pivot Show Sum Description CrossTab. Expansion Level. 3 Expansion Level 3, 2 CrossTab 2... Fixed Level. 3 Fixed Level 3, 2 CrossTab 2... (+) (-)... 266

( ) 'Value '.. Option Show Title Value Pivot SortState SortType Description 'Value ',., 'Add Previous', 'Add Next'. Pivot. None(), Ascending(), Descending(), "None". Pivot. None(), Text(), Numeric(). "None". 267

OZ Application Designer User's Guide ListBox ListBox. ListBox Board ListBox, ListBox [Wizard] ListBox. ListBox ListBox 'Member' ''. Member ListBox,. Property, ListBoxItem. 268

Property Type Text Selected ItemValue Description. ListBox ListBoxItem. ListBoxItem. ListBoxItem. 'True' ListBoxItem. ListBox. ListBoxItem. 269

OZ Application Designer User's Guide ListView,, ListView. ListView Board ListView, ListView [Wizard] ListView. ListView ListView 'Member' ''. [Add] ListView, [Columns] ListView. [Remove]. [SubItems]. Member ListView. 270

Property. Property Type Text Selected Checked ItemValue ImageIndex ItemIndent Description. ListView ListViewItem... 'True'. ListView 'HideSelection' 'False'.. ListView, ListView 'CheckBoxes' 'True'... ListView ImageList.. 1 10. [Columns] ListView. 271

OZ Application Designer User's Guide Member ListView. Property. Property Type Text TextHAlign ColumnWidth Description. ListViewColumnItem.... [SubItems] ListView. Member ListView.. Property. 272

Property Type Text ItemValue Description. ListViewSubItem... 273

OZ Application Designer User's Guide RichTextBox RichTextBox. RichTextBox Board RichTextBox, RichTextBox [Wizard] RichTextBox. RichTextBox '' ''.,,,,,. Icon Description,.,,,. 274

,,..,.,. 275

OZ Application Designer User's Guide TabControl TabPanel TabControl. TabControl Board TabControl, TabControl [Wizard] TabControl. TabControl TabPanel 'Member' TabPanel ''. TabControl 4. Button Add Remove TabPanel. Description TabPanel. TabPanel. TabPanel. 276

Table Table. Table Board Table, Table ODI.. 'Foodmart.odi' Table Table 'ODIKey' 'Foodmart' 'DataSet' 'ProductSales'. Table [Wizard] Table. Table Table DataSet ' ', Table ' ', ' '. ' ' '#OZDeleteFlag#' Table DataSet Table, Row. Table 6. 277

OZ Application Designer User's Guide Button Description ' ' ' ' Table. ' ' ' ' Table. ' '., Table. ' '., Table. ' '., Table. ' '., Table. Table ' ' Drag & Drop. ' ' ''. 278

. Property Type ColumnType ColumnName SortType ColumnEditable ColumnMerge ColumnAutosize Description. Table TableItem., Label, PictureBox, Button, CheckBox, RadioButton, ComboBox,... 'None', 'Text' 'Numeric'.... 'None', 'FixWidth', 'Auto', 'FixWidthNotShrink'. 279

OZ Application Designer User's Guide TreeView TreeView. TreeView Board TreeView, TreeView [Wizard] TreeView. TreeView TreeView 'Member' ''. Member TreeView,. [Tab] Property, TreeNode. 280

Property Type Text Checked Bold ImageIndex SelectedImageIndex LabelEditable NodeID Description. TreeView TreeNode. TreeNode. TreeNode. TreeView, TreeView 'CheckBoxes' 'True'. TreeNode. TreeNode. TreeView ImageList. TreeNode. TreeView ImageList. TreeNode. TreeView 'LabelEdit' 'True'. TreeNode ID. 281

OZ Application Designer User's Guide 282

283

OZ Application Designer User's Guide OZF, OZ Function Editor, OZF. OZF OZ Function. OZF OZ Application Designer, OZF OZ Application Designer. OZF 'OZ Function Editor'. 284

OZ Function Editor OZ Application Designer. OZ Application Designer 'OZ Application Designer' [Tools] -> [External Tools] -> [Function Editor] 'OZ Function Editor'. 285

OZ Application Designer User's Guide OZ Function Editor,. Window Description OZ Function Editor (pull down),,,,,. OZ Function Editor,,,,,,,. 286

. OZF... 287

OZ Application Designer User's Guide OZ Function Editor (pull down),,,,,. (File) [File]. New Function (Ctrl+N) OZF. [New Function]. Open Function (Ctrl+O) OZF. Close Function OZF.. Save Function (Ctrl+S) OZF, XML OZF. Save Function As OZF, XML OZF. 288

Save Function (Text Type) (Ctrl+Shift+S) OZF OZF, XML OZF. XML. Save Functin As (Text Type) OZF OZF, XML OZF. XML. Recent Function OZF. OZF 4 OZF. Exit OZ Function Editor. (Edit) [Edit]. Undo (Ctrl+Z). 289

OZ Application Designer User's Guide Redo (Ctrl+Y),. Cut (Ctrl+X). Copy (Ctrl+C). Paste (Ctrl+V). Delete (Delete). [Undo]. Find (Ctrl+F). [Find Next].. Option Match Whole World Only Match Case Direction Description..,. Relpace (Ctrl+H). 290

[Find Next] [Replace] [Replace All]. Go To (Ctrl+G).. [Ok]. (View) [View]. Repository Explorer OZ Function Editor. 291

OZ Application Designer User's Guide (Tools) [Tools]. Options ' ' OZ Function Editor,,,. [Ok] OZ Function Editor [Restore]. - Option Layout OZ Function Editor. Save layout when exit OZ Function Editor OZ Function Editor. OZ Function Editor [Reset window layout] [Save current layout]. International Setting. 292

Save OZF. - Editor Function Editor,,. 293

OZ Application Designer User's Guide (Help) [Help]. About OZ Application Function Editor OZ Function Editor. 294

OZ Function Editor,,,,,,,,. (Standard),. Icon Description New Function, Open Function, Save Function, Save To Text Undo, Redo, Cut, Copy, Paste About OZ Application Function Editor (View). Icon Description View Repository 295

OZ Application Designer User's Guide OZ Function Editor [File] [New Function] (. ) OZF,,. function (Argument1, Argument2,... ) { //Script...... // return ; } OZF.. function changebackcolor(componentname, RGBColor) { //Script...... } function changetextcolor(componentname, RGBColor) { //Script...... } 296

OZ Function Editor OZF OZ Application Designer. Step 1 OZF 'OZ Function Editor' RGB OZF. 'OZ Function Editor' [File] [New Function] ( )... function changebackcolor(componentname, RGBColor) { var objcomp = _GetCurrentBoard().GetChild(ComponentName); objcomp.backcolor = RGBColor; } 297

OZ Application Designer User's Guide [File] [Save Function] ( ) OZF. ' ' 'OZF_ChangeBackColor.ozf'. 'C:\Repository'. Step 2 OZF OZF. Board Label, GroupBox, RadioButton. [File] [Insert New Function] OZF. 298

OZF Invisibles., OZF OZF. OZF Invisibles OZF [Show Script]. OZF Invisibles OZF [Edit Function] 'OZ Function Editor'.. 299

OZ Application Designer User's Guide OZF Invisibles OZF [Delete Function] [Delete] OZF. Step 3 RadioButton Label OZF. 'Red', 'Green', 'Blue', 'Black' RadioButton 'OnClick' OZF. rbred OnClick changebackcolor("label1", "255, 0, 0"); rbgreen OnClick changebackcolor("label1", "0, 255, 0"); rbblue OnClick changebackcolor("label1", "0, 0, 255"); rbblack OnClick changebackcolor("label1", "0, 0, 0"); Step 4 [File] [Preview] (. ) RadioButton Label. 300

301

OZ Application Designer User's Guide OZS, OZ Style Editor, OZS. OZS OZ Style, OZS,.,,, OZS,. OZS 'OZ Style Editor'. 302

OZ Style Editor OZ Application Designer. OZ Application Designer 'OZ Application Designer' [Tools] -> [External Tools] -> [Style Editor] 'OZ Style Editor'. 303

OZ Application Designer User's Guide OZ Style Editor,. Window Description OZ Style Editor (pull down),,,,,,. 304

OZ Style Editor,,,,.. OZS.... 305

OZ Application Designer User's Guide OZ Style Editor (pull down),,,,,,. (File) [File]. New Stylelist (Ctrl+N) OZS. [New Stylelist], OZS. Open Stylelist (Ctrl+O) OZS. Close Stylelist OZS.. Save Stylelist (Ctrl+S) OZS. Save Stylelist As OZS. 306

Recent Stylelist OZS. OZS 4 OZS. Exit OZ Style Editor. (Edit) [Edit]. Undo (Ctrl+Z). Redo (Ctrl+Y),. Cut (Ctrl+X). Copy (Ctrl+C). Paste (Ctrl+V). 307

OZ Application Designer User's Guide Delete (Delete). [Undo]. (Style) [Style]. Insert New Style. [Insert New Style]. [OK]. Remove Style. Insert New Properties. [Insert New Properties]. 308

[Insert]. Remove Properties. [Remove Properties]. 'BackColor', 'Multiline', 'TextAlign', 'TextColor', 'WordWrap' 'Style1'. 309

OZ Application Designer User's Guide [Remove]. (View) [View]. Repository OZ Style Editor. Properties OZ Style Editor. Icons OZS. List OZS 310

. Details OZS. (Tools) [Tools]. Options ' ' OZ Function Editor,,. 311

OZ Application Designer User's Guide [Ok] OZ Style Editor [Restore]. - Option Layout OZ Style Editor. Save layout when exit OZ Style Editor OZ Style Editor. OZ Style Editor [Reset window layout] [Save current layout]. International Setting. 312

Save OZS. (Help) [Help]. About OZ Application Style Editor OZ Style Editor. 313

OZ Application Designer User's Guide OZ Style Editor,,,,,,,,,,,,,. (Standard),. Icon Description New Stylelist, Open Stylelist, Save Stylelist Undo, Redo, Cut, Copy, Paste Insert New Style, Remove Style Insert New Propeties, Remove Properties About OZ Application Style Editor (View). Icon Description View Repository, View Properties 314

OZ Style Editor [File] [New Stylelist] ( ), OZS. [File] [New Stylelist] (. ) - [Style] [Insert New Style] ( ). - [OK]. 'Name'. 'Style2' 'TextBox_Single'. 315

OZ Application Designer User's Guide. - [Insert New Properties] ( ). -. [Insert]. 316

-. 'TextBox_Single' 'BackColor', 'TextAlign', 'Multiline', 'WordWrap'. -. 'BackColor' '255,255,255', 'TextAlign' 'MiddleCenter', 'Multiline' 'True', 'WordWrap' 'False'. 317

OZ Application Designer User's Guide. - [Remove Properties] (. ) -. [Remove] 318

OZS [File] [Save Stylelist] ( ) OZS. 319

OZ Application Designer User's Guide OZ Style Editor OZF OZ Application Designer. 320

Step 1 OZS OZ Style Editor Label, TextBox, MaskTextBox OZS. Label,,,,. OZ Style Editor [File] [New Stylelist] OZS. 'Style1' 'Label'. Label [Insert New Properties]. ' ' BackColor, TextColor, LineColor, Font, TextAlign,. TextBox 'Customer Name' TextBox. 321

OZ Application Designer User's Guide [Style] [Insert New Style] ( ). 'TextBox_Single' [OK]. 'TextBox_Single' 'Font', 'BoardStyle'. TextBox 'Customer Info.' TextBox,,,. [Style] [Insert New Style] ( ), 'TextBox_Multi' [OK]. 'TextBox_Multi' 'Font', 'BoardStyle', 'Multiline', 'ScrollBars', 'WordWrap'. 322

MaskTextBox,,,,. [Style] [Insert New Style] ( ), 'MaskTextBox_Date' [OK]. 'MaskTextBox_Date' 'Font', 'BoardStyle', 'Mask', 'Literal', 'Default'. [File] [Save Stylelist] ( ) OZS. ' ' 323

OZ Application Designer User's Guide 'OZS.ozs'. 'C:\Repository'. Step 2 OZS Board OZS. Board 'OZ Application Designer', Board Label, TextBox, MaskTextBox. OZS [File] [Insert New Style] OZS. 324

OZS Invisibles. Step 3. Label1, Label2, Label3 'Style' 'OZS.Label'. TextBox1 'Style' 'OZS.TextBox_Single'. TextBox2 'Style' 'OZS.TextBox_Multi'. MaskTextBox1 'Style' 'OZS.MaskTextBox_Date' Step 4 [File] [Preview] (. ) 325

OZ Application Designer User's Guide 326

327

OZ Application Designer User's Guide OZ Application Designer. OZA, OZC, OZF, OZS, ODI,,,.. OZ Application Designer. OZ Application Designer. Step 1 OZ Application Designer 'RepositoryServer' [Open Repository]. 328

Step 2 ' '. ' '. Option Type IP Port URL Name Password Description OZ Server. Daemon TCP, Servlet HTTP. Daemon OZ Server IP. Daemon OZ Server Port. Servlet OZ Server URL... Step 3 [OK]. Daemon OZ Server. 329

OZ Application Designer User's Guide 'admin'. Step 4 OZ Application Designer. ( ) ( ),,,. 'Repository Root' OZ Server 'Conf\repository.properties', 'OZ Enterprise Server Administrator's Guide'. 330

OZ Application Designer. OZ Application Designer [Close Repository]. 331

OZ Application Designer User's Guide, OZC, OZF, OZS. [File] [Open Project] ( )... [File] [Save Project] ( ).. 332

. OZ Application Designer Drag & Drop [Upload to Repository] ' '. [Upload]. [Download]. 333

OZ Application Designer User's Guide ' ' [Download].. 334

,,. Admin 'None',, BuiltIn RDB. 'OZ Enterprise Server Administrator's Guide'.,.,.,.. [Check In]. 335

OZ Application Designer User's Guide ' ' [Check In]. 'Keep checked out' [Check In].. Admin 'None' Admin,.. [Check Out], ' ' [Check Out]. 336