May 10, 2016

Common Table사용해서 Field값 비교하기

static NoYes validateDeleteCheckVATTable(TableId       _TableId,
                                         Name          _Name)
{
    //Table Delete check table
    Common                          _Common = new DictTable(_TableId).makeRecord();
    SysDictTable                    _SysDictTable = new SysDictTable(_TableId);
    NoYes                           _DeleteCheck;

    select firstOnly RecId from _Common
    where _Common.(_SysDictTable.fieldName2Id("Name")) == _Name;
    if (_Common.RecId)
 {
  info(int642str(_Common.RecId));
 }
}

No comments:

Post a Comment