v5:dictionary:createindexsql
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
dictionary:createindexsql [2015/08/29 16:09] – mnewnham | v5:dictionary:createindexsql [2016/01/13 02:06] (current) – ↷ Links adapted because of a move operation mnewnham | ||
---|---|---|---|
Line 1: | Line 1: | ||
====== createIndexSql ====== | ====== createIndexSql ====== | ||
- | <WRAP todo> | ||
- | Add usage example | ||
- | </ | ||
~~NOTOC~~ | ~~NOTOC~~ | ||
<WRAP right box> | <WRAP right box> | ||
Line 17: | Line 14: | ||
- | In order to actually create the column, the returned array must be passed to the [[dictionary: | + | In order to actually create the index, the returned array must be passed to the [[v5:dictionary:executesqlarray|executeSqlArray()]] method. |
===== Parameters ===== | ===== Parameters ===== | ||
Line 40: | Line 37: | ||
===== Usage ===== | ===== Usage ===== | ||
<code php> | <code php> | ||
+ | |||
+ | $dict = NewDataDictionary($db); | ||
+ | $sqlarray = $dict-> | ||
+ | print_r($sqlarray); | ||
+ | /* | ||
+ | * prints | ||
+ | * | ||
+ | Array | ||
+ | ( | ||
+ | [0] => CREATE INDEX SALESIDX ON ACT (ACTMAXSALE, | ||
+ | ) | ||
+ | */ | ||
</ | </ | ||
v5/dictionary/createindexsql.1440857376.txt.gz · Last modified: 2017/04/21 11:28 (external edit)