Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Ken Murphy
  Where is Ken Murphy?
 Springhill
 Canada
 Ken Murphy
 To: jared fernandez
  Where is jared fernandez?
 Caloocan City
 Philippines
 jared fernandez
 Tags
Subject: RE: Using check box in a grid
Thread ID: 152798 Message ID: 154622 # Views: 4 # Ratings: 0
Version: Visual FoxPro 6 Category: Grids
Date: Tuesday, December 18, 2007 12:49:55 PM         
   


> >
> > What are you using for your grid's .RecordSource and .RecordSourceType?
> >
> > Ken
> > You shall know the truth - and the truth shall set you free. (John 8:33)
>
> Sir ken! I "accidentally fix" the problem. I rearrange my data environment tables and their relationships, and when i run the program, i notice that the problem was no longer there. However, i got another question. I am now working on the items on my grid. My checkbox will determine which of the items are going to be saved on my table. But before i save them, i need to get the total of the items with tick marks. i have a column of totalcost, which i need to get the total. Thanks sir in advance!
>
> "The hope that changed a second chance I’ve gained."

Several methods:

SELECT SUM(TotalCost) FROM MyGridCursor WHERE lMyTickColumn INTO CURSOR csrTotals
* or
SELECT MyGridCursor
CALCULATE SUM(MyGridCursor.TotalCost) for MyGridCursor.lMyTickColumn TO m.lnCursorTotal 
* or
SELECT MyGridCursor
m.lnCursorTotal = 0
SCAN
   IF MyGridCursor.lMyTickColumn
      m.lnCursorTotal = m.lnCursorTotal + MyGridCursor.TotalCost
   ENDIF
ENDSCAN


If you cannot find at least three ways to do something in VFP you are not really trying :)

Ken
You shall know the truth - and the truth shall set you free. (John 8:33)

ENTIRE THREAD

Using check box in a grid Posted by jared fernandez @ 11/29/2007 2:07:30 AM
RE: Using check box in a grid Posted by Claudine Uniana @ 11/29/2007 3:26:22 AM
RE: Using check box in a grid Posted by jared fernandez @ 11/29/2007 6:31:47 AM
RE: Using check box in a grid Posted by Ken Murphy @ 11/29/2007 3:51:33 AM
RE: Using check box in a grid Posted by jared fernandez @ 11/29/2007 6:38:14 AM
RE: Using check box in a grid Posted by Ken Murphy @ 11/29/2007 1:22:00 PM
RE: Using check box in a grid Posted by jared fernandez @ 12/3/2007 7:50:10 AM
RE: Using check box in a grid Posted by Ken Murphy @ 12/3/2007 12:19:50 PM
RE: Using check box in a grid Posted by jared fernandez @ 12/4/2007 1:27:06 AM
RE: Using check box in a grid Posted by jared fernandez @ 12/7/2007 9:44:03 AM
RE: Using check box in a grid Posted by tushar @ 12/7/2007 10:49:51 AM
RE: Using check box in a grid Posted by jared fernandez @ 12/10/2007 2:20:19 AM
RE: Using check box in a grid Posted by Ken Murphy @ 12/7/2007 12:51:14 PM
RE: Using check box in a grid Posted by jared fernandez @ 12/10/2007 2:24:02 AM
RE: Using check box in a grid Posted by tushar @ 12/10/2007 8:14:42 AM
RE: Using check box in a grid Posted by Ken Murphy @ 12/10/2007 12:26:41 PM
RE: Using check box in a grid Posted by jared fernandez @ 12/11/2007 8:51:21 AM
RE: Using check box in a grid Posted by Ken Murphy @ 12/11/2007 1:25:28 PM
RE: Using check box in a grid Posted by jared fernandez @ 12/12/2007 2:25:49 AM
RE: Using check box in a grid Posted by Christian Pano @ 12/12/2007 4:04:22 AM
RE: Using check box in a grid Posted by jared fernandez @ 12/12/2007 9:51:04 AM
RE: Using check box in a grid Posted by Christian Pano @ 12/12/2007 11:09:44 AM
RE: Using check box in a grid Posted by jared fernandez @ 12/14/2007 2:49:24 AM
RE: Using check box in a grid Posted by Christian Pano @ 12/14/2007 4:21:21 AM
RE: Using check box in a grid Posted by jared fernandez @ 12/14/2007 7:11:26 AM
RE: Using check box in a grid Posted by jared fernandez @ 12/14/2007 9:33:16 AM
RE: Using check box in a grid Posted by jared fernandez @ 12/18/2007 9:52:54 AM
RE: Using check box in a grid Posted by jared fernandez @ 12/17/2007 3:25:38 AM
RE: Using check box in a grid Posted by Ken Murphy @ 12/17/2007 1:11:11 PM
RE: Using check box in a grid Posted by jared fernandez @ 12/18/2007 8:49:29 AM
RE: Using check box in a grid Posted by Ken Murphy @ 12/18/2007 12:49:55 PM
RE: Using check box in a grid Posted by jared fernandez @ 12/19/2007 1:51:39 AM
RE: Using check box in a grid Posted by jared fernandez @ 1/10/2008 6:50:26 AM
RE: Using check box in a grid Posted by Ken Murphy @ 1/10/2008 1:14:14 PM
RE: Using check box in a grid Posted by jared fernandez @ 1/11/2008 2:09:43 AM
RE: Using check box in a grid Posted by Ken Murphy @ 1/11/2008 1:05:31 PM
RE: Using check box in a grid Posted by jared fernandez @ 1/7/2008 9:58:03 AM
RE: Using check box in a grid Posted by Ken Murphy @ 1/7/2008 1:29:15 PM
RE: Using check box in a grid Posted by jared fernandez @ 1/8/2008 1:12:30 AM
RE: Using check box in a grid Posted by jared fernandez @ 1/9/2008 4:35:55 AM
RE: Using check box in a grid Posted by Ken Murphy @ 1/9/2008 5:30:36 PM
RE: Using check box in a grid Posted by jared fernandez @ 1/10/2008 2:00:25 AM
RE: Using check box in a grid Posted by Ken Murphy @ 1/10/2008 2:57:15 AM
RE: Using check box in a grid Posted by jared fernandez @ 1/10/2008 6:38:33 AM
RE: Using check box in a grid Posted by Ken Murphy @ 1/10/2008 1:14:52 PM
RE: Using check box in a grid Posted by tushar @ 11/29/2007 8:24:27 AM
RE: Using check box in a grid Posted by jared fernandez @ 12/3/2007 7:39:01 AM
RE: Using check box in a grid Posted by Christian Pano @ 11/29/2007 9:34:03 AM
RE: Using check box in a grid Posted by jared fernandez @ 12/3/2007 7:42:33 AM
RE: Using check box in a grid Posted by ruel parayno @ 12/3/2007 3:45:52 PM
RE: Using check box in a grid Posted by jared fernandez @ 12/4/2007 1:30:23 AM
RE: Using check box in a grid Posted by Alan Tuscano @ 1/9/2008 6:10:08 AM
RE: Using check box in a grid Posted by jared fernandez @ 1/9/2008 6:54:14 AM
RE: Using check box in a grid Posted by Alan Tuscano @ 1/10/2008 12:41:23 AM
RE: Using check box in a grid Posted by jared fernandez @ 1/10/2008 2:13:41 AM
RE: Using check box in a grid Posted by Alan Tuscano @ 1/11/2008 6:04:18 AM