ADOdb

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== executeSqlArray ======
~~NOTOC~~
<WRAP right box>
== Syntax ==
  bool executeSqlArray (
      array $sqlStatements
      )
</WRAP>
===== Description =====
The method ''executeSqlArray()'' executes an array of statements constructed by one of the data dictionary functions such as [[v6:dictionary:createtablesql|createTableSql()]],  [[v6:dictionary:dropindexsql|dropIndexSql()]] or  [[v6:dictionary:addcolumnsql|addColumnSql()]]. 

The statements are executed within the scope of a single transaction.
===== Usage =====

<code php>
/*
* create a data dictionary object, using the database connection
*/
$dict = NewDataDictionary($db);

$tabname = "LCTABLE";
/*
 * Change the length of COL1 from 32 chars to 60
 */

$flds = " 
   COL1 C(60) NOTNULL DEFAULT 'abc',
  ";

/*
* create the SQL statement necessary to modify the column
*/
$sqlarray = $dict->changeTableSQL($tabname, $flds);

/*
* This statement actually changes the table
*/
$db->startTrans();
$dict->executeSqlArray($sqlarray);
$db->completeTrans();
</code>