Claudine & everybody: If you want to add time to time try the ADDSEC/ADDMIN/ADDHR functions - they really are a revelation!
For example, if you add 90 seconds you get 1 minute 30 seconds, if you add 90 minutes you get 1 hour 30 minutes. Yes, you have to add integer values but you can use the ISEC/IMIN/IHR functions to get your values. Why these seem to be a "well kept secret" is unbelievable to me - since I found them so many time calculations are so much easier. They take negative integers too, so you can subtract time if you need to. Data entry on a form is GREAT if you use the numeric keypad with a separate field for hrs/mins/secs. I used to hate the time data type because it was to inflexible but now I can do (almost) everything I want with it. (What can't I do? Don't know, but there must be something, otherwise there'd be nothing to ask later!!) Regards, Alastair. ----- Original Message ----- From: "Claudine Robbins" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 17, 2002 8:26 PM Subject: RE: Date and Time > Bill, > I get the "time cannot be added to time error" in the create view > command. I (less elegantly) built a table by incrementing a form > variable by 900 seconds and it created all the values. I'm using a > 24-hour clock since we deliver anytime and that does make a lot of pick > choices. So, I'm going to reduce it to 30 min increments (from existing > data, it seems it often is on the hour or the half hour) and give my > guys the option to change the field so they can customize it, if need > be. But you've given me an idea to apply somewhere else... Thanks for > your time and effort. ~Claudine :) > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:owner-rbase-l@;sonetmail.com] > On Behalf Of Bill Downall > Sent: Thursday, October 17, 2002 1:23 PM > To: [EMAIL PROTECTED] > Subject: RE: Date and Time > > On Thu, 17 Oct 2002 12:40:39 -0500, Claudine Robbins wrote: > > > Is there a way to create a table with all time options (in, say > >15 min increments) for a user to pick with a choose command (short > of > >entering every iteration directly in a table)? > > Claudine, > > Of course there is a way. As somebody once said, "If you can dream > it, you can do it." > > I would create an hours table and a minutes table, like this: > > CREATE TABLE PickHours (PickHour TIME) > LOAD PickHours > 08:00:00 > 09:00:00 > 10:00:00 > 11:00:00 > 12:00:00 > 13:00:00 > 14:00:00 > 15:00:00 > 16:00:00 > 17:00:00 > 18:00:00 > END > > CREATE TABLE PickMinutes (MinInterval TIME) > LOAD PickMinutes > 00:00:00 > 00:15:00 > 00:30:00 > 00:45:00 > END > > Then a view that combines them, to get every possible combination: > > CREATE VIEW TimePicker (PickTime) AS + > SELECT (h2.PickHour + m1.MinInterval) + > FROM PickHours h2, PickMinutes m1 > > Notice that there is NO where clause linking the two tables, so you get > the "cartesian product" of all rows in the first table times all the > rows in > the second table. > > Build a CHOOSE command or a [Shift][F3] pop-up or a List Box from > the view TimePicker. > > Bill > > > > > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
