Masuk
 
AwalPerpustakaanWikiPelajariUnduhDukunganKomunitasForum
Resources for IT Professionals >
> 
> 
Unable to sort the BDC list column

Answered Unable to sort the BDC list column

  • 23 Februari 2012 15:49
     
     
    Masuk untuk Memilih
    0
    Hi All

    I created a BDC list. Sorting is not working for the some of the columns which are system.string type and in data base it is varchar. More over the BDC list is enable with filter criteria. So can any one please help me to solve this issue. This is very urgent.


    Regards,
    Kishore

    Kishore

     

Semua Balasan

  • 24 Februari 2012 6:08
    Moderator
     
     Jawab
    Masuk untuk Memilih
    0
     

    Hi Kishorekv,

    I’m not sure there is whether an blank spaces in your SQL . for example, SELECT NAME AS "FIRST NAME" FROM Test, if it contains the blank spaces, the sort will not work. you can modify it to like the following .

    <TypeDescriptor TypeName="System.String" Name="NAME">
    <LocalizedDisplayNames>
                <LocalizedDisplayName LCID="1033">FIRST  NAME </LocalizedDisplayName>
          </LocalizedDisplayNames>
    </TypeDescriptor>

    Thanks,

    Jack