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


> 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