I have a .pc (proc program) with a function that should select from the database a student's email address and put it in a variable.
This works correctly, except everytime, the first email address is blank,...I have double checked this and there is an email address for this person. Am I missing something silly?'
EXEC SQL SELECT goremal_email_address
WHERE goremal_pidm = :campus_id;
email_address.arr[email_address.len] = '\0';
thanks in advance