At 08:49 2013-05-22, "Gary Jeurink" <g.jeur...@charter.net> wrote:
As I am bouncing around trying to learn mysql also, I often accidently say tinyint. In foxpro I like the speed of building and modifying tables and then using a builder to drop it on the form. In foxpro, a tinyInt, I choose numeric with 1 or 2 digits and 0 decimal. I am struggling in decisions in that I created a class id-no so that 100's are mon., 200's are tues., and so on. 1000's are summer classes while the less than 1000 are school year classes.... so in that sense, a day of class field is not needed. Ted
Encoding like this can get very messy, especially if your encoding schema has to change later. Or those exceptions.
pointed out in the next post that it is the exceptions that are hard to deal with. I have some team workouts that meet between 2 to 4 times per week at
[snip] Sincerely, Gene Wirchenko _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.