When doing printf on my array with this code I get no results:
Code:
EXEC SQL DECLARE c1 CURSOR for
SELECT cc, cc_sn, cc_desc, cc_grp
FROM cc_lkup
WHERE cc_grp != ''
ORDER BY cc;
EXEC SQL OPEN c1;
EXEC SQL FETCH c1
INTO :cc_lkup2[y].cc, :cc_lkup2[y].cc_sn, :cc_lkup2[y].cc_desc, :cc_lkup2[y].cc_grp;
y = y + 1;
EXEC SQL CLOSE c1;
But with this code I get all the records displayed: - Hell I give up till tomorrow
Code:
EXEC SQL SELECT cc, cc_sn, cc_desc, cc_grp
INTO :cc_lkup2[y].cc, :cc_lkup2[y].cc_sn, :cc_lkup2[y].cc_desc, :cc_lkup2[y].cc_grp
FROM cc_lkup
WHERE cc_grp != ''
ORDER BY cc;
EXEC SQL BEGIN;
++y;
EXEC SQL END;*/