Difference between revisions of "Information Systems:Notes on Infonet Development"
Jump to navigation
Jump to search
(Created page with "=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 Q...") |
m |
||
| Line 4: | Line 4: | ||
Nonetheless, an area needs to be devoted to discussing development in Infonet (therefore, mostly talk related to WebSmart). |
Nonetheless, an area needs to be devoted to discussing development in Infonet (therefore, mostly talk related to WebSmart). |
||
| − | ==SQL |
+ | ==SQL PML functions== |
There are two main PML query functions - sqlquery and sqlexec. |
There are two main PML query functions - sqlquery and sqlexec. |
||
Revision as of 20:23, 17 October 2016
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.