I have the following Pro*C code here: http://stealth.kirenet.com/~aleinss/menu.pc
My database tables and data are here: http://stealth.kirenet.com/~aleinss/create.sql
I'm trying to implement a function (print_table()) that prints out a table, that's it. Simple right? Wrong! Well, it works, sort of:
Name Address ID Class # of Overdue Materials
------ --------- ---------- --- -----
Betty White 555 N. Old Fart St. 999067540
Adam Leinss 4971 N. 107th St. 999967260
Paul McNally 557 N. Database Dr. 999008940
The problem is that the class and # over overdue materials get completely dropped (i.e. not printed to the screen) and I have no idea why??? I thought it was printing out the class earlier (which is either the letters O, F or S), but now it doesn't print either the class or the # of overdue materials.
Also, is there an easy(ier) of formatting the titles on this report? I'm having a dickens of a time matching it up with the data.