Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Balance
Message
From
23/09/1998 12:48:52
Senna Dwipayana
Indo Rebel Apparel Cv
Bandung, Indonesia
 
 
To
23/09/1998 12:06:44
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00139893
Message ID:
00139921
Views:
31
What I meant is if I have 5 column in a grid or table :
column #1 -- Date
Column #2 -- Description
Column #3 -- income
Column #4 -- Expense
Column #5 -- Balance

To count the balance field, usually I do like this :
Select (mytable)
Scan
mrec=RECNO()
SELECT SUM(out-in) FROM (mytable) WHERE RECNO() mbalance=total+in-out
REPLACE balance WITH mbalance
ENDSCAN

THIS Procedure take to long, specially if I edited a record in the middle, so I have to start all over again.

Hope you understand what I'm trying to explain....

Thanks a lot
Senna Dwipayana
Being good is better
Being better is a bless
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform