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/
