Wednesday, April 16, 2014

Timestate Table


     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