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: m...@livecode.com
> To: use-livecode@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 ~ m...@livecode.com ~ http://www.livecode.com/
> LiveCode: Everyone can create apps
>
> _______________________________________________
> 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
_______________________________________________
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