Stored procedures like using in livecode ..
david alfredo zuñiga soto
david_alfredo_93 at hotmail.com
Thu Dec 17 16:39:59 EST 2015
Mr. Mark Waddingham
Hi !!!..
I really do not understand how you should use the SP responses ..Bug 13700 - Executing stored procedures in LiveCode with Parameters ..But nevertheless, I managed to run my SP with LiveCode and also I have been served with the library, revExecuteSQL ...Thank you very much for your help .. that tega good day, I hope I can continue to help is learning more .... !!!> Date: Thu, 17 Dec 2015 20:10:26 +0100
> From: mark at livecode.com
> To: use-livecode at lists.runrev.com
> Subject: Re: Stored procedures like using in livecode ..
>
> Hi David,
>
> On 2015-12-17 18:04, david alfredo zuñiga soto wrote:
> > Hello everyone, I'm new using this list, and good.I want to know how
> > to use stored procedures with SQL Server 2008 R2 on my LiveCode cards
> > ... anyone can help me? ..thanks..I'm using this code to run the SP
> > and does not work me.# put "EXECUTE @RC =
> > [DBPlaneacion].[dbo].[InsertarUsuarios]
> > '"&Nombre&"','"&Apellido&"','"&Correo&"','"&Celular&"','1','"&Contraseña&"'"
> > into tSQL revExecuteSQL ConID, tSQL
>
> Someone else had an issue working out how to do this... You can see the
> conversation in the thread on this quality center report:
>
> http://quality.livecode.com/show_bug.cgi?id=13700
>
> Comment #6 is probably the key one. If you want to return a result set,
> then you need to use revQueryDatabase, and use syntax like:
>
> {call test(:1)}
>
> Hope this helps,
>
> Mark.
>
> --
> Mark Waddingham ~ mark at livecode.com ~ http://www.livecode.com/
> LiveCode: Everyone can create apps
>
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
More information about the use-livecode
mailing list