Using a card to make modifications to database
fgiannet at hotmail.com
Tue Oct 4 18:00:36 CDT 2005
Trying to have a card submit changes to MySQL database. The syntax for
revExecuteSQL requires me to use database ID.
How do I do this as the database ID is always changing. I have used the
revOpenDatabase function to get it but the ID did not seem to work (I have
the right priviledges) and I want the card to be able to apply changes
everytime without modifications.
All best Always
>From: Ken Ray <kray at sonsothunder.com>
>Reply-To: How to use Revolution <use-revolution at lists.runrev.com>
>To: Use Revolution List <use-revolution at 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" <fgiannet at hotmail.com> 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
> > fields. Example, a user puts 15 into the Reserves field. It is
> > from 20 putting the remainder into tReserves. tReserves is less then 10
> > 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:
>is the same as
> -1 * tConsumer
> -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
> > created two queries using Microsoft Access driver and Microsoft do
> > driver. I have attempted to connect with both of them and they exhibit
> > 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
>stay on the current one? Or do you get some other result?
>Sons of Thunder Software
>Web site: http://www.sonsothunder.com/
>Email: kray at sonsothunder.com
>use-revolution mailing list
>use-revolution at lists.runrev.com
>Please visit this url to subscribe, unsubscribe and manage your
More information about the use-livecode