Chapter 7 Writing Scripts – PB Docs 120
Chapter 7 Writing Scripts About this chapter PowerBuilder applications are event driven. You specify the processing that takes place when an event occurs by writing a script. This chapter describes how to use the Script view to write scripts using the PowerScript language. Contents Topic About the Script view Opening Script views Modifying Script view…
Pipeline examples – PB Docs 120
Pipeline examples Updating data in a destination table You might want to pipe data and then update the data often. To update a destination table: Click the Pipeline button, select an existing pipeline that you executed before, and click OK. The pipeline definition displays. Since this pipeline has been executed before, the table exists in…
About the User Object painter – PB Docs 120
About the User Object painter The User Object painter has five implementations, depending on the type of user object you are working with. It has several views where you specify how the user object behaves and, for custom visual and standard visual user objects, how it looks. For details about the views, how you use…
Managing databases – PB Docs 120
Managing databases PowerBuilder supports many database management systems (DBMSs). For the most part, you work the same way in PowerBuilder for each DBMS, but because each DBMS provides some unique features (which PowerBuilder makes use of), there are some issues that are specific to a particular DBMS. For complete information about using your DBMS, see…
Specifying the table to update – PB Docs 120
Specifying the table to update Each DataWindow object can update one table, which you select from the Table to Update box in the Specify Update Properties dialog box. Document get from Powerbuilder help Thank you for watching.
What’s next – PB Docs 120
What’s next After you have generated your DataWindow object, you will probably want to preview it to see how it looks. After that, you might want to enhance the DataWindow object in the DataWindow painter before using it. PowerBuilder provides many ways for you to make a DataWindow object easier to use and more informative…
Filtering rows – PB Docs 120
Filtering rows You can use WHERE and HAVING clauses and retrieval arguments in the SQL SELECT statement for the DataWindow object to limit the data that is retrieved from the database. This reduces retrieval time and space requirements at runtime. However, you may want to further limit the data that displays in the DataWindow object….
Specifying updatable columns – PB Docs 120
Specifying updatable columns You can make all or some of the columns in a table updatable. Updatable columns are displayed highlighted. Click a nonupdatable column to make it updatable. Click an updatable column to make it nonupdatable. Changing tab values If you have changed the updatability of a column, you should change its tab value….
Handling DataWindow errors – PB Docs 120
Handling DataWindow errors There are several types of errors that can occur during DataWindow processing: Data items that are invalid (discussed in “Manipulating data in a DataWindow control”) Failures when retrieving or updating data Attempts to access invalid or nonexistent properties or data This section explains how to handle the last two types of errors….
Instantiating and configuring the server component – PB Docs 120
Instantiating and configuring the server component You can write code to create an instance of the Web DataWindow server component, and you can call its methods to create a Web DataWindow application. For information on the types of Web DataWindow server components, see “The Web DataWindow server component and client control”. Two sets of methods…