Stored procedures like using in livecode ..

Mark Waddingham mark at
Thu Dec 17 14:10:26 EST 2015

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:

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 Waddingham ~ mark at ~
LiveCode: Everyone can create apps

More information about the Use-livecode mailing list