Weird error with a format browse formula... 
Author Message
 Weird error with a format browse formula...

I have this weird problem, i have a format-browse formula that sums itself
+an adyacent value. Everything works just fine and it calculates everything
perfect.
BUT if i press the END key, everything get's messed up. the formula starts
calculating from the last record instead of the first one!

example

|   Deposit    |   Withdraw   |     Balance    |
------------------------------------------
 $17,000.00 |                     | $ 17,000.00 |
-------------------------------------------
                    |    $ 10,000   | $   7,000.00 |
-------------------------------------------
As you can see the formula acts just fine. BUT if i press the END key....

|   Deposit    |  Withdraw   |      Balance    |
------------------------------------------
 $17,000.00 |                     | $   7,000.00 |
-------------------------------------------
                    |    $ 10,000   | -$10,000.00 |
-------------------------------------------

As you can see, the formula starts calculating from the LAST record instead
the first one as it already did.

How can i froze the formula after running it once?
or how can i force the formula to start with the FIRST or LAST record
ALWAYS?

My formula is
Balance = Balance + (Deposit - Withdraw)
Format Browse...

Thank you in advance...

BTW some ppl told me the actual Clarionmag issue is talking about this error
and the way to solve it, since it's NOT a free article and i don't have 80
bucks for a suscription. any info ouside clarionmag would be grately
appreciated..



Wed, 11 Feb 2004 04:24:55 GMT  
 Weird error with a format browse formula...
See responses on other NGs.

--

Steve Parker

Knowledge base: www.par2.com/cws/c5launch.dll/faqs/theFaqs.exe.0
Download Center: www.cwicweb.com/apps/c5launch.dll/d7.exe.0


Quote:
> I have this weird problem, i have a format-browse formula that sums itself
> +an adyacent value. Everything works just fine and it calculates
everything
> perfect.
> BUT if i press the END key, everything get's messed up. the formula starts
> calculating from the last record instead of the first one!

> example

> |   Deposit    |   Withdraw   |     Balance    |
> ------------------------------------------
>  $17,000.00 |                     | $ 17,000.00 |
> -------------------------------------------
>                     |    $ 10,000   | $   7,000.00 |
> -------------------------------------------
> As you can see the formula acts just fine. BUT if i press the END key....

> |   Deposit    |  Withdraw   |      Balance    |
> ------------------------------------------
>  $17,000.00 |                     | $   7,000.00 |
> -------------------------------------------
>                     |    $ 10,000   | -$10,000.00 |
> -------------------------------------------

> As you can see, the formula starts calculating from the LAST record
instead
> the first one as it already did.

> How can i froze the formula after running it once?
> or how can i force the formula to start with the FIRST or LAST record
> ALWAYS?

> My formula is
> Balance = Balance + (Deposit - Withdraw)
> Format Browse...

> Thank you in advance...

> BTW some ppl told me the actual Clarionmag issue is talking about this
error
> and the way to solve it, since it's NOT a free article and i don't have 80
> bucks for a suscription. any info ouside clarionmag would be grately
> appreciated..



Tue, 10 Feb 2004 09:46:11 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Format Browse Formula Problem

2. weird error (X error of failed request)

3. Browse Formulas in ODBC

4. Browse Formulas in SQL

5. Weird browse color problem ...

6. Weird Browse Behavior

7. Weird Browse behavior

8. Weird Browse Problem CW5b

9. Weird Browse/form behavior X3

10. CW4: Formula Editor lacking move formula

11. Error in formulas with MSSQL

12. Internal Error:Invalid Formula (RW)

 

 
Powered by phpBB® Forum Software