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.
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(*) […]
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.