Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Using function sum
Message
De
21/04/2015 16:15:39
Luis Santos
Biglevel-Soluções Informáticas, Lda
Portugal
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Using function sum
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01618914
Message ID:
01618914
Vues:
54
Hello comunity

I would like to know if i can use an alias with the sum function.

Suppose i have several client orders like This:

Article quantity requested. Quantity in invoice. rest.
B001 30. 10. 20.
B001. 25. 0. 25

Now i introduce my supplier order request
Article. Qtt
B001. 30

I make the scan for my clients order and i must check the quantity That i can satisfy with my supplier order.
Then for the for the first line of my client order, i can satisfy 20 (30-20) the rest on supplier order is equal to 10.
I Need to keep the value of 10, because for the line 2 of my client order the value is 25, then i can only satisfy the value of quantity 10.

If i use :
Sum qtt into my cursor crssupplier

I lost the value of 10 because the scan have move the focus the the secund line of my client orders.

Is it possible to use the value stored in my cursor crssupplier with an aliás?, in This case when the cursor move to the line 2 of my client order, the value of rest must be equal to 15.

Many thanks,
Best regards
Luis santos
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform