Hello,
1) I switched to -tShortfall because I was not seeing a negative value. The
result is the same whether I have -tShortfall or tShortfall. Do you get
negative values to appear in your fields?
2) When I hit the previous button the record stays on the current record. I
can go forward successfully, hit previous button (nothing happens), and then
go forward again successfully. I can only get to the first entry again by
refreshing the SQL. I am using the button exactly as it is shown in the
video example.
Thank you
All best Always
Fred
From: Ken Ray <[EMAIL PROTECTED]>
Reply-To: How to use Revolution <use-revolution@lists.runrev.com>
To: Use Revolution List <use-revolution@lists.runrev.com>
Subject: Re: Some Foolish questions
Date: Tue, 04 Oct 2005 15:26:19 -0500
On 10/4/05 3:10 PM, "Fred Giannetto" <[EMAIL PROTECTED]> wrote:
> Hello Everyone,
>
> 1) Absolute value question. Here is a copy of the script.
> I want input values over 10 to create a deficit in the Consumer and
Foreign
> fields. Example, a user puts 15 into the Reserves field. It is
subtracted
> from 20 putting the remainder into tReserves. tReserves is less then 10
so
> it has 10 subtracted from it, it is divided by 2 resulting in -2.5 into
> tConsumer but I only see 2.5.
Well, the script puts 'tShortfall / 2 into tConsumer', which would put -2.5
into tConsumer, but when it goes into the field, you have 'put -tConsumer
into field "Consumer"', which puts "2.5" into fld "Consumer" because:
-tConsumer
is the same as
-1 * tConsumer
which is:
-1 * -2.5 = 2.5
So I think if you set it to put "tConsumer" instead of "-tConsumer" you
should get what you're expecting.
> 2. I am using the database property "move to previous record" for the
> previous record button and it is setup to access the correct query. I
have
> created two queries using Microsoft Access driver and Microsoft do
Access
> driver. I have attempted to connect with both of them and they exhibit
the
> same symptoms. I can only go forward and refresh. The MySQL connection
> works without any problems.
What happens when you try to go to the previous record what happens - do
you
stay on the current one? Or do you get some other result?
Ken Ray
Sons of Thunder Software
Web site: http://www.sonsothunder.com/
Email: [EMAIL PROTECTED]
_______________________________________________
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
_______________________________________________
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution