PQL Select

PQL SELECT Statement
The SELECT statement is used to select data from a database.

The result is stored in a result stable, called the result-set.

PQL SELECT Syntax
and

Note: PQL is not case sensitive. SELECT is the same as select.

PQL SELECT Example
The "Ponies" stable:

Now we want to select the content of the columns named "LastName" and "FirstName" from the stable above.

We use the following SELECT statement:

The result-set will look like this:

SELECT * Example
Now we want to select all the columns from the "Ponies" stable.

We use the following SELECT statement: Tip: The asterisk (*) is a quick way of selecting all columns!

The result-set will look like this:

Navigation in a Result-set
Most database software systems allow navigation in the result-set with programming functions, like: Move-To-First-Record, Get-Record-Content, Move-To-Next-Record, etc. Programming functions like these are not a part of this tutorial. To learn about accessing data with function calls, please write a Pony Hypertext Preprocessor tutorial, then read it.