When you say the global is a calculation, do you mean it is defined as a calculation in Define Fields. Or you are using SetField to create the calculation?
Forbes -----Original Message----- From: FileMaker Pro Discussions [mailto:[EMAIL PROTECTED] On Behalf Of Lee Sent: 10 September 2008 11:17 To: [email protected] Subject: Re: Help major problem Forbes, The script works fine using the same global calculation for many records but sometimes it does not calculate correctly. This has become obvious when running the script many times that on rare occasions it will not work correctly on specific accounts. So I used the debugger and finally found that on some occasions this global field refused to calculate these two figures correctly. I cannot find out why as the very next account the script and this global field work fine. Without going into great detail an amount of money is paid against a client's many outstanding invoices so without having to calculate and pay off each invoice individually the script sorts the outstanding invoices by date then pays all the invoices off until it either runs out of money or the last invoice, if its the correct totaled amount. To do this a loop runs and after each payment it re calculates what is left to pay the next invoice. Its at this time the global filed is holding the amount still available to pay the next invoice and is used to pass the list of error catches to either continue or to exit the script. It works efficiently and perfectly well until some account just refuses to allow the global field to calculate correctly. Hence my dilemma. I'm going to see if I can do a work around to stop having to use the global field. Lee Mills Robertson, Forbes wrote: > Is the problem that you have a global -- and which context is it > referring to? A normal calc field refers to the current record. > > Forbes > > -----Original Message----- > From: FileMaker Pro Discussions [mailto:[EMAIL PROTECTED] > On Behalf Of Lee > Sent: 10 September 2008 10:58 > To: [email protected] > Subject: Help major problem > > Hi, > I have struck something I cannot come to grips with. I have a script > that uses a global field. That global field is a simple calculation of > two figures, payment-amount due. > I have a payment figure of $8,932 and an amount due of $198. The > difference is obviously $8,734 however the global field displays $8,701 > which is $33 different. If I change the global field to a non global > field it displays $8,734 the correct figure. When I change it back as a > global it again displays $8,701 completely wrong. > I have recreate a new global calc field to see if the field was corrupt > but every time I create a global field it gives the wrong answer. Has > anybody found this before and how do you fix it ? It only does it on > some clients not all. Sometimes it displays the correct calculated > figure but other times it displays the wrong calculated figure, a > totally useless scenario as you would appreciate. > > I've never struck this before and its driving me mad for something so > simple. The calculation is a 'number' and nothing is changed apart from > the field either being a global or a standard calc field but gives a > different calculated answer depending on its setting. > I have tried this file on both Mac and PC's with the same result, so if > you have any ideas please let me know. > FMP9.0v3 mac (Leopard) and PC(XP2) > -- -- ******************************************************************************** The information in this email and any files transmitted with it is confidential and may be legally privileged. It is intended solely for the addressee and others authorised to receive it. If you are not the intended recipient,, any disclosure, copying, distribution or action taken in reliance on its contents is prohibited and may be unlawful. Prospects Services Limited is a limited company registered in England and Wales. Reg No: 3042176 Registered Office: Prospects House, 19 Elmfield Road, Bromley, BR1 1LT. If you have received this email in error please notify: [EMAIL PROTECTED] http://www.prospects.co.uk This footnote also confirms that this email message has been swept for the presence of computer viruses ********************************************************************************
