Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Prashant kulkarni
  Where is Prashant kulkarni?
 Mumbai
 India
 Prashant kulkarni
 To: Suresh Ramtekkar
  Where is Suresh Ramtekkar?
 Nagpur
 India
 Suresh Ramtekkar
 Tags
Subject: RE: Very Very Urgent
Thread ID: 311159 Message ID: 311165 # Views: 41 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: General VFP Topics
Date: Wednesday, June 29, 2011 11:47:56 AM         
   


Dear Suresh

Thankyou for respond but unfortunately it didnt work



> > Dear Experts
> >
> > My Data is As Follows
> >
> > Table1
> > ---------------
> > Party_No Eff_DATE Cash Discount
> > -------- ----------- --------------
> > BS056 01/04/2009 4
> > BS056 11/05/2009 4
> > BS056 21/07/2010 3
> >
> >
> >
> > Table2
> >
> > Party_No Invoice No Invoice date Cash Discount
> > -------- ------------ ----------------- ----------------------
> > BS056 INV0001 05/04/2009
> > BS056 INV0002 01/09/2010
> >
> >
> > Now what i require is Invoice date of Table2 to be searched in between the eff date of Table 1 and cash discount should be updated in table 2
> >
> >
> > Expected Result
> >
> > Party_No Invoice No Invoice date Cash Discount
> > -------- ------------ ----------------- ----------------------
> > BS056 INV0001 05/04/2009 4
> > BS056 INV0002 01/09/2010 3
> >
> >
> > Thanks in advance
>
> hi,
> try this
>
> select table2
> locate for table2.party_no = table2.party_no and table2.invoice date <= table1.Eff_DATE
> if found()
> replace table2.Cash Discount with table1.Cash Discount
> endif
>
>
>
> Regards
>
> Suresh Ramtekkar

ENTIRE THREAD

Very Very Urgent Posted by Prashant kulkarni @ 6/29/2011 10:33:21 AM
RE: Very Very Urgent Posted by Suresh Ramtekkar @ 6/29/2011 11:11:17 AM
RE: Very Very Urgent Posted by Prashant kulkarni @ 6/29/2011 11:47:56 AM
RE: Very Very Urgent Posted by Suresh Ramtekkar @ 6/29/2011 1:13:39 PM
RE: Very Very Urgent Posted by Cetin Basoz @ 6/29/2011 12:49:24 PM
RE: Very Very Urgent Posted by Prashant kulkarni @ 6/29/2011 1:14:49 PM