Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Angelo Andales
  Where is Angelo Andales?
 Manila
 Philippines
 Angelo Andales
 To: Jun Tangunan
  Where is Jun Tangunan?
 Cabanatuan
 Philippines
 Jun Tangunan
 Tags
Subject: RE: Please Help with query
Thread ID: 416280 Message ID: 416337 # Views: 27 # Ratings: 0
Version: Visual FoxPro 9 Category: General VFP Topics
Date: Saturday, December 27, 2014 8:09:10 AM         
   


> Just by looking at the image, you are having a grid reconstruction issue. Read this: http://sandstorm36.blogspot.com/2011/12/grid-reconstruction-why-how-and-when-it.html?m=1
>
> P.S.
>
> Better put into a local variable the right side of the WHERE condition and use that variable instead there.
>
> As for clearing the repeated dates, your cursor should be on readwrite so you can do a scan... endscan then replace xdate with {} on those dates
>

Many Thanks Jun, I already solve the grid turns white issue. I read your blog and it helps me.

As of the repeated date issue actually the other one which I encircle should not appear since the customer only pay once as of the moment. I already inserted the readwrite after cursor name but I can not figure out how to construct the code for checking if the PayDate and Amount is the same with other records.

ENTIRE THREAD

Please Help with query Posted by Angelo Andales @ 12/26/2014 2:51:32 AM
RE: Please Help with query Posted by Anders Altberg @ 12/26/2014 5:08:33 PM
RE: Please Help with query Posted by Ali Koumaiha @ 12/26/2014 5:37:27 PM
RE: Please Help with query Posted by Angelo Andales @ 12/27/2014 6:53:02 AM
RE: Please Help with query Posted by Jun Tangunan @ 12/26/2014 10:41:44 PM
RE: Please Help with query Posted by Angelo Andales @ 12/27/2014 8:09:10 AM
RE: Please Help with query Posted by Jun Tangunan @ 12/27/2014 8:25:51 AM