2 Replies Latest reply: Oct 29, 2011 7:33 AM by Brian Murphy RSS

    resident tables - values not being passed

      On the following code the field 'CatEDesc' does not hold any data. In my QV app when I select a listbox with the value 'CatEDesc' nothing is returned under that value.

       

      However if I have a listbox with 'MATERIAL DESCRIPTION' im given all the product descriptions. Am i missing something here, why cant the values from MATERIAL_DESCRIPTION be passed onto CatEDesc? 

       

      (In my table 'COPA', you have the MATERIAL_DESCRIPTION. There are no issues with this table.)

       

      Any help would be greatly appreciated. Thanks

       

      groupedCodes:

      NOCONCATENATE LOAD

      PROD_HIER as prod_h,

      MATL_GROUP,

      left(PROD_HIER,2)&'00000000' as CatACode,

      left(PROD_HIER,4)&'000000' as CatBCode,

      left(PROD_HIER,6)&'0000' as CatCCode,

      left(PROD_HIER,8)&'00' as CatDCode,

      MATERIAL_DESCRIPTION as CatEDesc

      RESIDENT COPA

      where len(PROD_HIER)=10;