Using a card to make modifications to database

[Fred Giannetto]

Here is a copy of my script.  The point is for users to enter data into the 
card and the submit button have the data inserted into the database.  The 
sql works when submitted directly into the database.

on mouseUp
  put field "Name" into tName
  put field "Team" into tTeam
  put field "Position" into tPosition
  put field "Rushing" into tRushing
  put field "Receiving" into tReceiving
  get revOpenDatabases("MYSQL", "localhost", "test", root, root1)
  put it into tDatabaseID
  answer tName, tTeam, tPosition, tRushing, tReceiving, tDatabaseID
  revExecuteSQL tDatabaseID,"insert into test.nflstats(Name, Team, Position, 
Rushing, Receiving) values(tName, tTeam, tPosition, tRushing, tReceiving)"
end mouseUp

I have the tDatabaseID variable to make sure I am recording the Database ID

Thank you for your assistance, There will be a lot of progress once I get 
past these elementary hurdles
All best Always
Fred

>From: "Fred Giannetto" <fgiannet at hotmail.com>
>Reply-To: How to use Revolution <use-revolution at lists.runrev.com>
>To: use-revolution at lists.runrev.com
>Subject: Using a card to make modifications to database
>Date: Tue, 04 Oct 2005 19:00:36 -0400
>
>Hello,
>
>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
>Fred
>
>
>>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 
>>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: kray at sonsothunder.com
>>
>>_______________________________________________
>>use-revolution mailing list
>>use-revolution at 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 at lists.runrev.com
>Please visit this url to subscribe, unsubscribe and manage your 
>subscription preferences:
>http://lists.runrev.com/mailman/listinfo/use-revolution