Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Yuri Rubinov
  Where is Yuri Rubinov?
 Philadelphia
 Pennsylvania - United States
 Yuri Rubinov
 To: Jacky
  Where is Jacky?
 
 Australia
 Jacky
 Tags
Subject: RE: Local view involving date, addition
Thread ID: 21949 Message ID: 22207 # Views: 1 # Ratings: 0
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Friday, April 11, 2003 5:21:01 PM         
   


Additionally to my previous post. It related to VFP6. In VFP 7 it works with strictdate 1 too.

> Hello Yuri Rubinov,
>
> I just type
USE MyView
. Then, Vfp will ask for a date because I have set the condition in the view.
> A friend told me to go to option setting and set strict date to 0. It works. However, why can't we keep the option (strict date to 1)?
>
> Thanks in advance.
> Jacky
>
> > I cannot reproduce the behavior, so it is something in your code, I believe. How do you do it exactly "directly in command mode"?
> >
> >
> > > Yuri Rubinov,
> > > I tried {^2003-04-05}, but it does NOT work.
> > > Thanks in advance.
> > > Jacky
> > >
> > > > Try {^2003-04-05} instead.
> > > >
> > > > > Hello, all
> > > > > I have a local view that has a condition set: dRefDate <= ?thisform.RefDate
> > > > > There is no problem when I open it with code. However, when I open it directly in command mode,
> > > > > I enter a strict date {^2003-4-5} but it does not accept and say I must use strict date format. What's wrong?
> > > > > How should we open it in command mode?
> > > > >
> > > > > Thanks in advance.
> > > > > Jacky


COMPLETE THREAD

Local view involving date Posted by Jacky @ 4/5/2003 6:59:00 AM
RE: Local view involving date Posted by Yuri Rubinov @ 4/7/2003 4:11:36 PM
RE: Local view involving date Posted by Jacky @ 4/8/2003 3:07:47 AM
RE: Local view involving date Posted by Yuri Rubinov @ 4/8/2003 3:06:21 PM
RE: Local view involving date Posted by Jacky @ 4/11/2003 3:08:34 AM
RE: Local view involving date Posted by Yuri Rubinov @ 4/11/2003 5:17:00 PM
RE: Local view involving date, addition Posted by Yuri Rubinov @ 4/11/2003 5:21:01 PM
Thanks a lot. Posted by Jacky @ 4/16/2003 2:31:07 AM