Information Systems:Notes on Infonet Development

From uniWIKI
Revision as of 20:22, 17 October 2016 by Norwinu (talk | contribs) (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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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 Queries

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.