Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: David Mustakim
  Where is David Mustakim?
 Jakarta
 Indonesia
 David Mustakim
 To: Shaheryar Rashed
  Where is Shaheryar Rashed?
 Multan
 Pakistan
 Shaheryar Rashed
 Tags
Subject: RE: array result issue
Thread ID: 395696 Message ID: 395699 # Views: 33 # Ratings: 2
Version: Visual FoxPro 9 SP2 Category: Forms
Date: Friday, January 17, 2014 11:38:05 AM         
   


> Hi Experts!
>
> my code is:
>
>
LOCAL lnMhd1, lnHr1, mlntot1
> STORE 0 TO lnMhd1, lnHr1, mlntot1
> lnHr1  = 10
> lnMhd1 = 25
> mlntot1 = (lnHr1 * lnMhd1)*3600
> SUM(mlntot1) to array laTotalTime1
> WAIT WINDOW laTotalTime1
> 

>
> it should be 900000 but it returns 4 times multiplied result. guide me please


Here is the explanation to your confusion:
SUM command will run (execute the summing) repeatedly as many times as the number of records of a table / cursor that is active at that particular time it is run and store the end-result to the variable (somehow not sure why you use array thou). For example when I ran it just now I got 76500000 as a result of 10 * 25 * 3600 * 85(= reccount of my active cursor at the moment)

So.. you need to always be fully aware of behaviors of certain / all commands

Aaah, post beaten by Vilhem - my processor speed is lame ! :-)

David

ENTIRE THREAD

array result issue Posted by Shaheryar Rashed @ 1/17/2014 11:11:21 AM
RE: array result issue Posted by Stefan Wuebbe @ 1/17/2014 11:25:59 AM
RE: array result issue Posted by Borislav Borissov @ 1/17/2014 11:38:15 AM
RE: array result issue Posted by Vilhelm-Ion Praisach @ 1/17/2014 11:53:40 AM
RE: array result issue Posted by Shaheryar Rashed @ 1/17/2014 12:08:54 PM
RE: array result issue Posted by Vilhelm-Ion Praisach @ 1/17/2014 12:25:24 PM
RE: array result issue Posted by Stefan Wuebbe @ 1/17/2014 12:27:42 PM
RE: array result issue Posted by Shaheryar Rashed @ 1/17/2014 12:12:11 PM
RE: array result issue Posted by Stefan Wuebbe @ 1/17/2014 2:06:52 PM
RE: array result issue Posted by Vilhelm-Ion Praisach @ 1/17/2014 11:36:21 AM
RE: array result issue Posted by David Mustakim @ 1/17/2014 11:38:05 AM
RE: array result issue Posted by Shaheryar Rashed @ 1/17/2014 12:06:14 PM
RE: array result issue Posted by David Mustakim @ 1/17/2014 12:31:32 PM
RE: array result issue Posted by Vilhelm-Ion Praisach @ 1/17/2014 12:23:05 PM