Very clever Bill... I'm going to try it right now. Thanks. ~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/
