[eluser]whobutsb[/eluser]
Hello All,
Next week i'm updating one of my application databases to a new version. And I need to do some heavy updates to the Tables and Column Structures of my DB. I'am currently using MSSQL 2000 for my database.
To help me make the move, I was going to use CI to do all the database updates automatically. When I tried to write my first update I began to get errors. Here is an example:
Code:
$add = array(
'estimated_value' => array('type' => 'MONEY')
);
$this->dbforge->add_column('tblStatus', $add);
The Error Message that I receive is
Quote:ALTER TABLE tblStatus ADD Array NOT NULL
It seems the Forge utility isn't looping through the array I setup.
Has anyone else experienced a problem like this?
Thanks for the help!