Hi, What is stored in tRS?
-- Best regards, Mark Schonewille Economy-x-Talk Consulting and Software Engineering Homepage: http://economy-x-talk.com Twitter: http://twitter.com/xtalkprogrammer KvK: 50277553 Use Color Converter to convert CMYK, RGB, RAL, XYZ, H.Lab and other colour spaces. http://www.color-converter.com We have time for new software development projects. Contact me for a quote. On 28 nov 2012, at 08:54, Nibor wrote: > 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. _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode