Database Insert
Mark Schonewille
m.schonewille at economy-x-talk.com
Wed Nov 28 05:18:31 EST 2012
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.
More information about the use-livecode
mailing list