B4J Question Can I send a part of sql string from smartphone to jrdc2 server

[yfleury]

I need to spend more argument for the same column. Is it possible to do it like this

Dim item1 as string="ok"
Dim ManyItem as string=" and ("
For x=0 to myListItem2.size - 1
 if x=0 then
  ManyItem = ManyItem " item2=" & item2myListItem2.get(x)
 else
   ManyItem = ManyItem " or item2=" & item2myListItem2.get(x)
 end if
next
ManyItem = ManyItem & ")"
Dim cmd As DBCommand = CreateCommand("select_mytable", Array(item1)

On jrdc2 server

sql.select_mytable= select * from table where item1 = ?  ? order by item3

Can I do this?

 

[OliverA]

Not without modifying the source of jRDC2 server to handle dynamic SQL statements. If the number of items in myListItem2 are limited (let's say up to 10), then another approach, that does not involve dynamically creating SQL queries, may be to add the following to your config properties file:

sql.select_mytable1= select * from table where item1 = ? order by item3
sql.select_mytable2= select * from table where item1 in (?, ?) order by item3
sql.select_mytable3= select * from table where item1 in (?, ?, ?) order by item3
'... and so on

and on the client side you could do

Dim cmd as DBCommand = CreateCommand($"select_mytable${myListItem2.size}"$, item2myListItem2)

Note: No error checking (that myListItem2 contains more elements than statements created, etc.)

 

[yfleury]

item1 may have 1 to more of 25 items for the query

 

[OliverA]

You'll then need to modify jRDC to allow for dynamic SQL. You could adapt the approach in this link: https://www.b4x.com/android/forum/threads/variable-table-name-through-jrdc.83262/.