Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: jared fernandez
  Where is jared fernandez?
 Caloocan City
 Philippines
 jared fernandez
 To: Ken Murphy
  Where is Ken Murphy?
 Springhill
 Canada
 Ken Murphy
 Tags
Subject: RE: Using check box in a grid
Thread ID: 152798 Message ID: 154710 # Views: 3 # Ratings: 0
Version: Visual FoxPro 6 Category: Grids
Date: Wednesday, December 19, 2007 1:51:39 AM         
   


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

Thank you sir Ken! Aside from what i learn from you people here, i also use msdn and ask my fellow programmers here. i also try to mix up some of the things i learned from the msdn but if still it doesn't work, that's the time i post my questions here. Thanks for the reminder though. =) God bless!

"The hope that changed a second chance I’ve gained."

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