Archive for the ‘Power Builder’ Category

Handling NULL values in PowerBuilder

Share

When it comes to NULL values, PowerBuilder treats them a little different than other languages. Not only that, when null is added, compared to or concatenated with any variable the entire result will become null, but also when given a null parameter most PowerBuilder functions will simply return NULL and perform no action.

Share
Tags:      

SQL statements embedded into PowerScript code

Share

SQL statements can be embedded directly into PowerScript code, allowing you to include PowerScript variables in any area of the statement ,whereas you can’t include them if using PowerBuilder Database painter. To work with variables, the SELECT statement accept the INTO clause, that enable assignment of the result to existent variables.  For example: SELECT COUNT(*) […]

Share
Tags:   

Populate DDDW based on the value of another DDDW

Share

The contents of a particular drop down datawindow depends on the value of another drop down datawindow. For example we need to filter some employees based on the team they belong to. In the current datawindow, Teams will be a drop down datawindow whose contents depend on the value of another DDDW – Departments.

Share
Tags: