Local view involving date (Posted by Jacky) - www.foxite.com

From: Jacky


	Australia
	Jacky

Tags

Local view involving date Jacky Local view involving date

Subject:	Local view involving date
Thread ID:	21949	Message ID:	21949	# Views:	26	# Ratings:	0
Version:	Visual FoxPro 6		Category:	Databases, Tables and SQL Server
Date:	Saturday, April 05, 2003 6:59:00 AM

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