DEV_ValidTimeState table;
;
delete_from table;
table.clear();
table.validTimeStateUpdateMode(ValidTimeStateUpdate::CreateNewTimePeriod);
table.ValidFrom = DateTimeUtil::newDateTime(1\1\2012, 0);
table.ValidTo = DateTimeUtil::maxValue();
table.ItemId = '1000';
table.insert();
To Update:
ttsBegin;
while select forUpdate validTimeState(fromDateTime) table
{
table.validTimeStateUpdateMode(ValidTimeStateUpdate::Correction);
table.ItemId = '1002';
table.update();
}
ttsCommit;
No comments:
Post a Comment