Albert, Yeah I think that would definitely be a good idea in this case. Thanks for the suggestion
-- Frank -- Frank Taylor, Systems Network Administrator -- F.J. O'Hara Corp, Boston, MA -- [EMAIL PROTECTED] - 617-790-3093 -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Albert Berry Sent: Monday, February 21, 2005 5:25 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Sum of Scrolling Region One solution to this is to put the data into a temp table while entering. This also gets around any possible conflicts in heavy traffic environments. Using the Temp table, only the one user sees the data until you append it to the true table. That makes it really easy to put a variable outside the region that sums the columns in the temp table. The second I can think of is to create a temp (ie user specific) view covering the exact data set being edited, and sum the view. --- Betaserver <[EMAIL PROTECTED]> wrote: > This might be one of those "wouldn't it be nice" thoughts.. I have a form > that has a scrolling > region on it.. I wanted to show the user the totals at the bottom of 2 of the > fields in the > region.. My First thought was create a eep code to calculate the sum of these > fields into a > variable and then place the variable label on the form, and update it after > leaving each row.. > But then I found that my data fields in the region had nothing in common with > each other to do a > good select statement on.. My work around came down to creating a unique > variable based on > datetime and computer id and putting a new column in the table and then > creating the eep to > calculate the totals and display them.. but then it gets messy when you leave > the form, go back > in and add / edit rows with multiple users. > I was thinking wouldn't it be nice if scrolling regions had the ability to > add a Footer or > Header to them that had basic functions like sum, count, avg etc. and would > perform those > functions on data that is currently in the region. Of course maybe a variant > of this function > already exists.. Right now I probably only know 2000 of the one million plus > neat features added > to RB 7.1 forms. Has anyone done something like this and maybe has a more > efficient solution > that I don't see ? > > -- Frank Taylor, Systems Network Administrator > -- F.J. O'Hara Corp, Boston, MA > -- [EMAIL PROTECTED] - 617-790-3093 > > ===== Albert Berry Management Consultant RR2 - 1252 Ponderosa Drive Sparwood BC, V0B 2G2 Canada (250) 425-5806 (250) 425-7259 (708) 575-3952 (fax) [EMAIL PROTECTED]
