Monday, January 18, 2016

Concatinating mulitple values to particular query range

Concatinating mulitple values to particular query range

Two ways we can concatinate multiple values to particular query range

1.
    CustGroup CustGroup;
    str    custGroupConcate;
    Boolean first = true;
        while (custGroup)
        {
            if(first == true)
            {
                custGroupConcate = custGroup.CustGroup;
                first            = false;
            }
            else
            {
                custGroupConcate    += (',' + custGroup.CustGroup);
            }
           
        }



2.
       str    custGroupConcate;
        while (custGroupCur)
        {
              queryRangeConcat(categoryConcate, custGroupCur.CustGroup);
         
        }

No comments:

Post a Comment