Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem in GRID with calculate column
Message
 
À
30/01/2007 14:54:54
Luis Santos
Biglevel-Soluções Informáticas, Lda
Portugal
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01190586
Message ID:
01190608
Vues:
14
>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform