Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem in GRID with calculate column
Message
 
To
30/01/2007 14:54:54
Luis Santos
Biglevel-Soluções Informáticas, Lda
Portugal
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:
01190608
Views:
13
>Hello Borislav
>
>I must need to store the result of calculation in the table, because i must keep this value on them and if i changed the original controlsource of my columns that is "FI.U_VALHUM" to ((0+fi.u_nospeso-fi.u_VLDscemb)*fi.u_hum)/100, when i save my invoice my sql table loose this calculation value , the field FI.U_VALHUM = 0
>
>Also if like i said by some line of code i can know the colunm index numbers, i can write
>replace FI.U_VALHUM with QTT*100 for example, and also without changing controlsource.
>
>in fact , my program use remote views to send values to sql server database.
>
>I hope you understand.
>
>thanks
>Luis Santos

No Luis, Sorry.
I still don't understand WHY YOU NEED to keep calculated values in the table. This is not a good design. Maintenance is a nightmare and you always can get that calculated values back whenever you want (especially if your backend is SQL Server).
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform