Boris G
Well Known Member
Dear list,
I'm trying to select multiple records from the F4101 file based on a BASE Item. For example, if the Base Item is 'EC2C', the F4101 could have 'EC2C1', 'EC2C2', etc.
I thought that the following code would do it but it doesn't work, returning File_IO_Status = 'CO ERROR'
F4101.Select
VA sec_Base_Item_LITM is Like TK 2nd Item Number
F4101.Fetch Next
VA sec_Short_Item_ITM <- TK Item Number - Short
VA sec_Identifier2ndItem_LITM <- TK 2nd Item Number
While SV File_IO_Status is equal to CO SUCCESS
....
How do I get a set of Items based on a subset?
Thanks,
Boris
JDE OneWorld B7332 SP10
I'm trying to select multiple records from the F4101 file based on a BASE Item. For example, if the Base Item is 'EC2C', the F4101 could have 'EC2C1', 'EC2C2', etc.
I thought that the following code would do it but it doesn't work, returning File_IO_Status = 'CO ERROR'
F4101.Select
VA sec_Base_Item_LITM is Like TK 2nd Item Number
F4101.Fetch Next
VA sec_Short_Item_ITM <- TK Item Number - Short
VA sec_Identifier2ndItem_LITM <- TK 2nd Item Number
While SV File_IO_Status is equal to CO SUCCESS
....
How do I get a set of Items based on a subset?
Thanks,
Boris
JDE OneWorld B7332 SP10