Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
Brianm10,
you probably checked that you have also MATERIAL_DESCRIPTION values in table COPA where len(PROD_HIER)=10?
Brianm10,
you probably checked that you have also MATERIAL_DESCRIPTION values in table COPA where len(PROD_HIER)=10?
argh... my mistake
Thanks