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

Heppy · Oct 22, 2015

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 · Oct 22, 2015

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

Erel · Oct 22, 2015

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 · Oct 22, 2015

Thanks Erel and incendio

Heppy · Oct 23, 2015

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 · Oct 23, 2015

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.

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

Heppy

Active Member

incendio

Well-Known Member

Erel

B4X founder

Heppy

Active Member

Heppy

Active Member

Heppy

Active Member

Similar Threads

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

Heppy

Active Member

incendio

Well-Known Member

Erel

B4X founder

Heppy

Active Member

Heppy

Active Member

Heppy

Active Member

Similar Threads

Privacy & Transparency

Privacy & Transparency