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


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