Differences

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

--- dictionary:createindexsql [2015/08/29 03:09] – created 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>
 In databases that support partial column indexing, the columns can be passed as ''COLUMN_1(20)''.
 ==== $indexOptions ====
-An array of possible options to creating the index. Some options are database specific. To create a unique index, pass the array ('UNIQUE');
+An array of possible options to creating the index. Some options are database specific. To create a unique index, pass the array ''('UNIQUE')'';
 ===== 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>
-===== Usage =====
-<code php>
-</code>