Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: BZ Dusk
  
 
 
 BZ Dusk
 To: munir hossain
  Where is munir hossain?
 dhaka
 Bangladesh
 munir hossain
 Tags
Subject: RE: DELETE RECORDS BETWEEN DATE RANGE INPUT BY ...
Thread ID: 16052 Message ID: 16070 # Views: 1 # Ratings: 0
Version: Unknown Category: General VFP Topics
Date: Tuesday, October 08, 2002 8:12:41 PM         
   


> Hello Expert,
>
> I WANT TO DELETE RECORDS FROM A TABLE BETWEEN TWO DATE RANGE( LIKE 09/12/01 TO 10/12/01)
> AND ADD A CONDITION LIKE PEOPLE WHO LIVE IN "CA" AND I WANT TO INPUT THOSE VALUES
> (TWO DATES AND PLACE NAME = "CA" ) BY FORM(FORM HAS THREE TEXT BOXS AND ONE COMMAND BUTTON ).
> PLEASE TELL ME HOW IAM GONNA DO IT.
> THANKS FOR YOUR LAST SOLVEMENT.
>
>

Hi!

I'm not an expert but i hope this will help -

SELECT MYTABLE
DELETE ALL FOR BETWEEN(dDatefield,ctod('09/12/01'),ctod('10/12/01'))

BZ

ENTIRE THREAD

DELETE RECORDS BETWEEN DATE RANGE INPUT BY FORM Posted by munir hossain @ 10/8/2002 7:03:33 AM
RE: DELETE RECORDS BETWEEN DATE RANGE INPUT BY ... Posted by BZ Dusk @ 10/8/2002 8:12:41 PM
RE: DELETE RECORDS BETWEEN DATE RANGE INPUT BY ... Posted by Pete Sass @ 10/8/2002 11:42:36 PM
RE: DELETE RECORDS BETWEEN DATE RANGE INPUT BY ... Posted by munir hossain @ 10/9/2002 9:34:14 AM
RE: DELETE RECORDS BETWEEN DATE RANGE INPUT BY ... Posted by Pete Sass @ 10/9/2002 1:54:21 PM
RE: DELETE RECORDS BETWEEN DATE RANGE INPUT BY ... Posted by munir hossain @ 10/9/2002 5:11:01 PM