Appendix B The OrcaScript Language – PB Docs 115
Appendix B The OrcaScript Language About this appendix This appendix describes the OrcaScript scripting language. OrcaScript allows you to perform source control operations and build PowerBuilder workspaces and executables without operator intervention. The full ORCA tool kit is available to Sybase partners only, but OrcaScript can be used by any PowerBuilder customer. Contents Topic About…
Analyzing trace information using profiling tools – PB Docs 115
Analyzing trace information using profiling tools After you have created a trace file, the easiest way to analyze it is to use the profiling tools provided on the Tool tab of the New dialog box. There are three tools: The Profiling Class View shows information about the objects that were used in the application The…
Positioning controls in a DataWindow object – PB Docs 115
Positioning controls in a DataWindow object Table 20-3 shows the properties for each control in a DataWindow object that determine how it is positioned within the DataWindow object. Table 20-3: Position properties for controls in a DataWindow object Property Meaning Background Control is behind other controls. It is not restricted to one band. This is…
Defining queries – PB Docs 115
Defining queries A query is a SQL SELECT statement created in the Query painter and saved with a name so that it can be used repeatedly as the data source for a DataWindow object. Queries save time, because you specify all the data requirements just once. For example, you can specify the columns, which rows…
About displaying and validating data – PB Docs 115
About displaying and validating data When PowerBuilder generates a basic DataWindow object, it uses the extended attributes defined for the data and stored in the extended attribute system tables. For more information about the extended attribute system tables, see Appendix A, “The Extended Attribute System Tables” In the Database painter, you can create the extended…
Using the Graph presentation style – PB Docs 115
Using the Graph presentation style Instead of embedding a graph in a DataWindow object, you can use the Graph presentation style to create a DataWindow object that is only a graph—the underlying data is not displayed. One advantage of the Graph presentation style is that the graph resizes automatically if users resize the DataWindow control…
About validation rules – PB Docs 115
About validation rules When users enter data in a DataWindow object, you want to be sure the data is valid before using it to update the database. Validation rules provide one way to do this. You usually define validation rules in the Database painter. To use a validation rule, you associate it with a column…
Managing workspaces – PB Docs 115
Managing workspaces Adding an existing target to a workspace Although you can have only one workspace open at a time, you can add as many targets to the workspace as you want and open and edit objects in multiple targets. Working with targets that share PBLs If a target shares PBLs with another target in…
Controlling access to the current database – PB Docs 115
Controlling access to the current database The Database painter’s Design menu provides access to a series of dialog boxes you can use to control access to the current database. In some DBMSs, for example, you can assign table access privileges to users and groups. Which menu items display on the Design menu and which dialog…
Communicating between a window and a user object – PB Docs 115
Communicating between a window and a user object Often you need to exchange information between a window and a visual user object in the window. Consider these situations: You have a set of buttons in a custom user object. Each of the buttons acts upon a file that is listed in a SingleLineEdit control in…