Stored procedures like using in livecode ..

[Mark Waddingham]

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