Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Kulwant Singh
  Where is Kulwant Singh?
 Shimla
 India
 Kulwant Singh
 To: sunil madhav
  Where is sunil madhav?
 
 United Kingdom
 sunil madhav
 Tags
Subject: RE: Calendar Control in VFP
Thread ID: 248804 Message ID: 248840 # Views: 2 # Ratings: 0
Version: Visual FoxPro 6 Category: Active X Controls & OLE Automation
Date: Wednesday, December 23, 2009 5:48:39 PM         
   


> Hi,
>
> I have used the Olecontrol for the calendar in VFP 6.0.
>
> I have a table where the books has a date and i have a form in which there are two calendars i.e from && to.
> whenever i select a date FROM and date TO it has to get the details of the dates given in the form and should get the details from the table.
>
> I have tried to do but not able to get the details from the table..
>
> can any one help me.
>
> thnaks
> sunil

IMHO there could be an error at two places.

1. You are not getting/putting proper date values to the "FROM_DATE" and "TO_DATE" variables through the OLE "Calender Control"

For example if you are using
select * from yourtable where yourtable.datefield >= FROM_DATE and yourtable.datefield <= TO_DATE

Check to see if FROM_DATE and TO_DATE are VALID.

OR

2. The error could be in the LINES of code you are using to get "Details" from the table.
Can you post the code that you are using to extract details from the table?

3. It is also possible there is no data for that period in the Table

kulwant
(Help Save the TIGER. Save Wildlife. Live & let Live)

ENTIRE THREAD

Calendar Control in VFP Posted by sunil madhav @ 12/23/2009 1:32:31 PM
RE: Calendar Control in VFP Posted by ho me @ 12/23/2009 2:41:02 PM
RE: Calendar Control in VFP Posted by Yuri Rubinov @ 12/23/2009 2:58:17 PM
RE: Calendar Control in VFP Posted by sunil madhav @ 12/30/2009 12:29:27 PM
RE: Calendar Control in VFP Posted by Yuri Rubinov @ 12/30/2009 2:28:30 PM
RE: Calendar Control in VFP Posted by Jun Tangunan @ 12/23/2009 4:03:43 PM
RE: Calendar Control in VFP Posted by kulwant singh @ 12/23/2009 5:48:39 PM
RE: Calendar Control in VFP Posted by Khurram Khan Khan @ 12/24/2009 9:14:46 AM
RE: Calendar Control in VFP Posted by kulwant singh @ 12/24/2009 6:55:54 PM
RE: Calendar Control in VFP Posted by Khurram Khan Khan @ 12/25/2009 1:50:16 PM
RE: Calendar Control in VFP Posted by Khurram Khan Khan @ 12/26/2009 8:34:17 AM
RE: Calendar Control in VFP Posted by kulwant singh @ 12/26/2009 3:14:43 PM
RE: Calendar Control in VFP Posted by M. Akram Bhatti @ 12/30/2009 1:00:56 PM