Home

Thursday, June 5, 2014

Upadate record based on Enum value

static void Job2(Args _args)
{
  MyTable mt;
    ttsBegin ;
    while select forupdate mt where mt.RecId!=0 && mt.RecId < 5637146329
    {
        if(mt.Gender ==Gender::Male)
        {
        mt.Gender =Gender::Female;
        }
        else if(mt.Gender ==Gender::Female)
        {
          mt.Gender =Gender::Male;
        }
        mt.update();
        info("done");
    }
    ttsCommit;
}

No comments:

Post a Comment