Hi,
have a record set consisting of 1 field.
Possible entries are 1, 2, 3, 4.1, 4.2, 4.3, 5.1, 5.2, 6.1, 6.2, 7, 8,
9, null
Goal is to read the RS and as it finds certain numbers that it prints a
cooresponding file, then moves on to the next until EOF.
Have tried a few things and still do not have a solution.
pretty sure I need 'do while not EOF' and 'loop', but trying to keep it
simple. My problem might be in setting and reading the variable.
I would greatly appreciate some air code to play with. Once completed I
will post the complete procedure for others to play with.
Help I am lost!
for reference, here is my sqlcode to pull the recordset.
SELECT Art_UN.Label_1 FROM TMP_pack INNER JOIN Art_UN ON
TMP_pack.UN_Typ = Art_UN.UN GROUP BY Art_UN.label_1;