Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem in GRID with calculate column
Message
From
02/02/2007 17:26:57
Luis Santos
Biglevel-Soluções Informáticas, Lda
Portugal
 
 
To
02/02/2007 08:52:30
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01190586
Message ID:
01192033
Views:
20
Hello Edward


Firstly, erase your code (and don't touch AFTERROWCOLCHANGE, please). Secondly, tell me now what is your grid.recordsource : my GRID.recordsource is FI (that is the table of lines of my invoice)
Thirdly, give meaningful names to grid.columns, e.g. colMoistness,colQuanity etc.

The EVENT AFTERROWCOLCHANGE is one of the events i have for choose, in this case is this one i want to use because i thin that is the correct.


i go use your column names:
FI.U_GrossWeight (Gross Weight)
FI.U_colMoistness (value of moistness)
FI.QTT (quantity)
FI.PERmoistness (% Moistness)

Calculations :
FI.U_GrossWeight =12000,00
FI.PERmoistness = 5%
FI.U_colMoistness = 600,00 (12000,00*5/100)
FI.QTT = 12000,00-600,00= 11400,00

I hope that was all you need .

Many thanks for your interest to help me.

Best regards
Luis Santos
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform