Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Jamie Osborn
  Where is Jamie Osborn?
 Melbourne
 Australia
 Jamie Osborn
 To: munir hossain
  Where is munir hossain?
 dhaka
 Bangladesh
 munir hossain
 Tags
Subject: RE: QUERY BY FORM INPUT VALUE
Thread ID: 15994 Message ID: 16004 # Views: 1 # Ratings: 0
Version: Unknown Category: General VFP Topics
Date: Sunday, October 06, 2002 2:24:48 PM         
   


> HELLO,
> i WANT TO MAKE A QUERY BETWEEN TWO DATE RANGE( LIKE 09/12/01 TO 10/12/01)AND I WANT TO INPUT
> THOSE DATE BY FORM(FORM HAS TWO TEXT1 BOXS).PLEASE TELL ME HOW IAM GONNA DO IT.
>
>
ldFrom = thisform.txtFrom.Value
ldTo = thisform.txtTo.Value

SELECT MyFields ;
  FROM MyTable ;
WHERE BETWEEN(MyTable.MyDate,ldFrom,ldTo) ;
INTO CURSOR MyResult


To be safe - initialise the textboxes to either empty dates or default dates that make sense :
thisform.txtFrom.Value = {}
thisform.txtTo.Valoue = {}


Cheers,
Jamie
jamie.osborn@foxite.com

ENTIRE THREAD

QUERY BY FORM INPUT VALUE Posted by munir hossain @ 10/6/2002 11:32:37 AM
RE: QUERY BY FORM INPUT VALUE Posted by Jamie Osborn @ 10/6/2002 2:24:48 PM