Retrieving data – PB Docs 2017
Retrieving data Where PowerBuilder gets data PowerBuilder follows this order of precedence to supply the data in your DataWindow object: If you have saved data in the DataWindow object, PowerBuilder uses the saved rows from the DataWindow object and does not retrieve data from the database. PowerBuilder uses the data in the cache, if there…
Examples – PB Docs 2017
Examples This section shows how to specify the data for several different graphs of the data in the Printer table in the PB Demo DB. The table records quarterly unit sales of three printers by three sales representatives. Rep Quarter Product Units Simpson Q1 Stellar 12 Jones Q1 Stellar 18 Perez Q1 Stellar 15 Simpson…
Compare objects – PB Docs 2017
Compare objects You can compare an object in your local directory with the version of the object that was last synchronized with the source control server. If the object you want to compare has not been added to the source control server, or the local object is not changed since last sync, the Git Diff…
Input fields – PB Docs 2017
Input fields An input field can be either a column or a computed field. Before you retrieve data, its value is shown as two question marks (??). The text can include many copies of a named input field. The same data will appear in each instance of the input field. Column input fields The columns…
Example – PB Docs 2017
Example This example uses a DataWindow object that includes the columns emp_id, emp_fname, emp_lname, and dept_id. The template used in this example includes only these columns. Any other columns in the DataWindow remain empty when you import using this template. To illustrate how template import works, create a new template that has one element in…
Filtering rows – PB Docs 2017
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….
Sorting rows – PB Docs 2017
Sorting rows Contents Suppressing repeating values You can use an ORDER BY clause in the SQL SELECT statement for the DataWindow object to sort the data that is retrieved from the database. If you do this, the DBMS itself does the sorting and the rows are brought into PowerBuilder already sorted. However, you might want…
About data pipelines – PB Docs 2017
About data pipelines Contents Defining a data pipeline Piping extended attributes The Data Pipeline painter gives you the ability to reproduce data quickly within a database, across databases, or even across DBMSs. To do that, you create a data pipeline which, when executed, pipes the data as specified in the definition of the data pipeline….
Modifying data – PB Docs 2017
Modifying data You can add, modify, or delete rows in the Preview view. When you have finished manipulating the data, you can apply the changes to the database. Changing input language You (and your users) can add or modify data in a DataWindow object in multiple input languages. If you use multiple input languages, you…
Using the inherited information – PB Docs 2017
Using the inherited information When you build and save a menu, PowerBuilder treats the menu as a unit that includes: All menu items and their scripts Any variables, functions, and structures declared for the menu When you use inheritance to build a menu, everything in the ancestor menu is inherited in all of its descendants….