Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Balance
Message
De
23/09/1998 12:48:52
Senna Dwipayana
Indo Rebel Apparel Cv
Bandung, Indonésie
 
 
À
23/09/1998 12:06:44
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Divers
Thread ID:
00139893
Message ID:
00139921
Vues:
33
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform