But, to add my 2 cents, I just tried this on a huge table. Tally deldate1 from transxb where deldate1 like '9/%/2009' It snapped up immediately. Sure looks like an indexed search to me.
Things HAVE advanced since 1986! Dennis McGrath ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Dennis McGrath Sent: Thursday, November 05, 2009 1:16 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Birthday Search I guess you can tell who never attended. ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Bill Downall Sent: Thursday, November 05, 2009 12:10 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Birthday Search Dennis, That was in our David M. Blocker R:BASE training courses in 1986. Bill On Thu, Nov 5, 2009 at 1:00 PM, Dennis McGrath <[email protected]<mailto:[email protected]>> wrote: Well Bill, I've been around a looooong time and I never knew that would work. First time in all 24 years with RBASE that I have seen that syntax for dates. Go figure! Dennis McGrath ________________________________ From: [email protected]<mailto:[email protected]> [mailto:[email protected]<mailto:[email protected]>] On Behalf Of Bill Downall Sent: Thursday, November 05, 2009 11:41 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Birthday Search Is that a "duh!" moment for a few people? That capability has been around since R:BASE 2.11 or earlier. It's cold in Pittsburgh in the winter. Send coat money to Project Bundle-Up, c/o Donna Memon, R:BASE Technologies, 3935 Old William Penn Highway Murrysville, PA, 15668-1854 USA Bill On Thu, Nov 5, 2009 at 12:34 PM, George H Baker Charter <[email protected]<mailto:[email protected]>> wrote: My Thanks also. Bill, I include several date ranges in searches. Never knew that this was possible and it is very usable for my purposes. George ----- Original Message ----- From: Alastair Burr<mailto:[email protected]> To: RBASE-L Mailing List<mailto:[email protected]> Sent: Thursday, November 05, 2009 11:23 AM Subject: [RBASE-L] - Re: Birthday Search All these years and I never knew that you could do that with dates! Thanks, Bill, Regards, Alastair. From: Bill Downall<mailto:[email protected]> Sent: Thursday, November 05, 2009 5:15 PM To: RBASE-L Mailing List<mailto:[email protected]> Subject: [RBASE-L] - Re: Birthday Search Jennifer, Just use the wild card character! It won't use indexes, so if you have a million rows to search through, your 3-column strategy might pay off, but otherwise, just teach them to search like this: This presumes you use the default SQL wildcard character of %. If you use *, then replace the % with *. (To see what your current 'MANY' character is, at the R> prompt, type SHOW CHAR) 12/%/1990 -- anything in december, 1990 %/15/2009 -- anything on the 15th of any month in 2009 11/05/% -- anything on November 5, no matter what year Bill On Thu, Nov 5, 2009 at 12:04 PM, Roberts, Jennifer <[email protected]<mailto:[email protected]>> wrote: Hello, I seem to have quite a bit of 'brain fog' this morning and I am unable to figure out a good way to let my users search for their clients that have a birthday within selected dates. I am thinking that I should create a temp table of their clients and add a two columns, one to hold the integer month (IMON) and the other to hold the integer day (IDAY). Would this be the most efficient way or is there a function in RBASE that would allow me to search just the month and year of a date? Thank you in advance, Jennifer Roberts Business Applications Specialist Ohio Masonic Home This electronic message contains information from the Ohio Masonic Home, its operating subsidaiaries or affiliates. The information may be confidential, privileged or otherwise protected from disclosure. The information is intended to be received solely by [email protected]<mailto:[email protected]>, for use as designated in the message. If you are not the designated recipient, you are instructed not to review, disclose, copy, distribute orotherwise use of this transmission or its contents. If you have received this transmission in error, please notify the Ohio Masonic Home immediately at [email protected]<mailto:[email protected]>; in addition, please delete your record of transmission. Sending, receiving, downloading, displaying, printing material that is harassing, fraudulent, offensive, intimidating, defamatory, or otherwise unlawful or inappropriate is strictly prohibited by The Ohio Masonic Home. ________________________________ No virus found in this incoming message. Checked by AVG - www.avg.com<http://www.avg.com> Version: 9.0.698 / Virus Database: 270.14.50/2481 - Release Date: 11/04/09 19:51:00
