Database Insert

[Nibor]

Hello,
I have a problem. I want to insert two things into my database with the same
"mouseUp" instruction.
The problem is that LiveCode only delivers the first part and ignores the
second part.
Can someone maybe help me with this ? I don't see what I did wrong..

Here's the code
______________________
global gDB
on mouseUp
   put field "fiuserid" into t1
   put field "finame" into t2
   put field "fiuser" into t3
   put field "fipw" into t4
   put "INSERT INTO [xxxxx].[xxxxx].[xxxxxx] (UserID,Name," && \
         "Benutzername,Passwort)" && \
         "VALUES (" & \
         ":1, :2, :3, :4)" into tSQL
   revExecuteSQL gDB, tSQL, "t1","t2","t3","t4"
   put the result into tRS
   put field "fiuserid" into t1
   put field "figrp" into t2
   put "INSERT INTO [xxxxx].[xxxxx].[xxxxxx](UserID,Gruppen)" && \
         "VALUES (" & \
         ":1, :2)" into tSQL
   revExecuteSQL gDB,tSQL, "t1","t2"
   put the result into tRS
end mouseUp
______________________________
One thing to make it clear the second insert goes to another table as the
first one.
If I put the second half of the code into an extra button it works..
But I want the whole thing in one button. 



--
View this message in context: http://runtime-revolution.278305.n4.nabble.com/Database-Insert-tp4657669.html
Sent from the Revolution - User mailing list archive at Nabble.com.