Differences

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

--- dictionary:createindexsql [2015/08/29 18:51] – 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 index, 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 39: / Line 39: @@
 $dict = NewDataDictionary($db);
-$sqlarray = $dict->createIndexSql('ACT','SALESIDX', 'ACTMAXSALE,ACTNO');
+$sqlarray = $dict->createIndexSql('SALESIDX','ACT', 'ACTMAXSALE,ACTNO');
 print_r($sqlarray);
 /*
@@ Line 46: / Line 46: @@
 Array
 (
-    [0] => CREATE INDEX ACT ON SALESIDX (ACTMAXSALE, ACTNO)
+    [0] => CREATE INDEX SALESIDX ON ACT (ACTMAXSALE, ACTNO)
 )
 */
 </code>