I have followed this question for adding a custom attribute to Magento orders.
I want to set the value of this attribute programmatically but its not saving to the database. My code:
$_order = Mage::getModel('sales/order');
$_order->loadByIncrementId(100000001);
$_order->setMyCustomField('Testing');
$_order->save();
I have also tried:
$_order->setData('my_custom_field','Testing');
I have checked that the field exists in the sales_flat_order
table
.