Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Sum function causes form bleed through
Message
De
31/08/2001 07:26:12
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
30/08/2001 21:25:39
Thomas Ianuzzi
Information Security Consultants, Inc.
Floride, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00551188
Message ID:
00551292
Vues:
12
>I am using the table sum function in the after row/col click event in a grid on the form and sending the results to variables
>
>Example:
>SUM TABLE.COLUMN TO RESULT
>
>It works fine but produces bleedthrough of the result to the form. Replacing the grey of the form with a small whit box containing the word sum and the relult.
>
>Is there a way to avoid this

Thomas,
It's 'set talk on' behaviour. 'Set talk' like some other 'set's are scoped to current datasession. In form.load or DE.beforeopentables add a 'set talk off'.

You would have another problem with summing on grid source, record pointer moves. Also if this is a parent-child situation summing many child records unnecessarily again and again in ARCC might be a performance penalty.
In a parent-child case consider :
-Tableupdates almost always done before parent record changes.
-Once a tableupdate is done SQL could return up-to-date data
-Subsequent summing could only be done on fields affecting the result w/o an actual sum but by subtracting old from sum and adding new value. This greatly improves performance IMHO.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform