Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Mike Gagnon
  Where is Mike Gagnon?
 Pointe Claire
 Canada
 Mike Gagnon
 To: Liviu Antoniu
  Where is Liviu Antoniu?
 bucharest
 Romania
 Liviu Antoniu
 Tags
Subject: RE: grid
Thread ID: 78816 Message ID: 78825 # Views: 2 # Ratings: 1
Version: Visual FoxPro 7 Category: Grids
Date: Sunday, October 09, 2005 12:33:28 PM         
   


Create a cursor using an SQL statement based on your requirements and make the cursor the record source of your grid.
THISFORM.grid1.recordsource=''
 SELECT * from myTable where date_bank = myDate into cursor myAnswer
THISFORM.grid1.recordsource ='myAnswer'


> Hello guys!
> I'm a beginner in VFP and I need help. I have a grid who
> display records of one table. I want to display only some records.
> mytable contains the next records:
> customers, id_cust, date_invoice, date_bank, etc.
> I need to view in a grid only records with date_bank = variable. How make this?
> Please help me!
>
> Liviu


ENTIRE THREAD

grid Posted by Liviu Antoniu @ 10/9/2005 8:47:39 AM
RE: grid Posted by Mike Gagnon @ 10/9/2005 12:33:28 PM
RE: grid Posted by Liviu Antoniu @ 10/9/2005 7:44:38 PM
RE: grid Posted by Peter Wong @ 10/9/2005 12:50:50 PM
RE: grid Posted by Liviu Antoniu @ 10/9/2005 7:36:31 PM
RE: grid Posted by Marcia Akins @ 10/9/2005 3:16:07 PM
RE: grid Posted by Liviu Antoniu @ 10/9/2005 7:52:02 PM
RE: grid Posted by Marcia Akins @ 10/9/2005 8:32:28 PM
RE: grid Posted by Liviu Antoniu @ 10/9/2005 8:38:55 PM