victormedranop Well-Known Member Licensed User Longtime User Jul 25, 2018 #1 hi, I am trying to run an store procedure with declaration parameter, but a haven't found the way to do that. anyone with and working example. I can connect, run query but no lock with store procedure. I am using mssql-jdbc-6.2.2.jre8. sample procedure B4X: DECLARE @RC int DECLARE @CodigoCliente varchar(8)='10000180' EXECUTE @RC = [odbcRead].[__OrdenesIDIS] @CodigoCliente GO thanks, Victor Last edited: Jul 25, 2018
hi, I am trying to run an store procedure with declaration parameter, but a haven't found the way to do that. anyone with and working example. I can connect, run query but no lock with store procedure. I am using mssql-jdbc-6.2.2.jre8. sample procedure B4X: DECLARE @RC int DECLARE @CodigoCliente varchar(8)='10000180' EXECUTE @RC = [odbcRead].[__OrdenesIDIS] @CodigoCliente GO thanks, Victor
Erel B4X founder Staff member Licensed User Longtime User Jul 25, 2018 #2 Might be helpful: https://www.b4x.com/android/forum/threads/sql-stored-procedure-with-1-parameter.57726/#post-363352 Upvote 0
Might be helpful: https://www.b4x.com/android/forum/threads/sql-stored-procedure-with-1-parameter.57726/#post-363352
K keirS Well-Known Member Licensed User Longtime User Jul 25, 2018 #3 I wrote a library to call stored procedures. Although the example is MySQL it will work with any JDBC driver. https://www.b4x.com/android/forum/threads/sql-simplyfying-calling-stored-procedures.73181/#content Upvote 0
I wrote a library to call stored procedures. Although the example is MySQL it will work with any JDBC driver. https://www.b4x.com/android/forum/threads/sql-simplyfying-calling-stored-procedures.73181/#content