Android Question [Solved] Sql Store Procedure

Alex_197 said:

so return something from your stored procedure

Click to expand...

Spavlyuk said:

Use

SQL:

RETURN SELECT 1

Click to expand...

Alberto Salinas said:

Thanks for reply

Now

i Return 1

But Now i get this msg

(SQLException) java.sql.SQLException: The executeQuery method must return a result set.

Click to expand...

Bladimir Silva Toro said:

hello @Alberto Salinas

See the example of how to handle the input and output parameters of a stored procedure in the following link: https://www.b4x.com/android/forum/threads/sql-simplyfying-calling-stored-procedures.73181/

I hope it helps

Click to expand...

Alex_197 said:

Sorry for a late response

Modify your procedure to something like this

UPDATE tblMytable set Name=@Name where id=@ID - assume that this line does the update.

Then at the end add this line - or something like this

SELECT * from tblMyTable where id=@ID - this line returns a recordset

Click to expand...

            Dim sf As Object = mysql.CreateCallStatement("{call AgregaPago(?,?,?,?,?,?,?,?,?)}", Array(Main.NtagPago,Main.IdUsuario,Main.Nombre,Main.MacId,PEDIDOS.total,Pagar.CadenaG,PEDIDOS.Referencia ,Main.GrupoProd,PEDIDOS.orden ))
            Dim crsr As JdbcResultSet=mysql.ExecCall(sf)
            CursorToLog( crsr )