14 Replies Latest reply: Feb 2, 2017 9:24 AM by Emanuel Zeilinger RSS

    Field Format

    Emanuel Zeilinger

      Hey folks,

       

      I have a SQL-Table from which I need a field (TBRKEY).

      Thus I request the data with:

       

      TBPOSP_mit:
        load *; SQL select * from TBPOSP where TBTBGR = 'FRD' and TBSART = '122' and TBSPRA = '  ' and TBFIRM = '010';
      
      
      

       

      I get the following result:

      Attention to the format of TBRKEY!!!

      TBPOSP_Mit.png

      But the whole where case is not possible in my specific case.

      Thus I request the data with:

       

      TBPOSP:
        load *; SQL select * from TBPOSP;
      
      
      

       

      After selecting the correct fields I get the following result:

      Attention to the format of TBRKEY!!!

      TBPOSP_Ohne.png

      Why are there zeros in front of the numbers?

      In my opinion I should get in both cases the same result, but as you can see here it is not.

      Any ideas why this behavior is like this and workarounds?

      If this may help, the TBRKEY-field is saved in a SQL database with a field length of 10 and the field type is alphanumeric.