Also consider this systax: where adate between .date1 and .date2 it should make better use of the index on the adate column
Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Paul Buckley Sent: Friday, June 21, 2013 12:50 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Form Question in 9.5(64) Thanks Albert & Jan, I'll look at these. Paul -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Albert Berry Sent: Friday, June 21, 2013 11:59 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Form Question in 9.5(64) On the form put two date pickers as Jan suggested, referring to the two variables On the date pickers use an onClick eep to refresh the table. PROPERTY TABLE <appointments> 'REFRESH' That should work for you Albert On 21/06/2013 9:52 AM, jan johansen wrote: > Paul, > > I may have been hasty. My previous answer was based on an "unbound" form. > If you wish you can give me a call 503.449.4024. > > Jan > > -----Original Message----- > From: "Paul Buckley" <[email protected]> > To: [email protected] (RBASE-L Mailing List) > Date: Fri, 21 Jun 2013 11:35:37 -0400 > Subject: [RBASE-L] - Form Question in 9.5(64) > >> Group, >> >> I'm using the latest build of 9.5.3.20611. I have a form opened using >> an Edit Using command with a where clause, say: edit using >> appointments where adate >= .date1 and adate <= .date2. I'd like to >> put a button on the form so the user can change the date range by >> picking a new date and reloading the form from the button. I keep >> going in circles on this. Any help would be greatly appreciated. >> >> Thanks, >> Paul Buckley >> >> > > > > ----- > No virus found in this message. > Checked by AVG - www.avg.com > Version: 2013.0.3345 / Virus Database: 3199/6429 - Release Date: > 06/21/13 > >
