Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Jun Tangunan
  Where is Jun Tangunan?
 Cabanatuan
 Philippines
 Jun Tangunan
 To: Angelo Andales
  Where is Angelo Andales?
 Manila
 Philippines
 Angelo Andales
 Tags
Subject: RE: Please Help with query
Thread ID: 416280 Message ID: 416338 # Views: 30 # Ratings: 0
Version: Visual FoxPro 9 Category: General VFP Topics
Date: Saturday, December 27, 2014 8:25:51 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.

Glad to know that helps. As for repeated date, that would happen if the child table has more than one record from the result of the join. That is normal on header and details table.

In which case, should you really not want it shown, then you can replace those fields with empty dates and zeroes via scan... endscan or do while... enddo approach; and implement a format of z later.

Also look for ony too's drilldown grid. Maybe that can work on your need here.

https://vfpx.codeplex.com/releases/view/99045
http://sandstorm36.blogspot.com

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