Overview

This page probably won't last.

Nonetheless, an area needs to be devoted to discussing development in Infonet (therefore, mostly talk related to WebSmart).

SQL PML functions

There are two main PML query functions - sqlquery and sqlexec.

Polymorphism in sqlexec is done through the following syntax (memorize this!):

sqlexec("select column1, column2 into :some_variable from some_table where some_column_filter='" + PML_variable + "'")

I've forgotten this a million and one times.