Hi All

I need to drop a field from a table after all the values in that field have
been copied to a new field, can anyone help;

ttsbegin;

        while select forupdate ActivityStatus, Status from smmActTable
            where   smmActTable.Status == smmActivityStatusGroup2::Lost ||
                    smmActTable.Status == smmActivityStatusGroup2::Nominated
||
                    smmActTable.Status == smmActivityStatusGroup2::Sensitive
                    {
                        smmActTable.ActivityStatus =
Enum2Str(smmActTable.Status); // copy values to new field
                        smmActTable.update();
                    }
ttscommit;

------------------------------------------------------------------

Daniel J. Redelinghuys
Axapta Developer  UTi-Sun Couriers Division
Tel: +27 12 673 2324 Fax: +27 12 673 2344

------------------------------------------------------------------




[Non-text portions of this message have been removed]





Yahoo! Groups Sponsor
ADVERTISEMENT
click here


Yahoo! Groups Links

Reply via email to