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 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 different times. Also a class level field is redundant as the class title repeats this info. So, I am using Level-4 WITH a unique id-no as an individual instance where Level-4 Team would reoccur but with the same id-no. to represent the same athlete list.
When it's all installed, I want to be able to know how many different classes and students will be scheduled at any particular time. It's not unusual to see too many students with not enough available areas to use. I would like to prevent this. -----Original Message----- From: Kurt Wendt [mailto:k...@isssusa.com] Sent: Tuesday, May 21, 2013 11:57 AM To: profox@leafe.com Subject: RE: time and space managemnent Gary - when you referred to "tinyInt" - it gave me the idea you were working in something other than VFP - maybe like C#. And, I surely can't help U w/C# - as I have limited exp. w/that. However, you do have the Datetime() and a number of other functions that allow you to manipulate & use Date/Time type data! As for the HTML - I'm assuming you are talking about some very Static type HTML webpages - which should be quite easy to do w/VFP. Maybe just generate the HTML code and put inside a Memo field as you build it - then export it as a Text file - but, w/HTML extension... -K- -----Original Message----- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Gary Jeurink Sent: Tuesday, May 21, 2013 12:25 PM To: profoxt...@leafe.com Subject: time and space managemnent I am trying to develop a gymnastics school management system. I am building the classes table and I need to build it so I can look at when each class starts and which day it is on so I that can allocate specific gym space per class at various times. I don't really think the specific date is important because each particular class is scheduled on a specific day like on Mondays at 5:00 pm for an hour each week. I need to show start and finish and be able to show when there might be 3 to 5 classes taking place at the same time. I will be marking attendance per class and assigning gym area space per class. What data types would be appropriate?. I am not good with date and time data types so I am currently thinking of just using a tinyInt 1-6 (mon-sat) and then use a time data for start with a class field of duration (45/60/90/120) in minutes. The gym, that I volunteer coach for, needs desperate improvement in this area. I'm shooting to be able to generate an html table for each day with a time line on the left side (rows) and each gym area (in columns) across the top. Each class would be a color coded text block in a column if you follow me. A large class might occupy two areas in the gym with multiple instructors. I think it is a very complex task. If anything, I want to show the gym owner where they have over scheduled the gym. Any suggestions or strategies would be welcome. Gary Jeurink --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] _______________________________________________ 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/EE26EA5E52554AA4BF5CB1D486878D41@OwnerPC ** 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.