Each value in IN needs a ?, so in the example above you would need this in properties.config
B4X:
sql.xxx=SELECT Cat, prod, x FROM supprod where id = ? and idprodotto in(?,?,?,?)
and your DBCommand needs to be set like this
B4X:
Dim cmdList As DBCommand = Db.CreateCommand(Query, Array (X,"763043","763054","755123","759006"))
If your IN parameters are always fixed (like in this case with 4 elements), then the above will work great. If your IN parameters can vary, but only between a few cases, then this link (https://www.b4x.com/android/forum/t...martphone-to-jrdc2-server.111269/#post-693960) may provide a solution. If your IN parameters are completely random in quantity, then you'll have to do some coding and use dynamically created SQL statements.