Differences

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

--- dictionary:createindexsql [2015/08/29 03:11] – mnewnham
+++ v5:dictionary:createindexsql [2016/01/13 02:06] (current) – ↷ Links adapted because of a move operation mnewnham
@@ Line 14: / Line 14: @@
-In order to actually create the column, the returned array must be passed to the [[dictionary:executeSqlArray|executeSqlArray()]] method.
+In order to actually create the index, the returned array must be passed to the [[v5:dictionary:executesqlarray|executeSqlArray()]] method.
 ===== Parameters =====
@@ Line 28: / Line 28: @@
 or as a numeric array:
 <code php>
-$fields = array('COLUMN_1','COLUMN_2',COLUMN_3');
+$fields = array('COLUMN_1','COLUMN_2','COLUMN_3');
 </code>
@@ Line 37: / Line 37: @@
 ===== Usage =====
 <code php>
+$dict = NewDataDictionary($db);
+$sqlarray = $dict->createIndexSql('SALESIDX','ACT', 'ACTMAXSALE,ACTNO');
+print_r($sqlarray);
+/*
+* prints
+*
+Array
+(
+    [0] => CREATE INDEX SALESIDX ON ACT (ACTMAXSALE, ACTNO)
+)
+*/
 </code>