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