Differences

This shows you the differences between two versions of the page.

--- axmls:printsql [2015/11/16 01:22] – mnewnham
+++ v5:axmls:printsql [2016/01/13 02:26] (current) – ↷ Links adapted because of a move operation mnewnham
@@ Line 1: / Line 1: @@
 ====== printSql ======
-~~NOTOC~~~
+~~NOTOC~~
 <WRAP right box>
 == Syntax ==
@@ Line 8: / Line 8: @@
 </WRAP>
 ===== Description =====
-Returns the current SQL array.
+Returns the last generated current SQL array in printable format.
-Call this method to fetch the array of SQL queries resulting from axmls:parseschema|ParseSchema()] or [[axmls:parseschemastring|ParseSchemaString()]].
+Call this method to fetch the array of SQL queries resulting from [[v5:axmls:parseschema|ParseSchema()]] or [[v5:axmls:parseschemastring|ParseSchemaString()]].
+The method returns an array of SQL statements or FALSE if an error occurs. The available options are:
+^Value^Description^
+|'string' or 'text'|Returns a value formatted for the console|
+|'html'|Returns an HTML formatted string|
+Any other provided argument returns a PHP array, which can be sent to [[axmls:executeSchema()]] or [[v5:dictionary:executesqlarray]]
-The method returns an array of SQL statements or FALSE if an error occurs