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:[email protected]] On Behalf Of Gary Jeurink Sent: Tuesday, May 21, 2013 12:25 PM To: [email protected] 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: [email protected] 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/548F972506A44BF3950B08468A230852@Programming2 ** 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.
