actually this is just plain ole standard SQL statement, I use it to send out
birthday special stuff to customer's and want to find those with birthdates for
a selected date range, like those for the next two weeks or next month...
--find birthday customer's (FBC) for a date range
set var fbcv_sdate date=(addmon(.#date,-1))
set var fbcv_edate date=.#date
edit using FCB_SlctDates
set var fbcv_syn text
set var bcv_bdate date=(.fbcv_sdate)
delete from att_MailingLbl_Recs1
while fbcv_edate>.bcv_bdate then
set var fbcv_syn =('INSERT INTO att_MailingLbl_Recs1 ... SELECT ... FROM
Contact where Birthdate like
'+ctxt(IMON(.bcv_bdate))+'/'+ctxt(IDAY(.bcv_bdate))+'/%')
%fbcv_syn
set var bcv_bdate date=(addDAY(.bcv_bdate,1))
endwhile
----- Original Message -----
From: Dennis McGrath
To: RBASE-L Mailing List
Sent: Thursday, November 05, 2009 1:24 PM
Subject: [RBASE-L] - Re: Birthday Search
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]> 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]] 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]>
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
To: RBASE-L Mailing List
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
Sent: Thursday, November 05, 2009 5:15 PM
To: RBASE-L Mailing List
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]> 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], for use as designated in the
message. If you are notthe 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 immediatelyat [email protected]; in addition,
please delete your record of transmission. Sending, receiving, downloading,
displaying, printing material that is harassing, fraudulent, offensive,
intimidating, defamatory, or otherwiseunlawful or inappropriate is strictly
prohibited by The Ohio Masonic Home.
--------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 9.0.698 / Virus Database: 270.14.50/2481 - Release Date:
11/04/09 19:51:00
