Android Question RDC + Interbase (Call to Store Procedure) SOLVED

[Heppy]

I have installed RDC and the Select, Update, Insert, statements work well.
I'm trying to call a store procedure. I searched the forum and have tried CALL EXEC and has not worked for me.
Into file config.properties:

DriverClass=interbase.interclient.Driver
JdbcUrl=jdbc:interbase://192.168.1.105/d:/semaforos/Gestion.ib

#SQL Server
#DriverClass=net.sourceforge.jtds.jdbc.Driver
#JdbcUrl=jdbc:jtds:sqlserver://<database server ip>/<database>
User=sysdba
Password=masterkey
ServerPort=17178
#If Debug is true then this file will be reloaded on every query.
#This is useful if you need to modify the queries.
Debug=true

#commands

sql.select_spsalidas=EXEC SALIDAS_MAN_IU ID=?,@ID1=?,@PIA1=?,@ID2=?,@PIA2=?,@ID3=?,@PIA3=?,@ID4=?,@PIA4=?,@ID5=?,@PIA5=?,@ID6=?,@PIA6=?

The Store Procedure have parameters of input:

ID
ID1
PIA1
ID2
PIA2
ID3
PIA3
ID4
PIA4
ID5
PIA5
ID6
PIA6

As should declare the command in the config to run well.

In the B4A Editor:

Dim cmd As DBCommand
Dim Name As String
cmd.Initialize
cmd.Name = "select_spsalidas"
cmd.Parameters = Array As Object(1,1,1,1,1,1,1,1,1,1,1,1,1)
'reqmanager is initialized
'reqManager.ExecuteCommand(cmd, 0)
reqManager.ExecuteQuery(cmd,0,"select_spsalidas")

I've tried with EXEC, CALL and many ways to define the variables.

Thank you very much for reading this post

 

[incendio]

I think, with interbase, you should call execute procedure salidas_man_iu.

 

[Erel]

Now that jRDC is available you can implement such queries on the server directly.

You can use SQL.CreateCallStatement and SQL.ExecCall to execute the call statement (in B4J).

 

[Heppy]

Thanks Erel and incendio

 

[Heppy]

Hi.
Could you tell me how to implement jRDC?
In the client, i copy the modules bas and add my project b4a?, also

reqManager.Initialize(Me, "http://192.168.1.105:17178/rdc")

But in the server?
Copy config.properties at directory remotebaseconnector and what parameters i edit in the file for conection Interbase.
In the jRDC.rar don't exist jRDC.jar
Thanks

Sorry is for B4J only

 

[Heppy]

Hi.
I solved the problem.
In the config properties the command:

sql.select_spsalidas=EXECUTE PROCEDURE SALIDAS_MAN_IU(?,?,?,?,?,?,?,?,?,?,?,?,?)

And the project:

Dim cmd As DBCommand
Dim Name As String
cmd.Initialize
cmd.Name = "select_spsalidas"
cmd.Parameters = Array As Object(1,1,1,1,1,1,1,1,1,1,1,1,2)
reqManager.ExecuteCommand(cmd, "select_spsalidas")

Thanks.