Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Liviu Antoniu
  Where is Liviu Antoniu?
 Liviu Antoniu
 To: Marcia Akins
  Where is Marcia Akins?
 Ohio - United States
 Marcia Akins
Subject: RE: grid
Thread ID: 78816 Message ID: 78852 # Views: 1 # Ratings: 0
Version: Visual FoxPro 7 Category: Grids
Date: Sunday, October 09, 2005 7:52:02 PM         

So far I used browse command and now I want in order to display records, use a grid. But it's more difficult than browse command. In this grid I must make some modifies or delete a record and the cursor is read-only.
If you have some time please answer me.

> 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?

> The best way to do this is to create a parameterized view of your table. You can do this very easily in the view designer. Just select the table you want, select the fields, and on the filter tab specify the date field as the field name and put this in as the example: ?vp_date
> Use this parameterized view as the grid's RecordSource. If you have put it in the data environment in your form, make sure you set its NoDataOnLoad property to true. If you are opening the view in code, you need to use the NODATA keyword whenyou USE it.
> Now, whenever you want to change the data in the grid because you have selected a new date, all you needx is this code:
> LOCAL vp_date
> vp_date = << Some Value >>
> REQUERY( '<< My View Name >>' )
> Thisform.MyGrid.Refresh()

> For step by step instructions on how to use the view wizard, see the Local View Wizard topic in the on-line help.
> Regards,
> Marcia G. Akins
> Tightline Computers, Inc.



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