Advanced PowerBuilder

Embedded SQL - PowerBuilder Implementation

SQL and in fact, the whole theory of relational databases, is based on sets. The subject of database theory is a book by itself, so we can't teach you everything here, but we can do is look at some of PowerBuilder's implementations.

The simplest way of using SQL in the PowerScript code is to use the Paste SQL option in the Script Painterbar. When you click on this icon , PowerBuilder presents you with the following options:

This allows you to select the type of SQL statement you want to insert, after which PowerBuilder launches the usual query selection dialog boxes, designed to speed up the creation of the statement.

For your reference, PowerBuilder allows you to select the tables to be displayed in the SQL statement. Before we take a look at the various SQL structures that we can use, we must take a look at the concept of Host Variables.

Home	Previous Lesson: Introduction Next Lesson: Using Host Variables