Article View: borland.public.interbase.sql
Article #384Re: cumulative balance field
From: Isaac
Date: Thu, 08 May 2008 20:04
Date: Thu, 08 May 2008 20:04
20 lines
1736 bytes
1736 bytes
Ok guys, but I saw another solution used in the "Peachtree complete accounting" package it uses the client to update the "running balance". First no direct change in the window the user have to open another window to make the update, Then a global flag set for example "balance_need_update = true" and when the user close the window and the the balance window get the focus a small progress bar appear indicating of fixing the balance. this scenario did not occur if no change happened and also controlled by the current selected period of the year (3 months) and the update occur from the modified record down to the end of the selected period so it take few seconds. it is also in my opinion more light to do the calculation on the client with executing SQLs than using triggers and procedures on the server in case of 50 user using the software. What do you think ?
Technical Details
Message-ID:
<48235cbc@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!news.glorb.com!news.isoc.lu!newsgroups.borland.com!not-for-mailReferences:
<4822380f@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 114a0e,7fe0f2b0b1ac1758 X-Google-Attributes: gid114a0e,domainid0,public,usenet X-Google-Language: ENGLISH,ASCII-7-bit Date: Thu, 08 May 2008 23:04:01 +0300 From: Isaac <no@no.com> User-Agent: Thunderbird 2.0.0.12 (Windows/20080213) MIME-Version: 1.0 Newsgroups: borland.public.interbase.sql Subject: Re: cumulative balance field References: <4822380f@newsgroups.borland.com> In-Reply-To: <4822380f@newsgroups.borland.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit NNTP-Posting-Host: 41.234.201.151 Message-ID: <48235cbc@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1210277052 41.234.201.151 (8 May 2008 13:04:12 -0700) Lines: 20 Path: arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!news.glorb.com!news.isoc.lu!newsgroups.borland.com!not-for-mail