Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: mike castillo
  Where is mike castillo?
 Joo Seng Road, Singapore
 mike castillo
 To: mike Demosthenous
  Where is mike Demosthenous?
 mike Demosthenous
Subject: RE: sql problem
Thread ID: 22932 Message ID: 22936 # Views: 1 # Ratings: 0
Version: Visual FoxPro 7 Category: Databases, Tables and SQL Server
Date: Wednesday, April 30, 2003 10:41:57 AM         

> Hi to all,
> I have created an sql statement .
> The select part is working ok but when i use the ''where'' clause in order to select two dates.
> I get all sort of errors (error no 11 etc..)
> What i want to do is to have the user enter two dates in a form and then process a report based on these two dates.
> Thanking you in advance.
> Regards
> Mike

Hi Tukayo Mike! :)

try this;
select * from table where thisform.date1.value >= date and thisform.date2.value <= date into cursor Myreport order by date


sql problem Posted by mike Demosthenous @ 4/30/2003 8:15:16 AM
RE: sql problem Posted by mike castillo @ 4/30/2003 10:41:57 AM