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: 311176 # Views: 37 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: General VFP Topics
Date: Wednesday, June 29, 2011 1:13:39 PM         
   


Dear Prashant

try this, it definately work and tested

*********
Close All

Select 0
Use table1 Alias table1
Select 0
Use table2 Alias table2


Select table2
Go Top
Do While Not Eof()
	Select table1
	Go Top
	Scan While table1.party_no = table2.party_no AND table2.inv_date > table1.eff_date And Not Eof()
		If Eof()
			Exit
		Endif
	Endscan
	Skip -1
	Select table2
	Replace table2.cash_disc With table1.cash_disc

	Select table2
	Skip
Enddo
********


> Dear Suresh
>
> Thankyou for respond but unfortunately it didnt work
>
>
>
> >
> > 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