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.
_______________________________________________
use-livecode mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
