Database Insert

[Mark Schonewille]

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.