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
