Forums before death by AOL, social media and spammers... "We can't have nice things"
|    comp.databases.oracle    |    Overblown overpriced overengineered SHIT    |    2,288 messages    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
|    Message 1,718 of 2,288    |
|    Johnson to All    |
|    database structure problem - advice plea    |
|    06 Sep 04 05:08:49    |
      From: johnson@spam.troll              Here's what I was doing, it is obviously stupid because i have exceeded the       "too many fields defined error"              I have to create a database driven application that allows students to       update the records of which classes they took, what grade they received, and       what semester they took the class in.              I was using one database table, with some unique identifiers for each       student. Then for each of the 50 classes they have to take, I had 4 fields       each, one for whether they took it or not, one for the semester, one for the       year, one for the grade they received.              So all in all I had 4x50 fields for the classes and then the various unique       identifiers.              I just can't fathom how to simplify this problem. Anybody got any ideas?              --- SoupGate-Win32 v1.05        * Origin: you cannot sedate... all the things you hate (1:229/2)    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
(c) 1994, bbs@darkrealms.ca