Android Question jRDC Command not found in sql server how run dts (resolved)

Vania Contreras

Member
Licensed User
hi i am working with a jRDC conected to sql server and work, noy i want run a dts because i need run several task and pefer run only one, but when load que sql command

B4X: 
sql.set_inserta_Rollo_Traspaso_kardex=exec 'inserta_rollo_traspaso ?,?,?'
B4X: 
                Dim req As DBRequestManager = CreateRequest
                Dim cmd As DBCommand = CreateCommand("set_inserta_Rollo_Traspaso_kardex ?,?,?", Array(Cursor1.GetString("ORDEN"),Cursor1.GetString("LOTE"),Cursor1.GetString("ROLLO")))
                Wait For (req.ExecuteQuery(cmd, 0, Null)) JobDone(j As HttpJob)
then i get
*** Command not found: inserta_rollo_traspaso ?,?,?
Click to expand...
 
Last edited:
Sort by date Sort by votes

Vania Contreras

Member
Licensed User
in file config propieties set_inserta_Rollo_Traspaso_kardex is the command and inserta_rollo_traspaso is a dts that made several select, insert and update in the server

B4X: 
#SQL COMMANDS
#sql.create_table=CREATE TABLE IF NOT EXISTS animals (\
#     id INTEGER PRIMARY KEY AUTO_INCREMENT,\
#     name CHAR(30) NOT NULL,\
#     name CHAR(30) NOT NULL,\
#     image BLOB)
#sql.insert_animal=INSERT INTO animals VALUES (null, ?,?)
#sql.select_animal=SELECT name, image, id FROM animals
#where id_compañia in ('1','2','A')
sql.get_all_articulos=SELECT ncia,id_articulo,art_descripcion FROM android_articulos
sql.get_disponible=select * from android_disponible
sql.get_traspasos_entrada=select * from android_traspasosEntrada where id_suc_dest=1
sql.set_inserta_Rollo_Traspaso_kardex=exec 'inserta_rollo_traspaso ?,?,?'
sql.set_inserta_Rollo_Traspaso_kardex=insert into android_insert_traspaso values (?,?,?,getdate())
 
Upvote 0
You must log in or register to reply here.

Similar Threads

H
  • Question
Android Question Jrdc2 - Error on "CreateCommand(Name As String, Parameters() As Object) As DBCommand"
Replies
2
Views
739
Hishow
H
C
  • Question
Android Question jRDC2 server with stored procedures, I can't get values
Replies
0
Views
814
Carlos Mojica
C
J
  • Solved
B4J Question [B4X] jRDC2 - Issues with sql command not found
2
Replies
22
Views
5K
JDR
J
  • Question
Android Question jRDC2 - (Remote Database Connector)
Replies
5
Views
2K
Alexander Stolte
  • Question
Android Question [Solved]How can I update the records in multiple JRDC2 fields?
Replies
13
Views
2K
Johan Hormaza
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…