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

[Vania Contreras]

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

sql.set_inserta_Rollo_Traspaso_kardex=exec 'inserta_rollo_traspaso ?,?,?'

                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 ?,?,?

 

[Erel]

The command name is: set_inserta_Rollo_Traspaso_kardex

Not: set_inserta_Rollo_Traspaso_kardex ?, ?, ?

 

[Vania Contreras]

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

#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())

 

[Erel]

As I wrote, the command name shouldn't include the question marks.

   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)

 

[Vania Contreras]

Great, work fine